Coding

Pragmatic notes on developer tools, languages, and workflows. Shortcuts, tricks, and lessons from actually shipping code.

SQLite scales to production: 10K TPS, WAL mode, real benchmarks

SQLite handles thousands of concurrent users with WAL mode and connection management. Production-ready from a single file, zero operational overhead.

Build lightweight feature flags with JSON config and environment variables. Enable gradual rollouts and kill switches without an expensive SaaS.

Build professional terminal UIs with Textual: a Python framework with CSS styling, reactive widgets, and async events for dashboards and dev tools.

Profile and optimize Python memory with memray, tracemalloc, and objgraph. Covers leak detection, generators, __slots__, and cutting peak use.

Host a private PyPI registry with pypiserver and an npm registry with Verdaccio to cache packages. Both take under 30 minutes to set up.

Test your Python code against real PostgreSQL, Redis, and Kafka containers with Testcontainers and pytest. Drop the mocks for real services.