Back-dating Git commits based on file modification dates
I fell down a bit of a rabbit hole this morning. In trying to figure out [where the idea of celebrating World Wide Web Day on August 1st](https://s...
859 words
|
4 minutes
Enabling WAL mode for SQLite database files
I was getting occasional `Error: database is locked` messages from a Datasette instance that was running against a bunch of different SQLite files ...
319 words
|
2 minutes
Relinquishing control in Python asyncio
`asyncio` in Python is a form of co-operative multitasking, where everything runs in a single thread but asynchronous tasks can yield to other task...
129 words
|
1 minute
Importing CSV data into SQLite with .import
I usually use my `sqlite-utils insert blah.db tablename file.csv --csv` command to import CSV data into SQLite, but for large CSV files (like a 750...
132 words
|
1 minute
Downloading every video for a TikTok account
TikTok may or may not be banned in the USA within the next 24 hours or so. Here's a pattern you can use to download all of the videos from a specif...
959 words
|
5 minutes
kubectl proxy
Learned about this today as a way of accessing the Kubernetes REST API.
221 words
|
1 minute
Building a Complete PKI Infrastructure - Creating Your Own Certificate Authority
A comprehensive guide to building a robust, multi-tier PKI infrastructure with your own Certificate Authority (CA), including detailed explanations, automation scripts, and security best practices for enterprise deployments.
2401 words
|
12 minutes
Using the sqlite3 Python module in Pyodide - Python WebAssembly
[Pyodide](https://github.com/pyodide/pyodide) provides "Python with the scientific stack, compiled to WebAssembly" - it's an incredible project whi...
254 words
|
1 minute