1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15

#!/usr/bin/python3

import re
import psycopg2

# Fetch messages from database since it's way faster than using the API
conn = psycopg2.connect(dbname="mastodon_production")
cur = conn.cursor()
cur.execute('SELECT * FROM statuses')
statuses = cur.fetchall()

# Get the messages as plain text
text = [re.sub(r'<[^>]*>', '', status[2]) for status in statuses]  # Use regex to remove HTML stuff
print(text[0:100])