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.
Why Fake PostgreSQL Test Data Misses Real Bugs

Why Fake PostgreSQL Test Data Misses Real Bugs

1
Comments
6 min read
One-trick ponies are easy to replace

One-trick ponies are easy to replace

2
Comments 2
4 min read
How we give every user SQL access to a shared ClickHouse cluster

How we give every user SQL access to a shared ClickHouse cluster

11
Comments
13 min read
SQL formatting — a practical guide for developers

SQL formatting — a practical guide for developers

Comments
6 min read
SQL Deep Dive: Subqueries vs. CTEs — Which One Should You Use?

SQL Deep Dive: Subqueries vs. CTEs — Which One Should You Use?

2
Comments
2 min read
Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database

Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database

5
Comments
25 min read
TiDB for AI Memory: Vector Search, HTAP, and Horizontal Scaling in One Database

TiDB for AI Memory: Vector Search, HTAP, and Horizontal Scaling in One Database

1
Comments
18 min read
Real-Time SQL Analysis in VS Code: Catch Dangerous Queries Before You Save the File

Real-Time SQL Analysis in VS Code: Catch Dangerous Queries Before You Save the File

1
Comments
3 min read
Database Backup Fidelity: Why Crash-Consistent Is Not a Database Backup

Database Backup Fidelity: Why Crash-Consistent Is Not a Database Backup

1
Comments
6 min read
3-Tier Memory: How SoulClaw Agents Never Forget

3-Tier Memory: How SoulClaw Agents Never Forget

1
Comments
3 min read
30-Day Cloud & DevOps Challenge: Day 4 — PostgreSQL Deep Dive (From Zero to Database Hero)

30-Day Cloud & DevOps Challenge: Day 4 — PostgreSQL Deep Dive (From Zero to Database Hero)

4
Comments
5 min read
SQL JOINs Explained Simply – From Beginner to Data Analyst

SQL JOINs Explained Simply – From Beginner to Data Analyst

1
Comments 1
2 min read
I built a 13-database ORM for Node.js because Prisma doesn't support Oracle

I built a 13-database ORM for Node.js because Prisma doesn't support Oracle

Comments
9 min read
When Monitoring Saves the Day: How We Optimized Our Production Database Without Increasing Costs

When Monitoring Saves the Day: How We Optimized Our Production Database Without Increasing Costs

Comments
3 min read
Mutable BSON and Oracle OSON

Mutable BSON and Oracle OSON

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