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 Search Result Is Not an Archive Total

An AI Search Result Is Not an Archive Total

Comments
4 min read
Decoding a UUID by hand: version, variant, and the embedded timestamp

Decoding a UUID by hand: version, variant, and the embedded timestamp

Comments 1
5 min read
The N+1 Query Problem — "It works locally, but is extremely slow in production"

The N+1 Query Problem — "It works locally, but is extremely slow in production"

1
Comments 1
5 min read
Operational simplicity: the cross-key tax, quantified

Operational simplicity: the cross-key tax, quantified

Comments 1
3 min read
NocoBase updates by primary key, not by your filter

NocoBase updates by primary key, not by your filter

1
Comments 1
8 min read
The Real Cost of a Single Insert in Postgres

The Real Cost of a Single Insert in Postgres

Comments
7 min read
Memory efficiency: bytes per key

Memory efficiency: bytes per key

Comments 1
2 min read
Zero-Downtime Database Migrations: Lessons from GitLab's PostgreSQL Architecture

Zero-Downtime Database Migrations: Lessons from GitLab's PostgreSQL Architecture

Comments 1
4 min read
The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL

The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL

1
Comments
10 min read
We moved a production backend from a phone

We moved a production backend from a phone

23
Comments
3 min read
Zoho CRM duplicate records and double data entry: how to stop them

Zoho CRM duplicate records and double data entry: how to stop them

Comments 3
3 min read
Database Indexing: The Performance Trick Nobody Explained Properly

Database Indexing: The Performance Trick Nobody Explained Properly

1
Comments
9 min read
Oracle Autonomous AI Database 26ai: More Than Just a Database

Oracle Autonomous AI Database 26ai: More Than Just a Database

Comments
5 min read
Why Timestamps Lie in Distributed Systems (and How Logical Clocks Fix It)

Why Timestamps Lie in Distributed Systems (and How Logical Clocks Fix It)

11
Comments 1
10 min read
When an agent's question is a path, not a similarity score

When an agent's question is a path, not a similarity score

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