3 ms·

SQLite is amazing. But after having worked with it for many years now, I believe it should never be a platform-level API, and not standardizing it for browsers

SQLite is amazing. But after having worked with it for many years now, I believe it should never be a platform-level API, and not standardizing it for browsers was the right choice. SQLite has a _lot_ of great features. Many of them only introduced in recent versions, and many of them are optional extensions enabled at compile-time. There is no feasible way to standardize this to get the same functionality across all browsers. IndexedDB may not be great to work with (at least not without helper libraries), but at least the API surface is small, and much easier to ensure you get the same behaviour in all browsers. I'd rather advocate for a proper block-level filesystem API that could be used as backing storage for a WASM SQLite library.

throw_m239339 5y ago
> SQLite is amazing. But after having worked with it for many years now, I believe it should never be a platform-level API, and not standardizing it for browsers was the right choice. No it was never the right choice and it didn't need to become standardized at first place. Writing a query builder is an easy task, implementing a RDBMS on top of indexedDB, ironically implemented on top of SQlite in Firefoxis a much harder tasks. IndexedDB is absolutely atrocious API wise, and largely useless to query structured data.
bwindels 5y ago
> I'd rather advocate for a proper block-level filesystem API that could be used as backing storage for a WASM SQLite library. This is happening at https://web.dev/storage-foundation/ https://web.dev/storage-foundation/ fwiw