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...

[Rye](https://github.com/mitsuhiko/rye) is Armin Ronacher's new experimental Python packaging tool. I decided to take it for a test-run.

GitHub [Gists](https://gist.github.com/) are full Git repositories, and can be cloned and pushed to.

For [simonw/museums#32](https://github.com/simonw/museums/issues/32) I wanted to have certain lines in my Bash script ignore any errors: lines that...

A step-by-step guide to deploying OpenSearch using Podman and Quadlet for a lightweight, secure, and systemd-integrated search solution without Docker or Kubernetes.

I tried this for the first time today with my highly experimental [datasette-table](https://www.npmjs.com/package/datasette-table) Web Component. H...

[Django SQL Dashboard](https://django-sql-dashboard.datasette.io/) can display rendered markdown generated by a SQL query.

I have a database table with all of my Swarm checkins since 2011, created using my [swarm-to-sqlite](https://datasette.io/tools/swarm-to-sqlite) tool.

My [db-to-sqlite](https://github.com/simonw/db-to-sqlite) tool can connect to a PostgreSQL database, export all of the content and write it to a SQ...

For my blog entry today [Now add a walrus: Prompt engineering in DALL-E 3](https://simonwillison.net/2023/Oct/26/add-a-walrus/) I wanted to display...

I wanted to convert the Markdown used in my TILs to HTML, using the exact same configuration as GitHub does. GitHub has a whole load of custom exte...

I've been using `setuptools` and `setup.py` for my Python packages for a long time: I like that it works without me having to think about installin...

I guess I [have to learn TypeScript](https://twitter.com/simonw/status/1302517496767938561) now.

Here's a devious trick for listing ALL columns in a SQLite database, using a SQL query that generates another SQL query.

For [Datasette Desktop](https://github.com/simonw/datasette-app) I wanted to run an action which, when I created a release, would build an asset fo...

For [sqlite-utils#364](https://github.com/simonw/sqlite-utils/issues/364) I needed to write a test for a [Click](https://click.palletsprojects.com/...

Jinja autoescaping is turned off by default. Coming from Django this frequently catches me out.

I decided to see if there was an equivalent of [Black](https://pypi.org/project/black/) or [Prettier](https://prettier.io/) for YAML files. I found...

I was getting the following warning for one of my Python test suites:

I have my own private `notes` repository where I sometimes create research threads. Occasionally I want to transfer these to a public repository to...

Today I [got curious](https://twitter.com/simonw/status/1368414296888070146) about how MediaWiki records page history, so I started digging around ...

I needed to run Selenium on macOS for the first time today. Here's how I got it working.

I wanted to get wildcard DNS running on my Mac laptop, for development purposes. I wanted `http://anything.mysite.lan/` to point to my localhost IP...

This TIL is mainly a rehash of these two articles by Jacob and Andrew: