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.
ClickHouse Is Fast. Your Pipeline Isn't.
tigerdata_dev profile

ClickHouse Is Fast. Your Pipeline Isn't.

#performance #webdev #clickhouse #database
Comments
6 min read
Database & Caching at Scale: From 200ms to 15ms Query Times at 100K+ Users
shalinee profile

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

#database #performance #postgres #systemdesign
2
Comments 1
11 min read
Idempotency Is Not Enough: Designing Deterministic Payment Systems
rahmannugar profile

Idempotency Is Not Enough: Designing Deterministic Payment Systems

#backend #database #payments #software
3
Comments 3
6 min read
Build an Ultra-Lightweight, Local-First AI Assistant with Persistent Memory
wspluta profile

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

#oracle #ai #database #picoclaw
Comments
10 min read
Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation
booleanhunter profile

Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation

#ai #tutorial #database #performance
2
Comments
14 min read
Why Your RAG System Needs a Graph Database (Not Just Vectors)
nathanhamlett profile

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

#ai #database #graphdatabase #rag
1
Comments 1
6 min read
Triggers in SQLite: Automating Logic Inside Your Database
lovestaco profile

Triggers in SQLite: Automating Logic Inside Your Database

#webdev #programming #architecture #database
23
Comments
3 min read
Event Sourcing: The Record Statement You Never Throw Away
aishwarya_br profile

Event Sourcing: The Record Statement You Never Throw Away

#systemdesign #backenddevelopment #database #architecture
2
Comments
6 min read
Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames
rozhnev profile

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

#sql #database #tutorial
1
Comments
9 min read
Rethinking Data Layer Design in Full-Stack Development
wafry_ahamed profile

Rethinking Data Layer Design in Full-Stack Development

#architecture #backend #database #webdev
Comments
4 min read
Rejected but Not Defeated: Continuing My Journey Toward AWS Community Builders
cardinal_seen profile

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

#dataengineering #database #dataanalytics #datascience
1
Comments
1 min read
Edge-Native Knowledge Graphs with Cloudflare D1 + Vectorize — No Database Server Required
yedanyagamiaicmd profile

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

#showdev #ai #database #serverless
1
Comments
3 min read
Agent Reasoning: The Thinking Layer
wspluta profile

Agent Reasoning: The Thinking Layer

#oracle #ai #database
Comments
18 min read
ETL vs ELT: Which One Should You Use and Why?
robert_njuguna profile

ETL vs ELT: Which One Should You Use and Why?

#dataengineering #database #data #luxdev
2
Comments
7 min read
Vector Database Integration Patterns: pgvector, Qdrant, and Weaviate Compared
myougatheaxo profile

Vector Database Integration Patterns: pgvector, Qdrant, and Weaviate Compared

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