Love that first question. I need a much better "getting started" flow - right now you can start using a static demo or head to the tutorial, but something more instant than that would be much better.
I'm building out the SaaS version of Datasette at the moment, maybe a free preview of that would help?
I've tried out a whole bunch of "X for Y" things in my head, none of which have quite worked - the problem is that there are too many different facets of it to capture in a single comparison.
Here are a couple:
"Snowflake for small data". Data warehouses are big and expensive and complicated. If your data fits under 10GB (which is true for the vast majority of individuals and companies) you don't need a data warehouse: you need Datasette running on your laptop.
"WordPress for structured data". WordPress is a decent CMS with a plugin system that means you can apply it to any publishing problem. Datasette aims to be a decent SQL explorer and API server with a plugin system that ideally means it can be expanded to handle any form of data visualization, analysis or API-driven integration you could want to handle.
That blood test example is really useful. I've used https://datasette.io/plugins/datasette-vega for that kind of thing but you're right - it really needs to be promoted to a first-class feature at this point. (I'd also like to make it a lot more powerful - it's one of the oldest plugins.)
Maybe, though my issue hasn't been so much installing it as getting it to do useful things.
Your use cases sound great, thanks. Especially "Snowflake for small data" sounds great, I did want something like a simple PowerBI for my small SQLite database. If I could somehow create a dashboard, or some views, or something, and publish them along with my database, that would be amazing.
Plugins do sound good too, but when I download Datasette I already have something in mind so I already want it to come with the most common things I might want to use, along with examples on how to use them.
Vega was the plugin I found as well, but I remember it took me too long to figure out how to make a simple graph, so I quit at that point. If it were built-in, along with a bunch of other plugins, and I had an example of how I could create some simple graphs, I would have gotten much farther along, I think.
Running "brew/pip install datasette" isn't much help if you don't have a SQLite database already. So now you need to learn to use "sqlite-utils" or similar too to create one... by which point I could absolutely see most people having dropped off already.
I had a feature idea relating to this a while back which I should bump up the list: https://github.com/simonw/datasette/issues/1160
I opened a new issue based on this conversation here: https://github.com/simonw/datasette/issues/1845
Generally, the first-run experience is really important, because you may be getting lots of people in the funnel, but if you're losing them to complexity before they can get to the "this is nice" moment, it's for nothing.
Even something like finding plugins can be hard for first-timers, and you unfortunately don't hear about all the users who drop out, because they just stop using the software and never talk to you.
I think my problem with understanding here is twofold: First, I visited the links above, but I don't understand how you get to that end result from downloading Datasette. Is it a "base layer" and then I'm meant to mostly download plugins for the rest of the functionality? I'm not sure if it's meant to be barebones or if I just didn't find the included batteries when I tried it.
The second issue I have is, what exactly is the use case? I don't know if it's meant to be a Django Admin for SQLite, or a Looker for SQLite, or something else? I know it's very powerful and flexible, but that's a curse in this case, as I can't see a simple sentence of "think of it as X for Y" so I can make it fit into my mental model of other stuff.
As a use case, I tried to make it show a trend of my blood test results (I have about a dozen rows in a spreadsheet), but I had a hard time graphing stuff, and I gave up. It seemed to me back then that this probably should have been standard, but I remember having to look for plugins and them not being very easy to configure, so I'm just left with confusion :/