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 !
Like MS Access on web?
Datasette Apps: Host custom HTML applications inside Datasette
41–50 of 76 posts
Re: Datasette Apps: Host custom HTML applications inside Datasette
#42Re: Datasette Apps: Host custom HTML applications inside Datasette
#43I just went through the github project repository. It has 119 repositories. Is this how AI slop looks like in code? Made for the agents, by the agents? Is this separation of concerns or context management with agents as a first class residents and humans merely acting as custodians?
Most of them predate coding agents. I started the Datasette project in 2017.
In fact we can answer this with Datasette! Here's a query showing the 111 packages with at least one release prior to ChatGPT on Nov 30 2022: https://datasette.simonwillison.net/simonwillisonblog?sql=wi...
And this is that same query for Claude Code (Feb 24 2025) - which returns 172:
https://datasette.simonwillison.net/simonwillisonblog?sql=wi...
I'm at 205 today (some of the repos on GitHub aren't plugins, and some in the datasette org were written and released by Alex Garcia which excludes them from my own releases database).
Most of the plugins I wrote this year have been heavily AI-assisted, but that wasn't the case for the older ones. Here's my post from October 2025 when I first realized Claude Sonnet 4.5 could one-shot a plugin for me: https://simonwillison.net/2025/Oct/8/claude-datasette-plugin...
The reason there are so many repos is that Datasette uses a plugin architecture, which makes it much easier to try out different features without risk of corrupting the core project with things that turn out to be bad ideas.
I gave a talk about plugin architecture at DjangoCon a couple of years ago: https://2024.djangocon.us/talks/how-to-design-and-implement-...
Re: Datasette Apps: Host custom HTML applications inside Datasette
#44Earlier quoted context omitted.
I think the current meaning has quite successfully replaced the original usage. Unless you typed this on a Commodore VIC-20, I suppose.
For you maybe, but I've never heard of this site, my only reference for "datasette" is the commodore 1560
Re: Datasette Apps: Host custom HTML applications inside Datasette
#45I'm curious where the pattern will go. My sense is there is a split between cathedrals vs bazaar for approach here, where cathedrals are quite rigid app builders, think framer/wix, while bazaars focus a layer below for more flexibility but less integrated.
Re: Datasette Apps: Host custom HTML applications inside Datasette
#46Re: Datasette Apps: Host custom HTML applications inside Datasette
#47I 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 !
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.).
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.
Re: Datasette Apps: Host custom HTML applications inside Datasette
#48Earlier quoted context omitted.
I can’t even parse what you’re complaining about. Could you elaborate?
10 PRINT "HAVE YOU TRIED READING IT AGAIN?" 20 GOTO "https://news.ycombinator.com/item?id=48594798"
Just read for the first time.
Thank you for the disambiguation for me - and the other readers.
Please hold the snark, lol
Re: Datasette Apps: Host custom HTML applications inside Datasette
#49Re: Datasette Apps: Host custom HTML applications inside Datasette
#50Multiple projects are coming to the same point it seems. Motherduck has been marketing "dives" since the beginning of the year ( https://motherduck.com/blog/duck-dive-and-answer/ ) and in the Louie.ai team, we have been iterating on different patterns for similar needs. I'm getting the feeling that the answer to SaaS apps as fixed UIs over databases being dead because of coding agents means just the fixed dashboard p…