Home

A comprehensive guide to the Transmission Control Protocol (TCP), covering its key features, connection management, and practical implementations.

A reflective note on how using `SELECT *` in SQL can introduce hidden performance costs and maintenance issues.

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.