Tag: database
All the articles with the tag "database".
ACID in Databases: What PostgreSQL Guarantees and What It Doesn't
Published: at 08:00 AM (6 min read)PostgreSQL is fully ACID-compliant — but ACID is a shared responsibility, not a free guarantee. Here's what the database enforces on its own, what you have to ask for, and where the traps are in Rails.
Composite Indexes in PostgreSQL: The Small Change With a Big Impact
Published: at 08:00 AM (7 min read)Most developers add indexes and move on. But a single misunderstood rule about composite indexes leads to redundant indexes that silently cost you at write time, at query time, and at scale. Here's how to get them right — and how to add them safely in production.
Idempotency in Distributed Systems: 5 Patterns Every Backend Engineer Should Know
Published: at 08:00 AM (7 min read)Silent duplicates are the hardest bugs in distributed systems. This article breaks down five idempotency patterns — from optimistic locking to the transactional outbox — with practical Rails examples.