Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

Release csv-diff 1.1 — Python CLI tool and library for diffing CSV and JSON files
23rd Feb 2021, 1:14 am
Release sqlite-transform 0.4 — Tool for running transformations on columns in a SQLite database
22nd Feb 2021, 5:04 pm
Release airtable-export 0.5 — Export Airtable data to YAML, JSON or SQLite files on disk
22nd Feb 2021, 6:02 am
Release datasette-json-preview 0.3 — Preview of new JSON default format for Datasette
20th Feb 2021, 7:45 pm · datasette
Release sqlite-utils 3.6 — Python CLI utility and library for manipulating SQLite databases
19th Feb 2021, 5:19 am · sqlite, sqlite-utils
Release datasette 0.55 — An open source multi-tool for exploring and publishing data
19th Feb 2021, 2:02 am · datasette
Release datasette-graphql 1.4 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
18th Feb 2021, 11:37 pm · datasette
TIL Using sphinx.ext.extlinks for issue links — Datasette's [release notes](https://github.com/simonw/datasette/blob/main/docs/changelog.rst) are formatted using Sphinx. Almost every bullet point links to the corresponding GitHub issue, so they were full of lines that look like this:
18th Feb 2021, 1:27 am
None
TIL Loading radio.garden into SQLite using jq — http://radio.garden/ is an amazing website which displays a 3D globe covered in radio stations and lets you listen to any of them.
18th Feb 2021, 12:44 am
None
Release higher-lower 0.1 — Functions for finding numbers using higher/lower
16th Feb 2021, 7:11 am
Release download-tiles 0.4.1 — Download map tiles and store them in an MBTiles database
16th Feb 2021, 4:19 am
TIL Using io.BufferedReader to peek against a non-peekable stream — When building the [--sniff option](https://github.com/simonw/sqlite-utils/issues/230) for `sqlite-utils insert` (which attempts to detect the correct CSV delimiter and quote character by looking at the first 2048 bytes of a CSV file) I had the need to peek ahead in an incoming stream of data.
15th Feb 2021, 7:17 pm
None
TIL Handling CSV files with wide columns in Python — Users [were reporting](https://github.com/simonw/sqlite-utils/issues/229) the following error using `sqlite-utils` to import some CSV files:
15th Feb 2021, 7 pm
None
Release sqlite-utils 3.5 — Python CLI utility and library for manipulating SQLite databases
14th Feb 2021, 10:44 pm · sqlite, sqlite-utils
Release evernote-to-sqlite 0.3.1 — Tools for converting Evernote content to SQLite
11th Feb 2021, 10:40 pm
Release evernote-to-sqlite 0.3 — Tools for converting Evernote content to SQLite
11th Feb 2021, 10:16 pm
Release datasette-tiles 0.6.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages
11th Feb 2021, 12:40 am · datasette
Release datasette-tiles 0.6 — Mapping tile server for Datasette, serving tiles from MBTiles packages
11th Feb 2021, 12:25 am · datasette
TIL Shrinking PNG files with pngquant and oxipng — I usually use [Squoosh.app](https://squoosh.app/) to reduce the size of my PNGs, but in this case I had a folder with nearly 50 images in it so I wanted to do it using the command-line.
7th Feb 2021, 7:57 pm
None
Release datasette-jellyfish 1.0.1 — Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
6th Feb 2021, 2:34 am · datasette
Release sqlite-utils 3.4.1 — Python CLI utility and library for manipulating SQLite databases
6th Feb 2021, 2:11 am · sqlite-utils, sqlite
Release datasette-jellyfish 1.0 — Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
6th Feb 2021, 2 am · datasette
Release sqlite-utils 3.4 — Python CLI utility and library for manipulating SQLite databases
6th Feb 2021, 1:38 am · sqlite, sqlite-utils
TIL Downloading MapZen elevation tiles — [Via Tony Hirst](https://twitter.com/psychemedia/status/1357280624319553537) I found out about [MapZen's elevation tiles](https://www.mapzen.com/blog/terrain-tile-service/), which encode elevation data in PNG and other formats.
4th Feb 2021, 6:48 pm
None
Release datasette-tiles 0.5 — Mapping tile server for Datasette, serving tiles from MBTiles packages
4th Feb 2021, 6:16 pm · datasette
TIL Serving MBTiles with datasette-media — The [MBTiles](https://github.com/mapbox/mbtiles-spec) format uses SQLite to bundle map tiles for use with libraries such as Leaflet.
3rd Feb 2021, 11:12 pm · leaflet
None
Release datasette-tiles 0.4 — Mapping tile server for Datasette, serving tiles from MBTiles packages
3rd Feb 2021, 10:24 pm · datasette
Release download-tiles 0.4 — Download map tiles and store them in an MBTiles database
3rd Feb 2021, 3:32 am
Release download-tiles 0.3 — Download map tiles and store them in an MBTiles database
3rd Feb 2021, 12:35 am
Release datasette-tiles 0.3 — Mapping tile server for Datasette, serving tiles from MBTiles packages
2nd Feb 2021, 11:41 pm · datasette

Beats

Years

Tags