Home

A personal look into how databases manage concurrent access through two main strategies: optimistic and pessimistic concurrency control.

This lecture covers how MySQL 8 improved locking in InnoDB with smarter page-level concurrency and B+ tree optimizations.

A practical and clear overview of Postgres lock types, their behaviors, and real-world implications.

This lecture explores write amplification across application, database, and storage levels, highlighting its impact on performance and hardware longevity.

Exploring NULLs in databases, their storage in PostgreSQL using null bitmaps, and their impact on query performance, with practical tips for optimization.

A summary of a lecture discussing Uber's 2016 migration from Postgres to MySQL, covering technical challenges, community backlash, and lessons on database choices.

A comparison of indexing mechanisms in PostgreSQL and MySQL, highlighting their differences in performance for reads and writes.

A deep dive into hash tables, their use in database joins, limitations, and how consistent hashing solves scaling issues in distributed systems.