Sunday, 7th February 2021
I put together a 17 minute video introduction to Datasette and sqlite-utils for FOSDEM 2021, showing how you can use Datasette to explore data, and demonstrating using the
sqlite-utils command-line tool to convert a CSV file into a SQLite database, and then publish it using
datasette publish. Here’s the video, plus annotated screen captures with further links and commentary.
Most of what I worked on this week was covered in Serving map tiles from SQLite with MBTiles and datasette-tiles. I built two new plugins: datasette-tiles for serving map tiles, and datasette-basemap which bundles map tiles for zoom levels 0-6 of OpenStreetMap. I also released download-tiles for downloading tiles and bundling them into an MBTiles database.[... 350 words]