6 ms·
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
by roomey 6y ago
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!) ?
- bachmeier 6y agoI 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