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.
This page sends 51 queries. On my laptop that takes 2 ms.

This page sends 51 queries. On my laptop that takes 2 ms.

4
Comments
4 min read
SQL for absolute beginners: a map of CRUD

SQL for absolute beginners: a map of CRUD

3
Comments
7 min read
Resizing a managed Postgres database while writing to it

Resizing a managed Postgres database while writing to it

8
Comments
5 min read
MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

Comments 2
12 min read
Maintaining the Turso PHP Ecosystem in My Spare Time: What Happened on November 9, 2026

Maintaining the Turso PHP Ecosystem in My Spare Time: What Happened on November 9, 2026

Comments
7 min read
Changing a Live Database Without Breaking the Application: A Safer Way to Run PHP Schema Migrations

Changing a Live Database Without Breaking the Application: A Safer Way to Run PHP Schema Migrations

Comments
7 min read
One number, four answers: reconciling four divergent hit-rate pipelines over 46,139 settled predictions

One number, four answers: reconciling four divergent hit-rate pipelines over 46,139 settled predictions

Comments
7 min read
CRM'de data retention'ı koda dökmek: Kural tablosu, güvenli saklama işi, legal hold ve kripto-parçalama

CRM'de data retention'ı koda dökmek: Kural tablosu, güvenli saklama işi, legal hold ve kripto-parçalama

Comments
10 min read
Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

Comments
5 min read
SQL Interview Question: MAX(created_at) Doesn’t Return the Latest Order

SQL Interview Question: MAX(created_at) Doesn’t Return the Latest Order

Comments
6 min read
Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

Comments
6 min read
DBDelve's Rust and GPUI Stack: What Building a Database Client Reveals About Agent Tool Interface Design

DBDelve's Rust and GPUI Stack: What Building a Database Client Reveals About Agent Tool Interface Design

1
Comments
7 min read
Article - Trading Journal with FastAPI, PostgreSQL, and Docker Compose

Article - Trading Journal with FastAPI, PostgreSQL, and Docker Compose

Comments
4 min read
How Databases Keep Your Data Safe When Everything Goes Wrong

How Databases Keep Your Data Safe When Everything Goes Wrong

Comments
15 min read
SQLite + SQLx: Why You Should Never Edit a Migration That Has Shipped

SQLite + SQLx: Why You Should Never Edit a Migration That Has Shipped

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