I decided to have a poke around and see if I could figure out how the HTTP streaming APIs from the various hosted LLM providers actually worked. He...

A popular nightmare scenario for AI is giving it access to tools, so it can make API calls and execute its own code and generally break free of the...

[llama.cpp](https://github.com/ggerganov/llama.cpp) recently added the ability to control the output of any model using a grammar.

Here's a trick I've used a couple of times in the past few days.

The [EC2 pricing page](https://aws.amazon.com/ec2/pricing/on-demand/) shows cost per hour, which is pretty much useless. I want cost per month. The...

Comprehensive guide to implementing Application Detection and Response (ADR) using eBPF for real-time threat detection and prevention in modern web applications.

I have a Fly instance with a 20GB volume, and I wanted to copy files to and from the instance from my computer using `scp`.

I deployed https://metmusem.datasettes.com/ by creating a folder on my computer containing a Dockerfile and then shipping that folder up to Google ...

Today I worked out how to use the Heroku `pg:pull` command and [Postgres.app](https://postgresapp.com/) to pull a Heroku backup to my laptop.

For my [git-history live demos](https://github.com/simonw/git-history/issues/30) I needed to store quite large files (~200MB SQLite databases) in b...

I [decided](https://github.com/simonw/datasette/issues/1166) to adopt [Prettier](https://prettier.io/) as the JavaScript code style for Datasette, ...

For [datasette/issues/1522](https://github.com/simonw/datasette/issues/1522) I wanted to use a Docker build argument in a `Dockerfile` that would t...

I picked up the recipe for this one from [this video](https://www.tiktok.com/t/ZTRaxyxQP/) by [@notjustabartender](https://www.tiktok.com/@notjusta...

Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new...

Spotted in [this Cloud Run example](https://github.com/GoogleCloudPlatform/github-actions/blob/20c294aabd5331f9f7b8a26e6075d41c31ce5e0d/example-wor...

[Fly](https://fly.io/) makes it surprisingly easy to configure wildcard DNS, such that `anything.your-new-domain.dev` is served by a single Fly app...

OpenAI [announced new models](https://openai.com/blog/function-calling-and-other-api-updates) today. Of particular interest to me is the new `gpt-3...

Complete guide to AWS IAM Roles - understanding trust policies, permissions, and common use cases for secure AWS resource access management.

I was experimenting with the new [Readwise export API](https://readwise.io/api_deets#export) and it gave me back the following JSON:

The ChatGPT Code Interpreter alpha remains incredibly interesting. I wrote about how I was using it [for Python and SQLite benchmarking](https://si...

I decided to run my CI tests against the Python 3.11 preview, to avoid the problem I had when Python 3.10 came out with [a bug that affected Datase...

A comprehensive guide to integrating HashiCorp Vault with CoreDNS for secure DNS resolution, dynamic secrets management, and certificate automation in modern infrastructure.

A complete guide to building an automated API inventory system that discovers, documents, and manages all APIs across your organization's infrastructure.

A comprehensive guide to using Podman Quadlet for container management, enabling systemd-native container deployment with automatic updates, dependencies, and lifecycle management.