Dbpro

Run Postgres in Docker the way that works on Postgres 18. The PGDATA change that breaks older guides, volumes, Compose healthchecks, and common errors.

We built a social network on SQLite, put it behind a Node API, and hit it until something broke. One file, one process, 315 million requests a day on the heaviest endpoint. Here are the numbers, the config, and the honest limits.

Hand SQLite a Sudoku puzzle and a single recursive query fills in every blank. No solver library, no loop in JavaScript, just SQL doing backtracking search. Build it from scratch and solve your own.

We gave DB Pro a new logo, a lighter website, and a refreshed brand. Here is the old and the new, side by side, and what the change means to us.

Cellular automata, running on nothing but SQL queries, live in your browser. Press play, then build the whole thing from scratch with runnable SQL.

A practitioner's guide to SQLite performance. The PRAGMAs that change everything, the concurrency model that traps unwary apps, EXPLAIN QUERY PLAN, indexing strategy, FTS5 and JSON, and the tooling worth knowing.

A practitioner's guide to ClickHouse performance. Primary key design, partition pruning, skip indexes, projections, PREWHERE, materialized views, the join strategies that scale, insert patterns, and the system tables worth knowing.

A practitioner's guide to diagnosing and fixing slow Redis workloads. Why Redis slowness is fundamentally different from SQL, the big-key and hot-key problems, SLOWLOG and LATENCY, picking the right data structure, and the configuration that prevents outa

A practitioner's guide to diagnosing and fixing slow MongoDB queries. The diagnostic stack, reading explain output, indexing with the ESR rule, schema design that holds up at scale, aggregation pipeline optimization, and the tools worth knowing.

A practitioner's guide to diagnosing and fixing slow Postgres queries. The diagnostic stack, reading EXPLAIN like a power user, index design, the configuration knobs that change query plans, and the tools worth installing.