Skip to content

Data Storage · Development

Programming languages, patterns, and development practices

DynamoDB Pagination: Signed Cursors, Sorting, and the Count Problem

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

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

RAG Data Preparation: The Foundation That Makes or Breaks Your AI System

Comprehensive guide to preparing data for RAG systems covering document parsing, chunking strategies, contextual enrichment, and embedding optimization

rag · llm · embeddings +2

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

RAG Architecture Patterns: Beyond Basic Vector Search

A comprehensive guide to advanced RAG techniques including hybrid search, reranking, GraphRAG, and self-corrective patterns with production AWS implementation examples.

rag · llm · vector-databases +4

Strapi vs Contentful vs Storyblok vs Kontent.ai: A Headless CMS Comparison

A practical comparison of headless CMS options (Strapi, Contentful, Kontent, Storyblok) with Cloudinary image management and framework integration.

typescript · nextjs · react-native +3

What Is a Key-Value Store? Choosing the Right Solution

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

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