logoalt Hacker News

andersmurphylast Saturday at 7:32 PM1 replyview on HN

Even easier with sqlite thanks to litestream.


Replies

westurneryesterday at 5:32 AM

datasette and datasette-lite (WASM w/pyodide) are web UIs for SQLite with sqlite-utils.

For read only applications, it's possible to host datasette-lite and the SQLite database as static files on a redundant CDN. Datasette-lite + URL redirect API + litestream would probably work well, maybe with read-write; though also electric-sql has a sync engine (with optional partial replication) too, and there's PGlite (Postgres in WebAssembly)