DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Database & Caching at Scale: From 200ms to 15ms Query Times at 100K+ Users

Database & Caching at Scale: From 200ms to 15ms Query Times at 100K+ Users

2
Comments 1
11 min read
Build an Ultra-Lightweight, Local-First AI Assistant with Persistent Memory

Build an Ultra-Lightweight, Local-First AI Assistant with Persistent Memory

Comments
10 min read
Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation

Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation

2
Comments
14 min read
Why Your RAG System Needs a Graph Database (Not Just Vectors)

Why Your RAG System Needs a Graph Database (Not Just Vectors)

1
Comments 1
6 min read
Triggers in SQLite: Automating Logic Inside Your Database

Triggers in SQLite: Automating Logic Inside Your Database

23
Comments
3 min read
Event Sourcing: The Record Statement You Never Throw Away

Event Sourcing: The Record Statement You Never Throw Away

2
Comments
6 min read
Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

1
Comments
9 min read
Rethinking Data Layer Design in Full-Stack Development

Rethinking Data Layer Design in Full-Stack Development

Comments
4 min read
Rejected but Not Defeated: Continuing My Journey Toward AWS Community Builders

Rejected but Not Defeated: Continuing My Journey Toward AWS Community Builders

1
Comments
1 min read
Agent Reasoning: The Thinking Layer

Agent Reasoning: The Thinking Layer

Comments
18 min read
Edge-Native Knowledge Graphs with Cloudflare D1 + Vectorize — No Database Server Required

Edge-Native Knowledge Graphs with Cloudflare D1 + Vectorize — No Database Server Required

1
Comments
3 min read
Idempotency Is Not Enough: Designing Deterministic Payment Systems

Idempotency Is Not Enough: Designing Deterministic Payment Systems

3
Comments 1
6 min read
What is mapping in Hibernate , How to expalin to Interviewer

What is mapping in Hibernate , How to expalin to Interviewer

Comments
4 min read
PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

Comments
11 min read
Drizzle ORM Practical Patterns: Type-Safe Database Access Design

Drizzle ORM Practical Patterns: Type-Safe Database Access Design

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.