#Databases

2 articles tagged with "databases"

🗑️ Soft Deletes vs Hard Deletes vs Audit Tables: Pick Your Strategy Before Production Picks It for You

Deleting a database row sounds trivial — until your boss asks why the customer record vanished and nobody knows. Here is how to pick the right deletion strategy before a production incident forces your hand.

May 19, 2026

6 min read

backendapi-design

Cursor-Based Pagination: Why OFFSET Is Slowly Killing Your API 🐌

OFFSET pagination feels intuitive until your database is scanning 500,000 rows to serve page 100. Cursor-based pagination fixes the performance cliff, ghost records, and duplicate entries in one shot.

May 18, 2026

6 min read