Notes from my appearance on the Changelog podcast
A transcript should be available soon (the Changelog have excellent transcripts) but in the meantime here are my own notes on the topics that we covered.
My section starts 54:45 minutes into the episode.
Here’s Datasette on GitHub, and Datasette: instantly create and publish an API for your SQLite databases where I first announced the project.
My sf-trees.com website, which is powered by this Datasette API using data from the San Francisco Department of Public Works.
The hosting platform I use for immutable deployments of Docker containers is Zeit Now.
Here’s the full Datasette suite of tools:
- csvs-to-sqlite is a command-line tool for converting CSV files into a SQLite database.
- Datasette is a web application for exploring SQLite databases and interacting with them via a read-only JSON API. It also includes the
datasette publishcommand-line tool for publishing those databases using Zeit Now or Heroku.
- Datasette Publish is a web app that lets you upload CSV files and deploy them to a new Datasette instance without installing any software. Here’s my announcement post.
A few more fun examples of datasettes that we discussed:
- USGS Polar Bear ear tags on a map, using the datasette cluster map plugin—data sourced from the USGS. The tags are made by Wildlife Computers.
- Australian dog names! Here are the most common names overall, and here are the most common names for pugs.
- The UK Register of Members Interests lets you explore conflicts of interest registered by UK politicians. My accompanying blog entry has plenty of interesting example searches.
- The Metropolitan Museum of Art—a Datasette instance for exploring the 464,360 items in their collection that they published as a CSV on GitHub.
The best thing you can do is use Datasette to publish your data and then give me feedback!
Even better: write plugins! Datasette’s plugin architecture is just getting started so the more experience and feedback we can get with it the better.