Follow
I'm begging developers to please index the data they're storing locally in their apps so that it can be fast. I get IndexedDB users are kinda cooked if you also want encryption at rest, but folks using Sqlite have no excuse.
@mauve have you encountered a web library that stores local data and indexes?
@rosano IndexedDB does this and is built into the web. 🤷 That's what I use if I don't need at rest encryption. I usually wrap it in `idb` so that I can get a nice promise based API. Most other "databases" offered on the web are just extra steps on top of this. Turso is also decent but needs more dependency bytes and might not work everywhere.
I really *want* to love Matrix, but their data model and approach to data storage is so annoying from a performance perspective. They pretty much mandate doing full text searches with decryption on every single row which just *does not* scale as you grow your message history / room count. 🤢