4 ms·

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

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 !

mstipetic 4mo ago
Did you have a look at https://evidence.dev https://evidence.dev
joren- 4mo ago
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 https://github.com/GhentCDH/Pihka
iLoveOncall 4mo ago
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 4mo ago
  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 4mo ago
    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 4mo ago
      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 4mo ago
    duckdb -ui
    - mpeg 4mo ago
      Data engineers hate this one simple trick
uberex 4mo ago
Like MS Access on web?
- jumpkick 4mo ago
  Imagine if this were built into browsers and you only had to serve a SQLite file.
  - simonw 4mo ago
    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/ https://lite.datasette.io/ My more recent prototype shrinks that to 10.47 MB transferred: https://simonw.github.io/research/pyodide-asgi-browser/datasette.html https://simonw.github.io/research/pyodide-asgi-browser/datas...
dsego 4mo ago
Something like sync engines? I think there are a bunch nowadays. https://syntax.fm/show/924/sync-engines-and-local-data https://syntax.fm/show/924/sync-engines-and-local-data
potatoman22 4mo ago
It's not specific to SQLlite per se, but that's what most dashboard builders are

mstipetic 4mo ago

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

joren- 4mo ago

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 https://github.com/GhentCDH/Pihka

iLoveOncall 4mo ago

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 4mo ago
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 4mo ago
  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 4mo ago
    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 4mo ago
  duckdb -ui
  - mpeg 4mo ago
    Data engineers hate this one simple trick

uberex 4mo ago

Like MS Access on web?

jumpkick 4mo ago
Imagine if this were built into browsers and you only had to serve a SQLite file.
- simonw 4mo ago
  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/ https://lite.datasette.io/ My more recent prototype shrinks that to 10.47 MB transferred: https://simonw.github.io/research/pyodide-asgi-browser/datasette.html https://simonw.github.io/research/pyodide-asgi-browser/datas...

dsego 4mo ago

Something like sync engines? I think there are a bunch nowadays. https://syntax.fm/show/924/sync-engines-and-local-data https://syntax.fm/show/924/sync-engines-and-local-data

potatoman22 4mo ago

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