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.<p>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.<p>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.<p>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.