Tag: Backend

All the articles with the tag "Backend".

• Database Replication: Read Replicas, Lag, and Failover

  4 Sep, 2026

  By Pratik Bhuite | 25 min read

  Series: Backend Interview Mastery

  Learn database replication, read replicas, replication lag, stale reads, and failover trade-offs for reliable backend systems.

  • Backend
  • Databases
  • Replication

• Database Deadlocks: Causes, Detection, and Prevention

  3 Sep, 2026

  By Pratik Bhuite | 12 min read

  Series: Backend Interview Mastery

  Learn database deadlocks through transaction examples, wait-for cycles, retries, lock ordering, query design, and production prevention practices.

  • Backend
  • Databases
  • SQL

• Optimistic vs Pessimistic Locking: How to Choose

  2 Sep, 2026

  By Pratik Bhuite | 12 min read

  Series: Backend Interview Mastery

  Compare optimistic vs pessimistic locking with SQL examples, conflict handling, retries, deadlocks, and practical backend trade-offs.

  • Backend
  • Databases
  • SQL

• Database Isolation Levels Explained With Real Transaction Examples

  1 Sep, 2026

  By Pratik Bhuite | 16 min read

  Series: Backend Interview Mastery

  Learn database isolation levels through real transaction examples, including dirty reads, phantoms, write skew, retries, and SQL trade-offs.

  • Backend
  • Databases
  • SQL

• Composite Index Column Order: How to Choose the Right SQL Index

  31 Aug, 2026

  By Pratik Bhuite | 24 min read

  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.

  • Backend
  • Databases
  • SQL

• Database Indexing Explained: SQL Examples and Interview Questions

  Updated

  Updated: 30 Aug, 2026

  By Pratik Bhuite | 20 min read

  Series: Database Fundamentals , Backend Interview Mastery

  Learn database indexing with SQL examples: B-tree indexes, query plans, composite index order, write costs, and interview questions.

  • Database
  • SQL
  • Performance

• API Gateway vs Load Balancer vs Reverse Proxy

  30 Aug, 2026

  By Pratik Bhuite | 13 min read

  Series: Backend Interview Mastery

  Compare API gateways, load balancers, and reverse proxies for backend interviews: responsibilities, request flow, overlap, and architecture trade-offs.

  • Backend
  • System Design
  • API Gateway

• Offset vs Cursor vs Keyset Pagination for Backend Interviews

  30 Aug, 2026

  By Pratik Bhuite | 12 min read

  Series: Backend Interview Mastery

  Compare offset, cursor, and keyset pagination for backend interviews: performance, consistency, indexes, API contracts, and trade-offs.

  • Backend
  • API Design
  • Databases

• Webhooks Explained: Delivery, Retries, Security and Idempotency

  30 Aug, 2026

  By Pratik Bhuite | 15 min read

  Series: Backend Interview Mastery

  Learn webhooks for backend interviews: delivery flow, retries, HMAC signatures, replay protection, idempotency, queues, and failure handling.

  • Backend
  • API Design
  • Webhooks

• API Rate Limiting: Fixed Window, Sliding Window and Token Bucket

  30 Aug, 2026

  By Pratik Bhuite | 9 min read

  Series: Backend Interview Mastery

  Learn API rate limiting for backend interviews: fixed and sliding windows, token bucket, Redis atomicity, 429 responses, and trade-offs.

  • Backend
  • API
  • Rate Limiting