.tip

Jul 2, 2026 · one of the small things

uv replaces pip, venv and pip-tools in one binary

It's one tool that creates the environment, resolves the lockfile and installs in seconds, written in Rust by the people behind Ruff.

uv init && uv add fastapi && uv run main.py

The Dockerfile loses three lines, and the CI install drops from forty seconds to two. Of all the toolchain migrations I've done, it's the one I'd call free.

pythontooling

Longer version: the post this came from.

~/tips/today — 2026-10-19

~cat tips/today

Never build an index on a live table without CONCURRENTLY

postgresqlmigrations

A plain CREATE INDEX takes a lock that blocks every write to the table for the whole build. On a big table that means minutes of outage that look like a hung app.

CREATE INDEX CONCURRENTLY orders_customer_idx ON orders (customer_id);

It's slower and can't run inside a transaction, so you'll have to tell your migration tool. If it fails halfway, it leaves an invalid index behind, so check pg_index.indisvalid and drop it before you retry.

↵ open y yesterday l ls /tips

esc close