News for hackers. Stuff that matters.
Re:Show HN: Screenr – Automated Workflow for Your Email by roomey on Thursday July 09, 2020 @06:16PM (#23785889)
Oh I've been looking for something like this forever. I'm ok with SQL.

My idea is to be able to manage my mail through thunderbird but also have the ability to hook in with python (and SQL is the way)

Do you have a write up or some examples anywhere (I'm trying to learn Godot at the moment so any shortcuts would be so useful!) ?

Re:Show HN: Screenr – Automated Workflow for Your Email by bachmeier on Thursday July 09, 2020 @07:59PM (#23786675)
I haven't written anything up (maybe I should) but it's easy enough.

In Thunderbird, go to Help -> Troubleshooting Information -> Profile Directory.

That opens your profile directory. In there is a file global-messages-db.sqlite that holds all your messages. Treat that as read-only. If it does get messed up for some reason, you can delete it. It's an index that will get rebuilt.

If you close Thunderbird, you can open the db in sqlitebrowser to view the tables. Some tables I've used for queries:

folderLocations - tells you the id of each email folder

messages - metadata for each message

messagesText_content - subject, recipients, body of each email message

conversations - info about your email threads that can be matched with data in messages to retrieve full email threads