Datasette is my data hammer
I tried datasette for the first time not long ago. To me it wasn't obvious what it gave me compared to my local Postgres setup.I have a single docker-compose file with Postgres + pgAdmin and a host mount which I use for data exploration and ad-hoc analysis. I get a nice Web UI and can ingest quickly using the awesome Postgres FDWs.Compared to datasette, it allows me to also transform the data by creating derived views and tables. The UI of pgAdmin also is much more fully-featured, but depending on the user that could well be a disadvantage. I guess the other thing datasette might be better at is the sharing use case by somehow exposing your instance and sharing links, I can do that with pgAdmin as well though.Overall I'd probably need to try it out some more but currently lack the motivation because I can't think of any big advantage over my old setup.