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.
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
SFMC Data Extension Performance: Query Optimization Under Load

SFMC Data Extension Performance: Query Optimization Under Load

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

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

Comments
3 min read
PostgreSQL Monitoring Tools Compared (2026)

PostgreSQL Monitoring Tools Compared (2026)

Comments
4 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
What Surprised Me About Migrating Our Monolithic SQL Database to MongoDB in Production

What Surprised Me About Migrating Our Monolithic SQL Database to MongoDB in Production

Comments
6 min read
Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Comments
2 min read
Understanding DDL and DML SQL concepts

Understanding DDL and DML SQL concepts

Comments
3 min read
Understanding SQL: DDL, DML, Filtering, and CASE WHEN

Understanding SQL: DDL, DML, Filtering, and CASE WHEN

Comments
3 min read
Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation

Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation

Comments
14 min read
How I Added Memory to an AI Agent Using Spring AI and Oracle AI Database

How I Added Memory to an AI Agent Using Spring AI and Oracle AI Database

Comments
10 min read
DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

Comments
3 min read
Build an Ultra-Lightweight, Local-First AI Assistant with Persistent Memory

Build an Ultra-Lightweight, Local-First AI Assistant with Persistent Memory

Comments
10 min read
How I Built a Runtime Adaptive Compression System That Selects the Best Algorithm Without Scanning All Data

How I Built a Runtime Adaptive Compression System That Selects the Best Algorithm Without Scanning All Data

Comments
4 min read
Rethinking Data Layer Design in Full-Stack Development

Rethinking Data Layer Design in Full-Stack Development

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