Day 48 of 90 Days of DevOps - Google Cloud Platform Essentials. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

I used this pattern to pass a SQL query to Datasette's CSV export via curl and output the results, stripping off the first row (the header row) usi...

I wanted a script running as a non-root user to be able to restart a systemd service on my Ubuntu machine without needing a password.

Day 47 of 90 Days of DevOps - Azure DevOps and Pipelines. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

I wanted to change the layout of [my blog](https://simonwillison.net/) on mobile screens such that the content from the "Elsewhere" right hand colu...

Day 46 of 90 Days of DevOps - Azure Fundamentals and Services. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

I had an 11GB movie in Apple Photos (sync'd from my iPhone) and I wanted to upload it to YouTube (actually via AirDrop to another laptop first).

Day 45 of 90 Days of DevOps - AWS Networking - VPC and Security Groups. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

My [LLM](https://llm.datasette.io/) tool has a feature where you can set a `LLM_OPENAI_SHOW_RESPONSES` environment variable to see full debug level...

I want to try using [QuickJS](https://bellard.org/quickjs/) compiled to WebAssembly in a browser as a way of executing untrusted user-provided Java...

Yesterday [I figured out (issue 133)](https://github.com/simonw/datasette-app/issues/133) how to use Playwright to run tests against my Electron ap...

I wanted the ability to paste the image on my clipboard into a command in the macOS terminal.

Day 44 of 90 Days of DevOps - AWS Storage Solutions - S3 and EBS. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

Thanks [Stuart Langridge](https://twitter.com/sil/status/1312137808111304704) for showing me how to do this:

If you provide your own custom generated ICS file hosted at a URL it's nice to be able to give Google Calendar users an easy way to subscribe to th...

Day 43 of 90 Days of DevOps - AWS EC2 and Compute Services. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

Alex Garcia's [sqlite-vec](https://github.com/asg017/sqlite-vec) SQLite extension provides a bunch of useful functions for working with vectors ins...

The PostgreSQL [fuzzystrmatch extension](https://www.postgresql.org/docs/13/fuzzystrmatch.html) enables several functions for fuzzy string matching...

In [sqlite-utils issue 439](https://github.com/simonw/sqlite-utils/issues/439) I was testing against a CSV file that used UTF16 little endian encod...

The [GitHub Code Search beta](https://docs.github.com/en/search-github/github-code-search) is really powerful - it allows advanced search - includi...

Day 42 of 90 Days of DevOps - AWS Core Services Overview. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

Day 41 of 90 Days of DevOps - Cloud Computing Fundamentals. Part of the Cloud Platforms series covering essential DevOps concepts and hands-on practices.

First, install MySQL like so:

Day 40 of 90 Days of DevOps - Kubernetes Security and RBAC. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.