←back to thread

What If OpenDocument Used SQLite?

(www.sqlite.org)
275 points whatisabcdefgh | 1 comments | 04 Sep 25 21:36 UTC | HN request time: 0s | source
Show context
supportengineer ◴[04 Sep 25 23:03 UTC] No.45133233[source]▶
What if instead of API's for data sets, we simply placed a sqlite file onto a web server as a static asset, so you could just periodically do a GET and have a local copy.
replies(4): >>45133260 #>>45133305 #>>45133319 #>>45133437 #
1. anon291 ◴[04 Sep 25 23:34 UTC] No.45133437[source]▶
You can do this today by using the WASM-compiled SQLite module with a custom Javascript VFS that implements the SQLite VFS api appropriately for your backend. I've used it extensively in the past to serve static data sets direct from S3 for low cost.

More industrious people have apparently wrapped this up on NPM: https://www.npmjs.com/package/sqlite-wasm-http