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.
When Servers Aren't the Problem: The Database Bottleneck

When Servers Aren't the Problem: The Database Bottleneck

2
Comments
9 min read
Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

2
Comments 4
9 min read
SQL Window Functions: How to Get the Top Row Per Group

SQL Window Functions: How to Get the Top Row Per Group

Comments
15 min read
Building a desktop app for repetitive Excel and CSV work

Building a desktop app for repetitive Excel and CSV work

Comments
2 min read
Durable Memory: Why Vector Databases Aren't Enough

The write-side problem highlighted in comments

Durable Memory: Why Vector Databases Aren't Enough

33
Comments 22
5 min read
Why comment-based UGC consent tracking fails silently — and the append-only ledger that fixes it

Why comment-based UGC consent tracking fails silently — and the append-only ledger that fixes it

Comments
8 min read
117K shipping rates over MCP: a production case study

117K shipping rates over MCP: a production case study

1
Comments 5
5 min read
5 SQL queries every data analyst ends up googling

5 SQL queries every data analyst ends up googling

Comments
3 min read
LEARNING SQL

LEARNING SQL

Comments
4 min read
Connection Pooling in the Serverless Era: Five Failure Modes

Connection Pooling in the Serverless Era: Five Failure Modes

Comments 2
13 min read
lib/tasks/force_drop.rake

lib/tasks/force_drop.rake

Comments
7 min read
KoutenDB v0.8.0: A Full Public-Surface Migration

KoutenDB v0.8.0: A Full Public-Surface Migration

Comments
3 min read
Does Prisma respect Supabase RLS? No — here's why

Does Prisma respect Supabase RLS? No — here's why

Comments 1
6 min read
RocheDB Is Now KoutenDB

RocheDB Is Now KoutenDB

Comments
1 min read
SQLite vs. PostgreSQL: Two SQL Giants Built for Different Worlds

SQLite vs. PostgreSQL: Two SQL Giants Built for Different Worlds

6
Comments 1
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.