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.
An AI explained SQL GROUP BY in four lines. One of them is wrong.

An AI explained SQL GROUP BY in four lines. One of them is wrong.

Comments
1 min read
The Index Is There and the Plan Still Reads 1,000 Pages

The Index Is There and the Plan Still Reads 1,000 Pages

Comments
27 min read
Constraints in PostgreSQL

Constraints in PostgreSQL

Comments
5 min read
SQL Beyond SELECT: Understanding SQL Sublanguages.

SQL Beyond SELECT: Understanding SQL Sublanguages.

Comments
7 min read
OpenViking's Self-Evolving Context Database: How Agent Memory, RAG, and Skills Unify Under One Storage Layer

OpenViking's Self-Evolving Context Database: How Agent Memory, RAG, and Skills Unify Under One Storage Layer

1
Comments
5 min read
The Backup Exists. The Restore Still Needs Work.

The Backup Exists. The Restore Still Needs Work.

Comments
6 min read
GBase Database Installation Troubleshooting: 5 Common Causes and Fixes

GBase Database Installation Troubleshooting: 5 Common Causes and Fixes

2
Comments
2 min read
Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Comments 1
6 min read
Oracle to Snowflake migration validation: a six-gate acceptance framework

Oracle to Snowflake migration validation: a six-gate acceptance framework

Comments
4 min read
I built a verified data API system using 100% AI-generated code and $0. Here is how it works.

I built a verified data API system using 100% AI-generated code and $0. Here is how it works.

1
Comments
2 min read
I built erd.sketch to turn SQL schemas into editable diagrams

I built erd.sketch to turn SQL schemas into editable diagrams

Comments
3 min read
Reading DDIA, Day 2: Human Errors, Scalability, and Why Latency Response Time

Reading DDIA, Day 2: Human Errors, Scalability, and Why Latency Response Time

Comments
3 min read
Processing XML in PostgreSQL: Do You Really Need PL/Python?

Processing XML in PostgreSQL: Do You Really Need PL/Python?

Comments
10 min read
Why Vector Databases Need Approximate Nearest Neighbor (ANN): HNSW Graphs and the Curse of Dimensionality

Why Vector Databases Need Approximate Nearest Neighbor (ANN): HNSW Graphs and the Curse of Dimensionality

1
Comments
5 min read
The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

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