I never understood why someone hasn't made a framework that makes it stupidly easy to fill an HTML page with SQLite database tables, with all the usual display controls, and with as much "liveness" as desired, and with a protocol (over HTTPS) to manage comms to a server-side instance. SQLite is robust, lightweight, bulletproof - a WASM build belongs on ALL the webpages !
As mentioned below I have been building the 'read' side of this: a data publication platform. I wanted to avoid any server side components. The communication / write part and updating the server-side sqlite database would need running components on the server which I wanted to avoid.
The 'write' part would technically be very doable and not that different from other back-ends.
https://github.com/GhentCDH/Pihka
Did you have a look at https://evidence.dev
It's not specific to SQLlite per se, but that's what most dashboard builders are
Something like sync engines? I think there are a bunch nowadays.
https://syntax.fm/show/924/sync-engines-and-local-data
Like MS Access on web?
Imagine if this were built into browsers and you only had to serve a SQLite file.
I have a version of Datasette that runs entirely in the browser (using Pyodide and WebAssembly) and it's smaller than a lot of modern React homepages (12.35MB):
https://lite.datasette.io/
My more recent prototype shrinks that to 10.47 MB transferred: https://simonw.github.io/research/pyodide-asgi-browser/datas...
Because it's pretty much worthless.
You almost never need just a basic list of all the data in your table, even if you're able to filter and sort it. There's no moat there at all. People need serious BI tools, and that throws simplicity out of the window (PowerBI, QuickSight, etc.).
I disagree, a lot of the time people buy "serious BI tools" precisely because they think they need all that power and complexity.
In reality, what most people need is much simpler, a mini app with some curated datasets and simple filters, maybe some AI querying if we want to get fancy. There's some companies out there that work with big data, but for the rest of us small data is ok.
I think of Datasette as a "small data" platform, where small data is anything that would fit on my phone.
My phone has 1TB of storage.
I've used that with companies I consult for, everyone thinks they should do what Google does, so sometimes I'll drop them the "your whole company data fits in my phone/laptop" line to make them understand the (lack of) scale
duckdb -ui
Data engineers hate this one simple trick