Weeknotes: Mostly messing around with map tiles
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.
I added one new feature to sqlite-utils: the
sqlite-utils import command can now be configured to read CSV files using alternative delimiters, by passing the
--delimiter option or the
This is covered in the documentation, which provides the following example:
name;description Cleo;|Very fine; a friendly dog| Pancakes;A local corgi
sqlite-utils insert dogs.db dogs dogs.csv \ --delimiter=";" --quotechar="|"
I spotted a subtle but nasty regression in Datasette: a change I made to how hidden form fields worked on the table page meant that clearing the
_search search input and re-submitting the form didn’t take effect, and the search would persist. Datasette 0.54.1 fixes that bug.
Releases this week
Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Python CLI utility and library for manipulating SQLite databases
Mapping tile server for Datasette, serving tiles from MBTiles packages
Download map tiles and store them in an MBTiles database
A basemap for Datasette and datasette-leaflet
An open source multi-tool for exploring and publishing data
Datasette plugin that shows a map for any data with latitude/longitude columns