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