postgresql
7 posts
A decision framework for the TypeScript data layer on Postgres: how much SQL the library should own, what it costs on Lambda, and when the default is wrong.
typescript · postgresql · data-storage-orm +1
What Aurora Serverless v2 is under the hood: the shared storage layer, ACU-driven compute, the Caspian substrate, scale-to-zero, and mixed-mode clusters.
aws · data-storage-orm · architecture +1
Learn how the Transactional Outbox Pattern solves the dual-write problem in distributed systems, with practical implementations using PostgreSQL, DynamoDB, and CDC tools.
distributed-systems · microservices · event-driven +5
A guide to Aurora architecture, I/O cost analysis, and when to choose it over RDS, with migration strategies and real-world decision frameworks.
aws · data-storage-orm · postgresql +3
Systematic profiling for PostgreSQL and MongoDB: how to find the queries driving latency and infrastructure cost, and which fixes actually move them.
data-storage-orm · postgresql · performance +4
Design patterns, database schemas, and architectural decisions for building enterprise notification systems that handle millions of users
typescript · postgresql · architecture +4
Choose the right database across SQL, NoSQL, NewSQL, and edge options: the trade-offs of each category, selection criteria, and a decision framework.
data-storage-orm · postgresql · redis +6