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 !

▲

joren- 2 days ago | parent | next [-]

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

▲

mstipetic 2 days ago | parent | prev | next [-]

Did you have a look at https://evidence.dev

▲

dsego 2 days ago | parent | prev | next [-]

Something like sync engines? I think there are a bunch nowadays.

https://syntax.fm/show/924/sync-engines-and-local-data

▲

potatoman22 2 days ago | parent | prev | next [-]

It's not specific to SQLlite per se, but that's what most dashboard builders are

▲

uberex 2 days ago | parent | prev | next [-]

Like MS Access on web?

▲

jumpkick 2 days ago | parent [-]

Imagine if this were built into browsers and you only had to serve a SQLite file.

	▲	simonw 2 days ago \| parent [-]
		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...

▲

iLoveOncall 2 days ago | parent | prev [-]

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.).

▲

mpeg 2 days ago | parent [-]

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.

▲

simonw 2 days ago | parent | next [-]

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.

	▲	mpeg 2 days ago \| parent [-]
		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

▲

uberex 2 days ago | parent | prev [-]

duckdb -ui

	▲	mpeg 2 days ago \| parent [-]
		Data engineers hate this one simple trick