2 ms·
One of my goals with https://datasette.io https://datasette.io is to offer a better alternative for publishing data than sharing a link to a CSV file. The tric
by simonw 5y ago
One of my goals with https://datasette.io https://datasette.io is to offer a better alternative for publishing data than sharing a link to a CSV file.
The trick is that if you compile data into a SQLite file and then deploy the Datasette web application with a bundled copy of that database file, users who need CSV can still have it: every Datasette table and query offers a CSV export.
But... you can also get the data out as JSON. Or you can reshape it (rename columns etc) with a SQL query and export the new shape.
Or you can install plugins like https://datasette.io/plugins/datasette-yaml https://datasette.io/plugins/datasette-yaml or https://datasette.io/plugins/datasette-ics https://datasette.io/plugins/datasette-ics or https://datasette.io/plugins/datasette-atom https://datasette.io/plugins/datasette-atom to enable other formats.
- kthejoker2 5y agoAs an avid Datasette (and Simon Willison!) fan, > then deploy the Datasette web application Is a huge hurdle for non-technical folks holding on to their CSV workflows. I think there is no barrier low enough that CSV cannot limbo beneath it.
- simonw 5y agoYeah I've put a ton of effort into that, but it's still nowhere near as easy as I would like.