Home

Exploring the fundamental differences between Postgres and MySQL, focusing on indexing strategies and their impact on performance.

A lecture on how database index creation affects write operations and the benefits of concurrent indexing.

A summary of Hussein Nasr's lecture from The Back End Engineering Show, discussing the role of Write-Ahead Logs (WAL), redo logs, and undo logs in ensuring database durability and crash recovery.

This Q&A session covers key database engineering concepts including indexing in PostgreSQL, durability in Redis, lock management in transactions, and the differences between various indexing strategies.

An exploration of bitmap index scans in databases, explaining how they optimize queries with multiple conditions by reducing disk I/O.

Exploring the reasons behind PostgreSQL's behavior of updating all indexes during row updates and how to optimize it.

Notes on why we use read-only transactions and how to choose between sequential keys and UUIDs in databases.

Lecture notes covering TypeScript's arrow functions, rest parameters, and let keyword, explaining their syntax, benefits, and practical use cases from pages 44–53 of the 2019 TypeScript Deep Dive book.