My writing.

Java internals, framework quirks, and the occasional Linux command. Explanations and examples for the next time you’re figuring something out.

Articles.

7–12 of 128 articles
databases, indexes, b-tree, query-optimization, performance, PostgreSQL, MySQL, SQL

How Database Indexes Work and When to Use Each Type

A detailed guide to database indexes, covering how B-trees, hash, bitmap, GIN, GiST, BRIN, and other index types work under the hood and which queries each one is built for.

22 views 1 like 3 shares
git, version-control, git-commands, developer-tools, command-line, github

The Most Commonly Used Git Commands Every Developer Should Know

A practical guide to everyday Git commands, explaining when to use each one with real examples, from setting up a repository to branching, merging, rebasing, and undoing mistakes.

7 views 1 like 1 share
Database

How Multi-Version Concurrency Control (MVCC) Works in Databases

A deep dive into MVCC, covering snapshots, version visibility rules, isolation levels, garbage collection, and how PostgreSQL, MySQL InnoDB, and Oracle implement it.

24 views 1 like 4 shares
Java

Shenandoah GC - The Quiet Revolution in Low-Latency Java

A deep dive into how Shenandoah achieves near-constant low pause times through concurrent marking, evacuation, and reference updating.

23 views 1 like 1 share
Database

How Write-Ahead Logging Ensures Database Durability and Crash Recovery

A detailed explanation of Write-Ahead Logging (WAL), covering its principles, recovery mechanisms, ARIES algorithm, and real-world implementations in modern databases.

66 views 3 likes 4 shares
Database

Essential Database Internals Every Engineer Should Know

A crisp reference of core database internals topics that every software engineer should understand.

26 views 2 likes 1 share