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.
pgcoalesce: a Postgres proxy that merges concurrent point reads

pgcoalesce: a Postgres proxy that merges concurrent point reads

1
Comments
14 min read
Building the Open Data Lakehouse: An End-to-End Architecture Guide

Building the Open Data Lakehouse: An End-to-End Architecture Guide

Comments
5 min read
A filtered DynamoDB Scan still reads the whole table

A filtered DynamoDB Scan still reads the whole table

Comments
3 min read
Detecting Duplicate Email Records Using Oracle AI Database 26ai and SQL

Detecting Duplicate Email Records Using Oracle AI Database 26ai and SQL

Comments
8 min read
Apache Data Lakehouse Weekly: November 3 to 11, 2026

Apache Data Lakehouse Weekly: November 3 to 11, 2026

1
Comments
28 min read
Mastering SQL Anti-Joins: Finding Missing Records with LEFT JOIN and IS NULL

Mastering SQL Anti-Joins: Finding Missing Records with LEFT JOIN and IS NULL

1
Comments
2 min read
Letting AI agents query production databases without giving them a database account

Letting AI agents query production databases without giving them a database account

1
Comments 2
4 min read
What does uninstalling an Odoo module really delete? I measured it for CRM

What does uninstalling an Odoo module really delete? I measured it for CRM

Comments
1 min read
Setting Up PostgreSQL with Docker, psql, and pgAdmin

Setting Up PostgreSQL with Docker, psql, and pgAdmin

Comments
11 min read
MySQL ENUM vs CHECK Constraint: Which Value List Changes Copy the Table

MySQL ENUM vs CHECK Constraint: Which Value List Changes Copy the Table

Comments
10 min read
Troubleshoot Redis Replication Easily with Ivory

Troubleshoot Redis Replication Easily with Ivory

Comments
4 min read
Zero-Downtime Database Migrations: The Expand-and-Contract Pattern (With PostgreSQL Examples)

Zero-Downtime Database Migrations: The Expand-and-Contract Pattern (With PostgreSQL Examples)

1
Comments 1
4 min read
Before You Write Your Next Laravel Migration, Design Your Database

Before You Write Your Next Laravel Migration, Design Your Database

Comments
2 min read
Transactions & Basic Indexing in PostgreSQL: COMMIT, ROLLBACK, EXPLAIN & SQLAlchemy ⚛️

Transactions & Basic Indexing in PostgreSQL: COMMIT, ROLLBACK, EXPLAIN & SQLAlchemy ⚛️

Comments
16 min read
Exchange Rates API Data in a Database: Schema, Indexes and As-Of Queries

Exchange Rates API Data in a Database: Schema, Indexes and As-Of Queries

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