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.
Why I Replaced ActiveJDBC With My Own ORM

Why I Replaced ActiveJDBC With My Own ORM

1
Comments
3 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
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
Why Data Teams Need Data Lineage: From Common Pain Points to Real-World Challenges

Why Data Teams Need Data Lineage: From Common Pain Points to Real-World Challenges

1
Comments
4 min read
I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

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