I was trying to figure out if SQLite has the ability to use more than one index as part of executing a single query, or if it only ever picks a sin...

Day 69 of 90 Days of DevOps - Zero Trust Architecture. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

Every time I opened a terminal on my new Mac running Catalina with zsh I got the following annoying error:

I just spent way too long messing around with ChatGPT ([transcript here](https://gist.github.com/simonw/c3b486fa90d7c32a0e8dfb47e151090a)) trying t...

I needed this for the `datasette install` and `datasette uninstall` commands, see [issue #925](https://github.com/simonw/datasette/issues/925).

This is a three-quarters-baked experiment that I ran this morning. I'm interested in efficiently tracking which new files have been added to an S3 ...

Day 68 of 90 Days of DevOps - Threat Modeling for DevOps. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

A follow-up to [Using OpenAI functions and their Python library for data extraction](https://til.simonwillison.net/gpt3/openai-python-functions-dat...

I have two different Google Cloud accounts active at the moment. Here's how to list them with `gcloud auth list`:

Day 67 of 90 Days of DevOps - Security Policies and Governance. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

While [writing this thread](https://twitter.com/simonw/status/1370390336514658310) about my habit of opening issues and closing them a few seconds ...

Day 66 of 90 Days of DevOps - Compliance as Code. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

My test suite for [Datasette](https://github.com/simonw/datasette) has grown so large that running the whole thing sometimes causes me to run out o...

Inspired by [Drew Breunig's Faucet Finder](https://www.dbreunig.com/2023/09/26/faucet-finder.html) I decided I wanted to deploy an API somewhere th...

> :warning: **17 Feb 2022: There have been reports of running tmate causing account suspensions**. See [this issue](https://github.com/mxschmitt/ac...

Day 65 of 90 Days of DevOps - SAST and DAST Implementation. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

For a friend's wedding I needed to run a Google Photos slideshow on some large televisions.

Day 64 of 90 Days of DevOps - Secrets Management and Vault. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

[This issue](https://github.com/simonw/datasette/issues/2270) by Parand Darugar pointed out that Datasette doesn't currently run on Linux systems w...

The San Francisco Microscopical Society has some extremely high resolution scanned images - one of them is a 1.67GB PNG file with a 25,088 × 17,283...

Day 63 of 90 Days of DevOps - Container Security and Image Scanning. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date.

I recently found out modern browsers include a JavaScript API for creating public/private keys for cryptography.

Day 62 of 90 Days of DevOps - Security Scanning in CI/CD Pipelines. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.