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.
Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

1
Comments
5 min read
From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

1
Comments
7 min read
PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Comments
4 min read
How Power BI is Used in Real-World Data Analysis

How Power BI is Used in Real-World Data Analysis

Comments
2 min read
Vector Databases for AI (Milvus/Pinecone)

Vector Databases for AI (Milvus/Pinecone)

1
Comments
8 min read
DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

1
Comments
3 min read
PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

1
Comments
4 min read
Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

1
Comments
4 min read
Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist

Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist

1
Comments 1
6 min read
I built a Graph database to catch money launderers. Here's what I actually learned.

I built a Graph database to catch money launderers. Here's what I actually learned.

Comments
5 min read
Indexing Strategies for Faster Database Queries

Indexing Strategies for Faster Database Queries

1
Comments
7 min read
No Indexes, No Parameters, No Problem

No Indexes, No Parameters, No Problem

Comments
4 min read
Build SQL Queries Without Writing SQL

Build SQL Queries Without Writing SQL

Comments
2 min read
Your agent doesn't remember anything. Persistence isn't memory.

Your agent doesn't remember anything. Persistence isn't memory.

Comments 1
3 min read
Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013

Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013

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