I use [pytest-httpx](https://colin-b.github.io/pytest_httpx/) in a bunch of my projects. Occasionally I run into test failures like this one, which...

I tried using a gin index to speed up `LIKE '%term%'` queries against a column.

I was trying to run `VACUUM` against a large SQLite database file (~7GB) using `sqlite-utils vacuum data.db` and I got this error:

I ran a Google search this morning for `s3-credentials simon willison` and when I clicked on the top result it jumped me to a highlighted snippet o...

I recently noticed that the router in our garage was providing around 900 Mbps if I plugged my laptop directly into it via an Ethernet cable, but t...

Given a large, heterogeneous table I wanted to identify patterns in the rows in terms of which columns were not null.

[datasette-leaflet-geojson](github.com/simonw/datasette-leaflet-geojson) outputs GeoJSON geometries in HTML pages in a way that can be picked up by...

I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters o...