Thanks [Stuart Langridge](https://twitter.com/sil/status/1312137808111304704) for showing me how to do this:

If you provide your own custom generated ICS file hosted at a URL it's nice to be able to give Google Calendar users an easy way to subscribe to th...

Day 43 of 90 Days of DevOps - AWS EC2 and Compute Services. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

Alex Garcia's [sqlite-vec](https://github.com/asg017/sqlite-vec) SQLite extension provides a bunch of useful functions for working with vectors ins...

The PostgreSQL [fuzzystrmatch extension](https://www.postgresql.org/docs/13/fuzzystrmatch.html) enables several functions for fuzzy string matching...

In [sqlite-utils issue 439](https://github.com/simonw/sqlite-utils/issues/439) I was testing against a CSV file that used UTF16 little endian encod...

The [GitHub Code Search beta](https://docs.github.com/en/search-github/github-code-search) is really powerful - it allows advanced search - includi...

Day 42 of 90 Days of DevOps - AWS Core Services Overview. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

Day 41 of 90 Days of DevOps - Cloud Computing Fundamentals. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

First, install MySQL like so:

Day 40 of 90 Days of DevOps - Kubernetes Security and RBAC. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

Day 39 of 90 Days of DevOps - Kubernetes StatefulSets and Persistent Storage. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

Via [Mariatta](https://fosstodon.org/@mariatta/112883308634473940) I found my [PyVideo speaker page](https://pyvideo.org/speaker/simon-willison.htm...

I usually use [Squoosh.app](https://squoosh.app/) to reduce the size of my PNGs, but in this case I had a folder with nearly 50 images in it so I w...

Day 38 of 90 Days of DevOps - Kubernetes Ingress and Load Balancing. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

For [simonw/til issue #82](https://github.com/simonw/til/issues/82) I needed to embed some binary content directly in a Python script.

I wanted to replace all instances of this:

I spotted [this script](https://github.com/varunshenoy/opendream/blob/main/run_opendream.sh) that starts the [opendream](https://github.com/varunsh...

Day 37 of 90 Days of DevOps - Kubernetes ConfigMaps and Secrets. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

I was thinking about documentation SEO today. Like many projects, Datasette offers multiple versions of the documentation:

For [paginate-json]() I wanted to implement streaming output of an indented JSON array to my terminal.

Day 36 of 90 Days of DevOps - Kubernetes Deployments and Services. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

I was using the Apache Bench `ab` command to exercise some new code I'm writing in Datasette and I noticed I was getting a lot of errors:

When building the [--sniff option](https://github.com/simonw/sqlite-utils/issues/230) for `sqlite-utils insert` (which attempts to detect the corre...