I host the documentation for Datasette on [Read the Docs](https://readthedocs.org/). Until today it lived at https://datasette.readthedocs.io/ but ...

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

While implementing more finely-grained permissions for `datasette-insert-api` ([issue 8](https://github.com/simonw/datasette-insert-api/issues/8)) ...

For both [s3-credentials](https://github.com/simonw/s3-credentials) and [datasette-publish-fly](https://github.com/simonw/datasette-publish-fly) I ...

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.

New feature [announced here](https://github.blog/2022-05-09-supercharging-github-actions-with-job-summaries/). Here's the [full documentation](http...

In investigating [llm/issues/164](https://github.com/simonw/llm/issues/164) I found myself needing to know more precise details of the Python SQLit...

After rebasing a branch with 60+ commits onto `main` I was disappointed to see that the commit dates on the commits (which are a different thing fr...

I really like [Cog](https://nedbatchelder.com/code/cog/) ([previously](https://til.simonwillison.net/python/cog-to-update-help-in-readme)) as a too...

I wanted to know how large the [deepseek-ai/DeepSeek-V3-Base](https://huggingface.co/deepseek-ai/DeepSeek-V3-Base) repo on Hugging Face was without...

A comprehensive guide to Distrobox - the powerful tool that enables seamless use of any Linux distribution inside your terminal through containers, with full integration with your host system.

[pytest-recording](https://github.com/kiwicom/pytest-recording) is a neat pytest plugin that makes it easy to use the [VCR library](https://vcrpy.r...

A comprehensive guide to implementing a secure, production-grade RSyslog configuration with TLS encryption, certificate authentication, queue management, and security best practices.

A comprehensive guide for deploying a secure, production-grade Kubernetes cluster on CoreOS with CRI-O runtime, SELinux integration, and robust networking using kube-router.

I figured out a pattern for doing this today using the `sqlite3` CLI tool - given two SQLite databases in the current folder, called `tils.db` and ...

I decided to try out [atuin](https://github.com/ellie/atuin?utm_source=tldrnewsletter), a shell extension that writes your history to a SQLite data...

I'm learning service workers. I wanted to start with one that intercepts calls to a `/path` and returns "Hello World".

Here's how to use SQLite's `VALUES` syntax with a CTE to create a temporary table that you can then perform joins against in a query:

[Readability.js](https://github.com/mozilla/readability) is "A standalone version of the readability library used for Firefox Reader View".

I needed to generate a grid calendar that looks like this (design [by Natalie Downe](https://github.com/natbat/pillarpointstewards/issues/23)):

Matt Holt [asked](https://twitter.com/mholt6/status/1690177417393135616):

I had an input string in `x,y,z` format and I needed to split it into three separate values in SQLite. I managed to do it using a confusing combina...

[TG](https://github.com/tidwall/tg) is an exciting new project in the world of open source geospatial libraries. It's a single C file (an amalgamat...