←back to thread

Sqlite3 WebAssembly

(sqlite.org)
545 points whatever3 | 1 comments | 15 Oct 24 17:45 UTC | HN request time: 0.205s | source
Show context
chrysoprace ◴[15 Oct 24 22:23 UTC] No.41853741[source]▶
I've been really interested in the local-first landscape lately but embedding SQLite seems really heavy-weight compared to using the browser's built-in storage APIs (in particular, IndexedDB) and it seems to be what most of the main open source libraries do. I'm interested to see a open-source solution (with sync) which provides an SQLite-like API but for the browser's native storage rather than trying to embed another executable in Web Assembly.
replies(3): >>41854044 #>>41854825 #>>41855967 #
gavmor ◴[16 Oct 24 01:41 UTC] No.41854825[source]▶
SQL is, arguably, more ergonomic than IndexedDB APIs, and may take up less RAM/CPU when, eg, using a `WHERE` clause rather than an `if() ` filter.
replies(1): >>41856054 #
1. chrysoprace ◴[16 Oct 24 06:06 UTC] No.41856054[source]▶
It's definitely more ergonomic, but the browser doesn't have an SQL API where as it does have IndexedDB. I'm hoping for tooling that makes IndexedDB more ergonomic while having a local-first syncing solution.

Dexie gives an ORM-like experience but their syncing solution is not FOSS.