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.
How TimescaleDB Outperforms ClickHouse and MongoDB for LogTide's Observability Platform

How TimescaleDB Outperforms ClickHouse and MongoDB for LogTide's Observability Platform

Comments
9 min read
Optimizing Enterprise Knowledge Graphs for Scalable Digital Platforms

Optimizing Enterprise Knowledge Graphs for Scalable Digital Platforms

Comments
4 min read
The $15 Per Ride You Didn't Know About: What 243 Million NYC Taxi Rides Reveal

The $15 Per Ride You Didn't Know About: What 243 Million NYC Taxi Rides Reveal

3
Comments
11 min read
Why I Replaced ActiveJDBC With My Own ORM

Why I Replaced ActiveJDBC With My Own ORM

1
Comments
3 min read
TigerFS: A Filesystem Backed by PostgreSQL

TigerFS: A Filesystem Backed by PostgreSQL

26
Comments 4
5 min read
MySQL CDC: Real-Time Replication with Binlog (Complete Guide 2026)

MySQL CDC: Real-Time Replication with Binlog (Complete Guide 2026)

Comments 1
3 min read
37 Alembic Migrations, Zero Downtime: How We Moved a Live SaaS From Single-Tenant to Multi-Tenant

37 Alembic Migrations, Zero Downtime: How We Moved a Live SaaS From Single-Tenant to Multi-Tenant

Comments
6 min read
🔐 Running a Persistent Database SSH Tunnel as a Windows Service (SSH & Plink)

🔐 Running a Persistent Database SSH Tunnel as a Windows Service (SSH & Plink)

Comments
3 min read
PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

Comments
3 min read
PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

Comments
11 min read
SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro

SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro

Comments
5 min read
How Relational Fake Data Speeds Up Your Testing Workflow

How Relational Fake Data Speeds Up Your Testing Workflow

Comments
2 min read
SQL JOIN Tutorial: INNER, LEFT, RIGHT, FULL OUTER Explained

SQL JOIN Tutorial: INNER, LEFT, RIGHT, FULL OUTER Explained

Comments
6 min read
GopServer: Turn Any Database into a REST API in 3 Minutes

GopServer: Turn Any Database into a REST API in 3 Minutes

4
Comments
2 min read
Query Planning Overhead with Many Chunks (And How to Fix It)

Query Planning Overhead with Many Chunks (And How to Fix It)

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