data-storage-orm
11 posts
Keep identity reads in DynamoDB, route arbitrary sort, filters, facets, and full text to a zero-ETL OpenSearch read model, and know when one PostgreSQL beats both.
dynamodb · aws · architecture +2
DynamoDB has no OFFSET, no arbitrary ORDER BY, and no cheap COUNT. Ship signed next/prev cursors, model sort orders as sort keys, and drop the total count.
dynamodb · aws · data-storage-orm +2
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
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
Model relationships, choose between GSI and LSI, integrate DAX caching, and avoid hot partitions in production DynamoDB single-table designs with working examples.
dynamodb · data-storage-orm · aws +1
A foundational guide to key-value storage: what it is, where it fits, why teams choose it, and which solutions ship with which technology stacks.
redis · dynamodb · caching +4
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
Master DynamoDB migrations, environment variable management, secrets handling, and VPC configurations when moving from Serverless Framework to AWS CDK.
aws · aws-cdk · dynamodb +4