Given a file (or a process) that produces comma separated values, here's how to split those into separate variables and use them in a bash script.

Day 88 of 90 Days of DevOps - Building DevOps Teams. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

Day 87 of 90 Days of DevOps - DevOps Transformation Challenges. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I have a Django application which uses PostgreSQL. I build the Django application into its own Docker container, push that built container to the G...

I really like Skitch for taking screeshots, mainly because I like to snap a quick shot and then drag the icon onto a Google Doc or similar without ...

Day 86 of 90 Days of DevOps - Scaling DevOps in Enterprise. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I figured out how to use a PostgreSQL CTE as part of an update statement in a Django data migration. The trick here is mainly understanding how to ...

[Amplitude](https://amplitude.com/) offers an "Export Data" button in the project settings page. This can export up to 365 days of events (up to 4G...

Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse...

For a Django application I'm working on ([this issue](https://github.com/simonw/django-sql-dashboard/issues/44)) I have a form that can be quite a ...

Day 85 of 90 Days of DevOps - DevOps Metrics and KPIs. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I ran into problems with my AWS Lightsail instance: it exceeded the CPU burst quota for too long and was suspended, and I couldn't figure out how t...

I noticed this morning that one of my Datasette installations had the [Geopoly](https://www.sqlite.org/geopoly.html) SQLite extension enabled. I do...

When SQLite executes a query, it does so by executing a sequence of virtual machine operations.

Day 84 of 90 Days of DevOps - Continuous Learning Culture. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

For [Datasette Desktop](https://datasette.io/desktop) I chose to bundle a full version of Python 3.9 inside my `Datasette.app` application. I did t...

Day 83 of 90 Days of DevOps - Documentation and Knowledge Sharing. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I wanted to create a file with a shell one-liner where the file lived somewhere owned by root.

Day 82 of 90 Days of DevOps - Team Collaboration and Communication. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

Day 81 of 90 Days of DevOps - DevOps Best Practices Compilation. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I wanted to grant a PostgreSQL user (or role) read-only access to a specific list of tables.

[Fly](https://fly.io/) has a GraphQL API which is used by some of their own tools - I found it while [browsing around their code](https://github.co...

I've been experimenting with a tool for generating the content for a weekly Substack newsletter by querying the Datasette API for my blog and assem...

Day 80 of 90 Days of DevOps - WebAssembly and Future Tech. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.