Decoding Digital Anomalies
Sometimes the feature is the bug in the digital rabbit hole, and vice versa
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.
Discover how mock servers transform development workflows by simulating APIs and services, enabling parallel development, comprehensive testing, and faster iteration cycles without external dependencies.
Master multilingual content management in Hexo with custom plugins, URL strategies, and performance optimization through fragment caching.
Discover why RPC services and SQL Server named instances should never use ephemeral ports, and learn how to configure static ports for reliable, secure server applications.
Uncover the invisible workers behind every network connection. Learn how ephemeral ports enable hundreds of simultaneous connections on your computer.
From test-everything monsters to sleep-and-pray approaches, explore real-world testing nightmares and learn how to write maintainable tests that actually give you confidence.
Tools aren't the whole answer. Discover how threat modeling and maturity models transform DevSecOps from a toolset into a security culture that protects what matters.
Shell and SSH access to containers is convenient, but why are they bad for Docker? Explore the security risks and better alternatives for container interaction.
A collection of Hexo plugins I developed to enhance static blogs with comments, GitHub cards, and more functionality.
Explore Slidev and LLMs for presentation-as-code, but layout adjustments and animations remain challenging even with AI assistance.
Ditch the VPN subscription and start living like a digital nomad - minus the Instagram-worthy coffee shop vibes. Just grab a pay-as-you-go cloud VPN and wing it (your wallet will thank you)!
From infrastructure to AI models, explore how the "as code" paradigm is transforming software development. Discover maturity assessments and best practices across 10+ domains.
Master Terraform debugging with trace logs, parallelism control, and dependency analysis to solve infrastructure code issues efficiently.
It's 3 AM and deployment failed? Just git revert and redeploy! Learn how to manage Jenkins pipelines as code using seeder scripts, with state management patterns and security best practices.
From relational to graph databases - explore the diverse world of data storage systems and learn which database type fits your application's needs.
Hit empty tuple errors with feature toggles? Master four solutions: try(), conditional expressions, splat expressions, and for loops to handle empty tuples in Terraform gracefully.
ChatGPT isn't replacing developersāit's the perfect pair programming partner! Learn the magic question "can you propose better coding?" for meaningful code reviews and refactoring.