Day 72 of 90 Days of DevOps - AWS Lambda and Function Development. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.

One of our cameras takes raw photos in ORF format, which I believe stands for "Olympus Raw Format". Here's a recipe I found for converting them to ...

`migrations.RunSQL.noop` provides an easy way to create "reversible" Django SQL migrations, where the reverse operation does nothing (but keeps it ...

Today I learned that if you hit `Esc` in vim and then type `:set mouse=a` and hit enter... vim grows mouse support! In your terminal!

Day 71 of 90 Days of DevOps - Serverless Computing Introduction. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.

This runs using Spotlight so it's really fast:

Day 70 of 90 Days of DevOps - Security Incident Response. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

I finally found a workaround for this error when attempting to load a SQLite extension in Python on macOS:

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.