Database

Isolation levels are usually taught as an abstract table of names and guarantees nobody remembers. They are far clearer explained backwards — through the concrete bug each level allows, from dirty reads to the lost update that quietly corrupts your data.

Indexes are the first thing people add for performance and the last thing they audit. Which index types actually earn their place, why the column order in a composite index decides everything, and how to find the indexes silently costing you on every write.

EXPLAIN ANALYZE output looks like a wall of numbers. Only four of them matter, it reads inside out, and the gap between estimated and actual rows finds most bad plans on its own.

One ALTER TABLE can take an ACCESS EXCLUSIVE lock and stall every query behind it. Learn the expand-contract migration pattern, lock_timeout guards, chunked backfills, CONCURRENTLY index builds, and which Postgres DDL is genuinely safe.

A practical comparison of PgBouncer, PgCat, and Supavisor: pooling modes, prepared-statement support, load balancing, sizing math, and the pitfalls that bite teams in production.

A practitioner deep-dive into PostgreSQL 18 asynchronous I/O: io_method tuning, io_uring requirements, sequential scan throughput gains, and real pgbench numbers compared to PG17.

A field-tested guide to running Qdrant at scale: distributed mode with raft, scalar and binary quantization, payload indexing, hybrid search with sparse vectors, and the Kubernetes operator setup we shipped to production.

Complete guide to using DuckDB for analytical workloads. Covers Parquet file processing, window functions, Python and Java integration, and embedding in applications.

Deep dive into PostgreSQL 17 logical replication patterns for multi-region database deployments including conflict resolution, failover, and monitoring strategies.