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.
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
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
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
Building a Change Data Capture (CDC) System Using PostgreSQL Triggers and Java

Building a Change Data Capture (CDC) System Using PostgreSQL Triggers and Java

2
Comments
63 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
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
Create record using JooqTemplate

Create record using JooqTemplate

Comments
2 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
Modeling RERA Escrow Rules in a Real Estate Platform's Data Layer (India, 2026)

Modeling RERA Escrow Rules in a Real Estate Platform's Data Layer (India, 2026)

Comments
2 min read
How to format SQL without uploading your queries

How to format SQL without uploading your queries

Comments
2 min read
Non partire dal database vettoriale

Non partire dal database vettoriale

Comments
2 min read
Ne poÄŤinjite s vektorskom bazom

Ne poÄŤinjite s vektorskom bazom

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