I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite.

Day 61 of 90 Days of DevOps - DevSecOps Introduction and Principles. Part of the Security & Compliance series covering essential DevOps concepts and hands-on practices.

I'm a big fan of snapshot testing - writing tests where you compare the output of some function to a previously saved version, and can re-generate ...

I've been wanting to figure this out for ages. [This thread](https://news.ycombinator.com/item?id=23282684) on Hacker News plus [this Stackoverflow...

Day 60 of 90 Days of DevOps - Observability Best Practices. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

I decided to use ReadTheDocs for my in-development [datasette-enrichments](https://github.com/datasette/datasette-enrichments) project.

I managed to accidentally create a GIF that ran once without looping. I think this is because I created it in [LICEcap](https://www.cockos.com/lice...

macOS Catalina uses `zsh` rather than `bash` as the default shell (apparently because Apple don't like GPL 3).

Day 59 of 90 Days of DevOps - Chaos Engineering and Resilience. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

I wanted to convert a datetime object (from GitPython) to UTC without adding the `pytz` dependency.

I figured out this pattern today for adding templated extra blocks of information to the Django admin change page for an object.

Day 58 of 90 Days of DevOps - SRE Principles and Error Budgets. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this p...

Day 57 of 90 Days of DevOps - Alerting and Incident Management. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

I got my [asgi-csrf](https://github.com/simonw/asgi-csrf) Python package up to 100% code coverage. Here's [the pull request](https://github.com/sim...

Day 56 of 90 Days of DevOps - Distributed Tracing with OpenTelemetry. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

First, checkout the cpython repo:

I wanted to add a `--encoding` option to `sqlite-utils insert` which could be used to change the file encoding used to read the incoming CSV or TSV...

I needed to bulk-delete a large number of objects today. Django deletions are relatively inefficient by default, because Django implements its own ...

Day 55 of 90 Days of DevOps - Application Performance Monitoring. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

Day 54 of 90 Days of DevOps - ELK Stack for Log Management. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

I'm working with several huge CSV files - over 5 million rows total - and I ran into a problem: it turned out there were a few lines in those files...

Day 53 of 90 Days of DevOps - Grafana Dashboards and Visualization. Part of the Monitoring & Observability series covering essential DevOps concepts and hands-on practices.

I decided to implement a custom Jinja template block tag for my [datasette-render-markdown](https://datasette.io/plugins/datasette-render-markdown)...