News for hackers. Stuff that matters.
Re:Show HN: Screenr – Automated Workflow for Your Email by jasode on Friday July 10, 2020 @07:21AM (#23790352)
>All your email is stored in a big sqlite file.

Are you talking about "global-messages-db.sqlite" ? From cursory googling, that's only an index.[1] The default storage for Thunderbird is mbox format not SQLite.

When I experiment with some SQL queries on "global-messages-db.sqlite", I notice that many of my gmail emails are not in that index cache.

[1] http://forums.mozillazine.org/viewtopic.php?f=39&t=2861483*

Re:Show HN: Screenr – Automated Workflow for Your Email by Groxx on Saturday July 11, 2020 @08:53PM (#23807658)
Though that won't give you full content, in case your intended logic needs that: is the fact that it's an index a problem? That seems ideal, for performance reasons.

Purely because I'm curious, as a user who might end up doing this: are those messages perhaps not synced locally? And/or if you delete the cache and rebuild, do they appear? Or are there just some kinds of messages that intentionally don't appear in that index?