ADevGuide Tag: Databases
All the articles with the tag "Databases".
-
Why Is My SQL Query Slow? A Backend Debugging Guide
Series: Backend Interview Mastery
Learn why SQL queries are slow and use EXPLAIN ANALYZE, query plans, indexes, and production evidence to fix them safely.
-
Database Replication: Read Replicas, Lag, and Failover
Series: Backend Interview Mastery
Learn database replication, read replicas, replication lag, stale reads, and failover trade-offs for reliable backend systems.
-
Database Deadlocks: Causes, Detection, and Prevention
Series: Backend Interview Mastery
Learn database deadlocks through transaction examples, wait-for cycles, retries, lock ordering, query design, and production prevention practices.
-
Optimistic vs Pessimistic Locking: How to Choose
Series: Backend Interview Mastery
Compare optimistic vs pessimistic locking with SQL examples, conflict handling, retries, deadlocks, and practical backend trade-offs.
-
Database Isolation Levels Explained With Real Transaction Examples
Series: Backend Interview Mastery
Learn database isolation levels through real transaction examples, including dirty reads, phantoms, write skew, retries, and SQL trade-offs.
-
Composite Index Column Order: How to Choose the Right SQL Index
Series: Backend Interview Mastery
Learn how to choose composite index column order for SQL queries using equality, range, sort, selectivity, and EXPLAIN plan trade-offs.
-
Offset vs Cursor vs Keyset Pagination for Backend Interviews
Series: Backend Interview Mastery
Compare offset, cursor, and keyset pagination for backend interviews: performance, consistency, indexes, API contracts, and trade-offs.