Your team is scaling fast. You pick PostgreSQL for everything.
6 months later, you’re re-architecting under production load.
Here’s what nobody tells you upfront: there is no “best” database. There’s only the right model for the right access pattern.
In 2026, every production system worth running is polyglot by design.
Here’s the cheat sheet:
🗄️ PostgreSQL: when your data has relationships and your queries have joins.
Stripe runs financial transactions on it. ACID compliance isn’t optional when money moves.
⚡ DynamoDB: when you need single-digit millisecond reads at millions of RPS.
Amazon’s shopping cart hit 89M requests per second on Prime Day 2023. DynamoDB handled it.
The catch: design your access patterns upfront or pay for full table scans.
🧠 Redis: when 5ms is still too slow.
Sub-millisecond reads, 100k+ RPS on a single node. Perfect for sessions, caching, leaderboards. Just don’t use it as your primary DB without persistence configured.
📦 S3: when you need to store it, not query it.
Netflix stores 15+ petabytes of video on S3 at $0.023/GB. PostgreSQL has no business touching a media file.
🔗 Cassandra: when you’re writing more than you’re reading, at scale.
Discord migrated from MongoDB to Cassandra when they hit 250M+ messages per day. Time-series and event data love column-family stores.
The architectural trap isn’t choosing the wrong database. It’s choosing one database.
Using DynamoDB like PostgreSQL (UUIDs as PKs, no single-table design)?
That’s not NoSQL — that’s a relational database with extra steps and a larger AWS bill.
Dumping binary blobs into PostgreSQL columns instead of S3?
You’re paying block storage prices for object storage problems.
The modern approach: PostgreSQL for your transactional core, Redis as the cache layer, S3 for artifacts, DynamoDB for high-throughput microservice data.
Each tool doing what it was built for.
The question isn’t “which database is best.”
It’s “what does my access pattern actually look like?”
Answer that first. The right storage model falls out of it naturally.
#SystemDesign #BackendEngineering #AWS #DistributedSystems #SoftwareEngineering

Joud Awad

Choosing a single database for everything is a common architectural mistake. In modern production systems, polyglot persistence is the norm: PostgreSQL for relational transactional data, DynamoDB for high-throughput key-value access, Redis for sub-millisecond caching, S3 for object storage, and Cassandra for write-heavy time-series workloads. The key insight is that database selection should be driven by access patterns, not familiarity or convenience. Real-world examples from Stripe, Amazon, Netflix, and Discord illustrate each tool's strengths and the cost of misusing them.

Data Storage Strategies in 2026