Skip to content

postgresql

7 posts

postgresql
Prisma vs Drizzle vs Kysely: Choosing a TypeScript Data Layer

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

How Aurora Serverless v2 Works: Architecture Deep Dive

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

Transactional Outbox Pattern: Reliable Event Publishing in Distributed Systems

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

Aurora vs RDS: When to Choose Amazon Aurora (Architecture and Cost)

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

Database Query Profiling: Systematic Optimization Journey

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

Building a Scalable User Notification System: Architecture and Database Design1/1

Design patterns, database schemas, and architectural decisions for building enterprise notification systems that handle millions of users

typescript · postgresql · architecture +4

How to Choose a Database: SQL vs NoSQL vs NewSQL vs Edge

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