The Battle of Distributed Databases: DynamoDB vs PostgreSQL vs MongoDB

A Deep Dive into Architecture, CAP Tradeoffs, and Real-World Production Lessons