1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11

#!/usr/bin/python3

import re
import psycopg2

conn = psycopg2.connect(dbname="mastodon_production")
cur = conn.cursor()
cur.execute('SELECT * FROM statuses')
statuses = cur.fetchall()
text = [re.sub(r'<[^>]*>', '', status[2]) for status in statuses]
print(text[0:100])