I managed to get my Homebrew installation back into shape today. The first problem I was having is that it complained that macOS Sequoia was unsupp...

I wanted to dynamically run the following command against all files in a directory:

This [post on Reddit](https://www.reddit.com/r/sqlite/comments/wr0wp0/i_have_a_sqlite_database_of_recipes_i_would_like/) asked how to run a query t...

A comprehensive guide to deploying and configuring CoreDNS and StepCA infrastructure using Kubernetes manifests through Quadlet on Fedora CoreOS, enabling integrated DNS and certificate management.

I wrote this test to exercise some [httpx](https://pypi.org/project/httpx/) code today, using [pytest-mock](https://pypi.org/project/pytest-mock/).

I scraped a pass on my Ham radio general exam today, on the second attempt (you can retake on the same day for an extra $15, thankfully).

Once you have installed the "command line tools" for Catalina using the following terminal command:

Vercel really wants you to deploy static assets with [serverless functions](https://vercel.com/docs/serverless-functions/introduction) tucked away ...

For [apple-notes-to-sqlite](https://github.com/dogsheep/apple-notes-to-sqlite) I needed to write some tests that simulated executing the `osascript...

I made a pleasant discovery today: Homebrew are very quick to update to the latest SQLite release (here's [their formula](https://github.com/Homebr...

I caught up with some of the latest developments in the ecosystem around Justine Tunney's [cosmopolitan](https://github.com/jart/cosmopolitan) and ...

I added dropdown menus to [Datasette 0.51](https://docs.datasette.io/en/stable/changelog.html#v0-51) - see [#1064](https://github.com/simonw/datase...

[howto-wasm-minimal](https://github.com/ern0/howto-wasm-minimal) by Zalka Ernő ([my fork here](https://github.com/simonw/howto-wasm-minimal)) is a ...

[App Platform](https://www.digitalocean.com/docs/app-platform/) is the new PaaS from DigitalOcean. I figured out how to run Datasette on it.

A comprehensive guide to adding and managing custom Certificate Authority (CA) certificates in Podman environments, with detailed methods for both manual certificate installation and integrated CA infrastructure using Smallstep.

Sky News in partnership with [Tortoise](https://www.tortoisemedia.com/) published a fantastic piece of investigative data reporting: [the Westminst...

I deployed an app to [Fly](https://fly.io/) and decided to point a custom subdomain to it.

I fell down a bit of a rabbit hole this morning. In trying to figure out [where the idea of celebrating World Wide Web Day on August 1st](https://s...

I was getting occasional `Error: database is locked` messages from a Datasette instance that was running against a bunch of different SQLite files ...

`asyncio` in Python is a form of co-operative multitasking, where everything runs in a single thread but asynchronous tasks can yield to other task...

I usually use my `sqlite-utils insert blah.db tablename file.csv --csv` command to import CSV data into SQLite, but for large CSV files (like a 750...

TikTok may or may not be banned in the USA within the next 24 hours or so. Here's a pattern you can use to download all of the videos from a specif...

Learned about this today as a way of accessing the Kubernetes REST API.

A comprehensive guide to building a robust, multi-tier PKI infrastructure with your own Certificate Authority (CA), including detailed explanations, automation scripts, and security best practices for enterprise deployments.