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.
SQL Is Surviving, Franklin: When One Query Isn't Enough

SQL Is Surviving, Franklin: When One Query Isn't Enough

2
Comments
13 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
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
MongoDB Aggregation Pipelines: Stage Order Is the Win

MongoDB Aggregation Pipelines: Stage Order Is the Win

Comments 2
3 min read
MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

Comments 1
2 min read
Memory efficiency: bytes per key

Memory efficiency: bytes per key

Comments 1
2 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
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
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
Nile isolates Postgres tenants with a tenant_id column and one session variable

Nile isolates Postgres tenants with a tenant_id column and one session variable

6
Comments 3
5 min read
SQL Window Functions 101

SQL Window Functions 101

2
Comments
2 min read
Postgres for everything hits a wall the moment dashboards get concurrent

Postgres for everything hits a wall the moment dashboards get concurrent

1
Comments 1
3 min read
SQL for Beginners: Window Functions vs GROUP BY

SQL for Beginners: Window Functions vs GROUP BY

1
Comments
4 min read
Two Sources of Truth Will Always Disagree

Two Sources of Truth Will Always Disagree

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