←back to thread

Sqlite3 WebAssembly

(sqlite.org)
506 points whatever3 | 3 comments | 15 Oct 24 17:45 UTC | HN request time: 0.611s | source
Show context
outlore ◴[15 Oct 24 18:05 UTC] No.41851272[source]▶
i’ve been looking for a Tanstack Query style library that is backed by Sqlite (backed by OPFS or some other browser storage) and syncs with an API in the background. Does anything like that exist? i’ve seen ElectricSQL and other sync engines but they are a bit opinionated. I’m pretty new to local-first but i feel like the developer ergonomics are not quite there yet

Meanwhile for “local-only” it would be great to use sqlite in the browser + native file system API so that the db could be stored on the user’s file system and we wouldn’t have to worry about browser storage eviction. i think that could really open up a whole world of privacy preserving offline software delivered through the browser

replies(4): >>41851366 #>>41851613 #>>41851686 #>>41854685 #
1. gagik_co ◴[15 Oct 24 18:38 UTC] No.41851686[source]▶
I have working to replicate TanStack query experience by writing my own queries wrapped around PowerSync, although actually on Flutter (using Flutter Hooks! which was cool to use coming from React). It’s a very internal design meant for my app tetr[1] right now (and actually being migrated over from Realm). I am hoping to potentially standardize it and publish a package once it’s mature enough but not too wrap to make your own hooks around them for your needs.

[1] https://tetr.app

replies(1): >>41855415 #
2. outlore ◴[16 Oct 24 03:47 UTC] No.41855415[source]▶
very cool product page!
replies(1): >>41856313 #
3. gagik_co ◴[16 Oct 24 06:59 UTC] No.41856313[source]▶
thank you!