Notes from my appearance on the Changelog podcast
9th May 2018
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.
More recent articles
- The killer app of Gemini Pro 1.5 is video - 21st February 2024
- Weeknotes: a Datasette release, an LLM release and a bunch of new plugins - 9th February 2024
- LLM 0.13: The annotated release notes - 26th January 2024
- Weeknotes: datasette-test, datasette-build, PSF board retreat - 21st January 2024
- Talking about Open Source LLMs on Oxide and Friends - 17th January 2024
- Publish Python packages to PyPI with a python-lib cookiecutter template and GitHub Actions - 16th January 2024
- What I should have said about the term Artificial Intelligence - 9th January 2024
- Weeknotes: Page caching and custom templates for Datasette Cloud - 7th January 2024
- It's OK to call it Artificial Intelligence - 7th January 2024