Tag archive

#sql

Topic-specific entry points for internal linking, discovery, and deeper subject exploration.

8 articles

API Pagination at Scale: Why OFFSET 100,000 is a Database Killer

API Pagination at Scale: Moving Beyond OFFSET Designing a paginated API seems simple: just use LIMIT 20 OFFSET 100. This works perfectly for the first few pages. However, once your users reach page 5,000, your database p…

Apr 20, 20262 min read

Deep DiveBackend Systems Mastery

#api-design#pagination#sql

DatabasesIntermediate

Optimistic vs. Pessimistic Locking: Concurrency Control in Practice

Optimistic vs. Pessimistic Locking Imagine two users trying to book the last seat on a flight at the same time. If both read the count as "1" and decrement it, you've oversold the flight. This is the Lost Update Problem,…

Apr 20, 20262 min read

Deep DiveBackend Systems Mastery

#database#concurrency#locking

DatabasesExpert

Query Optimization: The Hidden Cost of Cross-Shard Joins

Query Optimization: The Hidden Cost of Cross-Shard Joins In a sharded database, the "Scatter-Gather" query is the silent performance killer. When you perform a join on columns that aren't the shard key, your proxy has to…

Apr 20, 20261 min read

Deep DiveDatabase Sharding Mastery

#sharding#database-optimization#queries

DatabasesAdvanced

SQL vs NoSQL: Which One for Your Next Production MVP?

SQL vs NoSQL: Making the Right Choice One of the most debated topics in software engineering is whether to use a Relational (SQL) or Non-Relational (NoSQL) database. As a senior engineer, your choice shouldn't be based o…

Apr 20, 20262 min read

ComparisonBackend Systems Mastery

#sql#nosql#databases

DatabasesAdvanced

Zero-Downtime Migration: Moving from SQL to NoSQL

Zero-Downtime Migration: Moving from SQL to NoSQL Migrating a live production system from a relational database (like PostgreSQL) to NoSQL (like DynamoDB or MongoDB) is like changing an airplane engine in mid-flight. You…

Apr 20, 20262 min read

Deep Dive

#data-migration#sql#nosql

DatabasesAdvanced

PostgreSQL Locking Playbook: Deadlocks, Blocking Queries, and Timeouts

PostgreSQL locking problems rarely announce themselves clearly. The application sees slow requests, connection pool exhaustion, or timeouts. The database might show normal CPU. The real problem is often one transaction w…

Apr 8, 202611 min read

Playbook

#postgresql#locking#deadlocks

DatabasesAdvanced

PostgreSQL Performance Tuning: From Slow Queries to Sub-Millisecond Reads

PostgreSQL ships with defaults tuned for a 512MB machine from 2005. Every production deployment needs to be re-tuned. Beyond that, most slow queries are not a PostgreSQL problem — they're a query design problem that Post…

Jun 3, 20259 min read

Deep Dive

#postgresql#databases#performance

DatabasesAdvanced

PostgreSQL vs MongoDB vs DynamoDB: When to Use Which Database

Every database choice is a bet on your access patterns. PostgreSQL, MongoDB, and DynamoDB are all excellent databases — for different problems. The mistake engineers make is choosing based on hype ("NoSQL scales better")…

Jan 12, 202511 min read

Comparison

#postgresql#mongodb#dynamodb