Hi, On Fri, Jan 21, 2022 at 1:46 AM Kai Engert <[email protected]> wrote:
> For a storage need in Thunderbird, a new application functionality, > we're evaluating which storage technology we should use, either SQLite > or IndexedDB. > > My initial thought was to use SQLite. > It's worth noting the (now ancient) document counseling to avoid SQLite at https://wiki.mozilla.org/Performance/Avoid_SQLite_In_Your_Next_Firefox_Feature . I personally don't agree with much of what is written, but the general thrust at that time was that we had a growing number of (independent) SQLite databases that could be made into simple JSON files. Almost all were made into JSON files, helping performance significantly. Without context on the shape, size, and access patterns of your data, you're very unlikely to get impactful suggestions that address your use case. I will say that `SQLite.jsm` is very unlikely to go away in a reasonable time frame. The key-value store `rkv` may be an option for you, but it is not as sure a bet as `SQLite.jsm`. Best, Nick -- You received this message because you are subscribed to the Google Groups "[email protected]" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/mozilla.org/d/msgid/dev-platform/CAMnWBR3Otf-wD%3D6bu9OOhutPDY7%3DCXkE5vMtBn05QeSF8VEZkg%40mail.gmail.com.
