Software engineering, infrastructure, and testing
A REFRESH MATERIALIZED VIEW CONCURRENTLY kept dying mid-flight over a remote connection with 'SSL SYSCALL error: EOF detected'. The database was innocent. The killer was a NAT idle timeout and libpq's 2-hour keepalive default.
A story-driven workflow for Claude Code, built for projects that already exist. One markdown file as the source of truth, Rails-style defaults, a QA layer between unit tests and humans, and isolated worktree testing that took three tries to get right. The honest version — what broke, and how I hardened it.
How I built a fast, relevant headline search for AFK.live using pg_trgm, materialized views, and strict_word_similarity — on the smallest managed database Scaleway offers.
How I built an automated QA system for a solo startup using Claude Code slash commands — orchestrating subagents that run SQL checks, API calls, and unit tests against a local copy of the production database. Including a self-correcting test plan that updates itself after every run.
How to mirror a website, serve it locally under its real domain name using Caddy virtual hosts and Docker network aliases, and use it as a deterministic test fixture for a web crawler.
How I architected a data/ML/NLP project using Redis as a central broker to coordinate microservices without the complexity of Kubernetes.
