Home

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.

This lecture explores working with multiple tables in relational databases, covering relationships, keys, Entity Relationship Diagrams (ERDs), and advanced SQL queries in SQLite.

This lecture note explores the use of non-key column indexes in databases, discussing their benefits, costs, and best practices for implementation.

This lecture note explains the serializable isolation level in database transactions and compares it with the use of SELECT FOR UPDATE for concurrency control.

In this Q&A session, we explore why using a single database connection for multiple clients is problematic and how connection pooling solves these issues.