Archive for Monday, 18th January 2021

Release sqlite-utils 3.3 — Python CLI utility and library for manipulating SQLite databases

Release swarm-to-sqlite 0.3.3 — Create a SQLite database containing your checkin history from Foursquare Swarm

TIL Fixing broken text encodings with sqlite-transform and ftfy — I was working with a database table that included values that were clearly in the wrong character encoding - values like this:

Release sqlite-transform 0.3.1 — Tool for running transformations on columns in a SQLite database

Release datasette-cluster-map 0.15 — Datasette plugin that shows a map for any data with latitude/longitude columns

Simon Willison’s Weblog