Datasette's [release notes](https://github.com/simonw/datasette/blob/main/docs/changelog.rst) are formatted using Sphinx. Almost every bullet point...

[django-sql-dashboard](https://github.com/simonw/django-sql-dashboard) lets you define a SQL query plus one or more text inputs that the user can p...

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

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

I live in El Granada, California. Wikipedia calls us [a census designated place](https://en.wikipedia.org/wiki/El_Granada,_California) - we don't h...

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.