I don't get Datasette. I had a small dataset I wanted to use with it, hoping it would be some sort of moderately advanced FOSS BI software, but all it did was give me a table view.
In terms of use-cases: I've recently started asking people who use it what job they hired it to do. One of the leading answers is for data publishing - they use it as a tool to quickly publish data online for others to use:
Thanks for replying, Simon! I guess my use case was a bit of a toy, I don't have a huge dataset to use facets on, I basically just made a small spreadsheet of blood tests and wanted to see if I could easily navigate the data better than what Excel did. I did install Vega, but it had basically one way to display data (I didn't look into it too much, though).
I think my use case was just not suitable for it, from your answer I guess it's more for people who have huge datasets they want to publish. I imagine it will be much better suited for that purpose, though I tried the demo a few times and couldn't really think of any interesting questions to ask it, so I didn't get it there either...
Datasette is one of those things that sounds very promising, so I want to explore it, but I end up walking away every time. It just sounds like it's not for me, though.
I haven't managed to find a use case for it.