I finally figured out how to package [Datasette](https://github.com/simonw/datasette) for installation with Homebrew. My package was accepted into ...

I figured out how to run Datasette on https://replit.com/

I decided to make a GitHub repository public today that had previously been private. Unfortunately the revision history of that repository included...

[Fly.io](https://fly.io/) lets you deploy Docker containers that will be compiled as a Firecracker VM and run in locations around the world.

The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108

A comprehensive guide to efficiently managing and cleaning up Podman resources including containers, images, and volumes to maintain system performance and reclaim disk space.

I have a bunch of models with JSON fields that are marked as read-only in the Django admin - usually because they're recording the raw JSON that wa...

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

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

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.

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

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

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

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

A comprehensive guide to setting up and running OpenSearch in rootless Podman containers with proper security configuration and systemd integration.

A [Datasette feature suggestion](https://github.com/simonw/datasette/issues/1890) concerning autocomplete against a list of known values inspired m...

A comprehensive guide to implementing a zero-trust service mesh on Linux VMs without Kubernetes, using SPIFFE/SPIRE for identity management, Cilium for networking, and private DNS for service discovery.