I wanted to use a fixture with `pytest-asyncio` that was itsef as `async def` function, so that it could execute `await` statements.

I'm using [pytest-django](https://pytest-django.readthedocs.io/) on a project and I wanted to write a test for a Django admin create form submissio...

I wanted to run a query against the GitHub GraphQL API using `curl` on the command line, while keeping the query itself as readable as possible. He...

I had to run this site on `til.simonwillison.org` for 24 hours due to a domain registration mistake I made.

Here's a PostgreSQL SQL query that returns the closest locations to a point, based on a brute-force approach where the database calculates the dist...

If you ever run into instructions that tell you to do this:

I continue to collect ways of tracking the history of a table of data stored in SQLite - see [sqlite-history](https://simonwillison.net/2023/Apr/15...

For [photos-to-sqlite](https://github.com/dogsheep/photos-to-sqlite) I needed to install `osxphotos` as a dependency, but only if the platform is m...