3 ms·
>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 defa
by jasode 6y ago
>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* http://forums.mozillazine.org/viewtopic.php?f=39&t=2861483*
- Groxx 6y agoThough 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?