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.
We didn't want an AI SQL reviewer. We wanted deterministic

We didn't want an AI SQL reviewer. We wanted deterministic

1
Comments
5 min read
A Beginner's Guide to SQL Joins and Window Functions

A Beginner's Guide to SQL Joins and Window Functions

1
Comments
6 min read
How We Query 16.8M SIRENE Establishments in 66ms

How We Query 16.8M SIRENE Establishments in 66ms

1
Comments
3 min read
Scaling pgvector: Memory, Quantization, and Index Build Strategies

Scaling pgvector: Memory, Quantization, and Index Build Strategies

1
Comments
4 min read
PostgreSQL Query Optimization: 10 Techniques That Actually Work

PostgreSQL Query Optimization: 10 Techniques That Actually Work

1
Comments
12 min read
Running PostgreSQL on Kubernetes: Operators, Storage and Production Guide

Running PostgreSQL on Kubernetes: Operators, Storage and Production Guide

Comments
11 min read
pg_ducklake: Columnar Storage for PostgreSQL

pg_ducklake: Columnar Storage for PostgreSQL

2
Comments
2 min read
I Built a Database That Never Forgets — Here's Why

I Built a Database That Never Forgets — Here's Why

1
Comments
14 min read
Day 33 of #100DaysOfCode — Mongoose

Day 33 of #100DaysOfCode — Mongoose

3
Comments
3 min read
A Evolução do Modelo Relacional para Objeto-Relacional

A Evolução do Modelo Relacional para Objeto-Relacional

1
Comments
4 min read
A Evolução do Modelo Relacional para o Objeto-Relacional: Entendendo o PostgreSQL

A Evolução do Modelo Relacional para o Objeto-Relacional: Entendendo o PostgreSQL

Comments
3 min read
PostgreSQL vs MySQL: Database Selection Guide for Developers (2026)

PostgreSQL vs MySQL: Database Selection Guide for Developers (2026)

1
Comments
15 min read
How to set up MariaDB Galera cluster for high availability

How to set up MariaDB Galera cluster for high availability

1
Comments
8 min read
PostgreSQL High Availability: Patroni, Replication and Failover Patterns

PostgreSQL High Availability: Patroni, Replication and Failover Patterns

1
Comments
12 min read
TimescaleDB Compression: A Complete Guide to 95%+ Storage Reduction

TimescaleDB Compression: A Complete Guide to 95%+ Storage Reduction

1
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.