4 ms·
I use datasette almost daily (thanks simonw!) for ad-hoc queries and for validataion. Often I'll have two APIs from different systems, which I may or may not h
by anitil 5y ago
I use datasette almost daily (thanks simonw!) for ad-hoc queries and for validataion.
Often I'll have two APIs from different systems, which I may or may not have access to directly. Typically I'll need to denormalise the data and dump it to some csvs, use csvs-to-sqlite (from the datasette ecosystem) to convert to a db and open up datasette. I've discovered errors that had remained hidden for months (different teams etc etc) using this workflow.
Also, because the queries are url-encoded I'm considering using it as a 'fake' backend for some proof-of-concepts backed by a couple of cron jobs running the pipeline