Day 95 of 90 Days of DevOps - DevOps Success Stories. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I wanted the ability to test my Python software against specific version of SQLite on macOS. I found a way to do that using [pysqlite3](https://git...

[Steampipe](https://steampipe.io/) build software that lets you query different APIs directly from SQL databases.

Day 94 of 90 Days of DevOps - DevOps Future Trends. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

Day 93 of 90 Days of DevOps - DevOps Resources and References. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I [decided to add](https://github.com/simonw/datasette-lite/issues/35) automated tests to my [Datasette Lite](https://simonwillison.net/2022/May/4/...

Day 92 of 90 Days of DevOps - DevOps Certifications and Training. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I wanted to start [a new git repository](https://github.com/simonw/graphql-scraper/tree/828a1efc4307cca6cd378c394c2d33eac2eceb52) containing just t...

Day 91 of 90 Days of DevOps - Community Contributions and Open Source. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

For [sqlite-utils issue 250](https://github.com/simonw/sqlite-utils/issues/250) I needed to locate some test CSV files that start with a UTF-8 BOM.

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...