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.
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
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
How Databricks is disrupting Retail and E-Commerce with LTAP direct writes: OLTP and OLAP working together without overwhelming your application

How Databricks is disrupting Retail and E-Commerce with LTAP direct writes: OLTP and OLAP working together without overwhelming your application

Comments
6 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
SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)

SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)

Comments
5 min read
Create record using JooqTemplate

Create record using JooqTemplate

Comments
2 min read
Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, SQLMesh, ER/Studio & Hackolade Compared

Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, SQLMesh, ER/Studio & Hackolade Compared

Comments
10 min read
OpenCode REST API Application with PHP and SQLITE. Articulate By: Md Shoeb Lincoln

OpenCode REST API Application with PHP and SQLITE. Articulate By: Md Shoeb Lincoln

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

Database Indexing: The Performance Trick Nobody Explained Properly

1
Comments
9 min read
Validando CPF dentro do PostgreSQL: função, CHECK constraint e domínio

Validando CPF dentro do PostgreSQL: função, CHECK constraint e domínio

Comments
3 min read
Flag Office Visits Within 6 Months After Surgery

Flag Office Visits Within 6 Months After Surgery

5
Comments
6 min read
Corrected vs. ended: two ways a fact stops being true

Corrected vs. ended: two ways a fact stops being true

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