Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

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
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
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
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, sqlite-utils
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
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
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
Release datasette-basemap 0.2 — A basemap for Datasette and datasette-leaflet
2nd Feb 2021, 11:33 pm · datasette
Release datasette 0.54.1 — An open source multi-tool for exploring and publishing data
2nd Feb 2021, 9:30 pm · datasette
Release datasette-tiles 0.2 — Mapping tile server for Datasette, serving tiles from MBTiles packages
2nd Feb 2021, 7:54 pm · datasette
Release download-tiles 0.2 — Download map tiles and store them in an MBTiles database
2nd Feb 2021, 6:24 pm
Release download-tiles 0.1 — Download map tiles and store them in an MBTiles database
2nd Feb 2021, 5:39 pm
Release datasette-basemap 0.1 — A basemap for Datasette and datasette-leaflet
2nd Feb 2021, 7:07 am · datasette
Release datasette-tiles 0.1.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages
2nd Feb 2021, 7:05 am · datasette
Release datasette-tiles 0.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages
2nd Feb 2021, 6:47 am · datasette
Release datasette-basemap 0.1a1 — A basemap for Datasette and datasette-leaflet
2nd Feb 2021, 2:02 am · datasette
Release datasette-basemap 0.1a — A basemap for Datasette and datasette-leaflet
2nd Feb 2021, 1:59 am · datasette
Release datasette-cluster-map 0.17.1 — Datasette plugin that shows a map for any data with latitude/longitude columns
1st Feb 2021, 10:22 pm · datasette

Beats

Years

Tags