Tools, Games and Browser Built-in AI Playground
Discover practical developer tools, 3D games, and Chrome's built-in AI power. No servers needed - AI assistants running entirely in your browser are changing web development forever.
Decoding Digital Anomalies
Sometimes the feature is the bug in the digital rabbit hole, and vice versa
Discover practical developer tools, 3D games, and Chrome's built-in AI power. No servers needed - AI assistants running entirely in your browser are changing web development forever.
Discover genuinely free proctored IT certifications from ISC2, Google Cloud, Cisco, and more to boost your career without breaking the bank.
A comprehensive quick reference guide to cloud architecture patterns. Find the right pattern for your challenge with decision trees, comparison tables, and practical selection criteria.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Scale Architecture Decision Logs across your organization. Stakeholder management, complete workflow, measuring effectiveness, and real before/after scenarios.
Learn how to write your first Architecture Decision Record. Templates, real e-commerce examples, and the five questions every ADR must answer.
Comprehensive reference guide for all acronyms and abbreviations used in the RTGS series, from payment systems to security and architecture.
Final installment covering high availability architecture, performance optimization, scalability patterns, and operational excellence for RTGS systems.
Comprehensive guide to security architecture and risk management in RTGS systems, covering threats, controls, and compliance requirements.
Mapping CPSS-IOSCO PFMI principles to technical controlsāhow RTGS systems implement regulatory requirements through architecture, monitoring, and operational procedures.
Guide to ISO 20022 version migrationāunderstanding CBPR+ market practices, message version changes, and strategies for evolving RTGS systems without breaking settlement.
Comprehensive guide to ISO 20022 cardinality rulesānotation, validation, common pitfalls, and practical examples for RTGS developers.