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

Comments
14 min read
drizzle-kit generate Duplicate ADD COLUMN: Stale Snapshot

drizzle-kit generate Duplicate ADD COLUMN: Stale Snapshot

Comments
3 min read
BAS/1C: Platform vs Configuration vs Information Base — A Diagnostic Protocol Before Automation

BAS/1C: Platform vs Configuration vs Information Base — A Diagnostic Protocol Before Automation

Comments
7 min read
Postgres to DuckDB with CDC: One ATTACH Instead of a Nightly Export

Postgres to DuckDB with CDC: One ATTACH Instead of a Nightly Export

Comments
14 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

Comments
4 min read
One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

Comments
3 min read
MongoDB vs PostgreSQL: how I choose between them

MongoDB vs PostgreSQL: how I choose between them

Comments
1 min read
Five Fields Every Stored Exchange Rate Needs (or Your Auditor Will Ask)

Five Fields Every Stored Exchange Rate Needs (or Your Auditor Will Ask)

Comments
2 min read
PocketBase for Beginners: A Whole Backend in One Small File

PocketBase for Beginners: A Whole Backend in One Small File

Comments
2 min read
Why Is COUNT(*) So Slow on Large Tables?

Why Is COUNT(*) So Slow on Large Tables?

Comments
4 min read
Django 6.1 Fetch Modes: The N+1 Fix With a Catch

Django 6.1 Fetch Modes: The N+1 Fix With a Catch

Comments
7 min read
How BM25 Ranks Search Results, and What k1 and b Actually Do

How BM25 Ranks Search Results, and What k1 and b Actually Do

Comments
3 min read
Before Upgrading to MySQL 9.7, Check Authentication Plugins and TLS Configuration

Before Upgrading to MySQL 9.7, Check Authentication Plugins and TLS Configuration

Comments
16 min read
Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Comments
9 min read
Modelado orientado a consultas en Apache Cassandra: series de tiempo con particiones, TTL y contadores en Astra DB

Modelado orientado a consultas en Apache Cassandra: series de tiempo con particiones, TTL y contadores en Astra DB

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