←back to thread

Sqlite3 WebAssembly

(sqlite.org)
545 points whatever3 | 2 comments | | HN request time: 0.001s | source
Show context
outlore ◴[] 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. matlin ◴[] No.41854685[source]
I've made just this!

Docs for it: https://www.triplit.dev/docs/frameworks/tanstack-router#exam...

It by default uses IndexedDB but can also use SQLite but does real time, relational querying and (optionally) syncs with you server.

Re: developer ergonomics, this is our primary focus so I don't love to get your feedback on!

replies(1): >>41855413 #
2. outlore ◴[] No.41855413[source]
thanks for sharing! will take a look :)