Architecture Decision Log: Advanced Topics (Part 2)
Scale Architecture Decision Logs across your organization. Stakeholder management, complete workflow, measuring effectiveness, and real before/after scenarios.
Archive: 2026
Architecture Decision Log: A Practical Guide (Part 1)
Learn how to write your first Architecture Decision Record. Templates, real e-commerce examples, and the five questions every ADR must answer.
Environment on Demand (Part 1): Architecture & Implementation
First in a 3-part series on Environment on Demand. Learn what EoD is, how to architect it with GitOps, and when it shines vs. struggles. Plus: why AI-assisted coding makes provisioning the new bottleneck.
Environment on Demand (Part 2): Lifecycle, AI Coding & Optimization
Second in a 3-part series on Environment on Demand. Learn environment lifecycle management, why AI-assisted coding makes provisioning the bottleneck, and deployment strategies for different tiers.
Environment on Demand (Part 3): Alternative Productivity Accelerators
Final part of a 3-part series on Environment on Demand. Explore alternatives like mock servers, feature flags, dev containers, and CI/CD optimization. Learn to choose the right accelerator for your team.
Understanding PostgreSQL's Volcano Model: The Iterator Execution Architecture
Deep dive into the Volcano ModelāPostgreSQL's foundational execution architecture. Learn how Next()/GetNext() drives every query, why row-by-row processing matters, and when vectorization breaks the rules.
Understanding PostgreSQL Parallel Query Execution: Multi-Core Performance
Deep dive into PostgreSQL's parallel query executionāhow Gather nodes, parallel workers, and multi-core processing accelerate large table scans, hash joins, and aggregations. Learn when parallelism helps, when it hurts, and how to tune it.
Building a PostgreSQL-Compatible Database in Rust: Page-Based Storage and Buffer Pool
Why I'm building Vaultgresāa PostgreSQL-compatible database in Rustāto explore database internals beyond CRUD apps. Deep dive into page-based storage, buffer pool management, and the challenges of implementing WAL-compatible storage with AI-assisted development.
Database in Rust: B+Tree Indexes with Concurrent Access
Part 2 of the Vaultgres journey: implementing B+Tree indexes that power fast lookups. Deep dive into tree structure, page splits, and the nightmare of concurrent access with lock coupling and safe traversal.
Database in Rust: Histogram Statistics for Accurate Selectivity Estimation
Part 8 of the Vaultgres journey: deep dive into histogram statistics. Building equi-depth histograms, handling skewed data, multi-column statistics, and using histograms for accurate selectivity estimation in cost-based optimization.
Database in Rust: MVCC and Transaction Management
Part 3 of the Vaultgres journey: implementing MVCC for non-blocking reads and snapshot isolation. Deep dive into transaction IDs, visibility rules, vacuum, and the horror of transaction ID wraparound.
Database in Rust: Cost-Based Query Optimizer with Statistics
Part 7 of the Vaultgres journey: building a cost-based query optimizer. Deep dive into statistics collection, cost models, join ordering with dynamic programming, and index selection.
Database in Rust: Comprehensive SQL Parser (DDL, DML, Queries)
Part 6 of the Vaultgres journey: building a SQL parser from scratch. Deep dive into lexing, recursive descent parsing, AST design for DDL/DML/queries, and expression precedence handling.
Database in Rust: WAL and Crash Recovery with ARIES
Part 4 of the Vaultgres journey: implementing Write-Ahead Logging and the ARIES recovery algorithm. Deep dive into durability, checkpoints, and the three-phase recovery that brings your database back from a crash.
Database in Rust: Wire Protocol and Result Set Serialization
Part 5 of the Vaultgres journey: implementing the PostgreSQL wire protocol. Deep dive into message framing, startup handshake, extended query protocol, and serializing result sets that psql and drivers can understand.