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.
I Built a Lightweight Embedded Database for Node.js — LioranDB

I Built a Lightweight Embedded Database for Node.js — LioranDB

2
Comments 2
1 min read
6 Essential SQL Concepts Every Beginner Should Master

6 Essential SQL Concepts Every Beginner Should Master

1
Comments
2 min read
Giving AI Agents Database Access Is Way Harder Than It Looks

Giving AI Agents Database Access Is Way Harder Than It Looks

1
Comments
4 min read
MCP DB Query: 让你的AI助手直接查询MySQL、PostgreSQL、SQLite数据库

MCP DB Query: 让你的AI助手直接查询MySQL、PostgreSQL、SQLite数据库

Comments
1 min read
When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

1
Comments
19 min read
Databasus released physical and incremental backups with WAL streaming for PITR

Databasus released physical and incremental backups with WAL streaming for PITR

Comments
5 min read
Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)

Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)

Comments
2 min read
The Slow Query Hidden Inside Your PL/pgSQL Function

The Slow Query Hidden Inside Your PL/pgSQL Function

Comments
5 min read
Zero-Downtime-Cross-Region-Database-Migration-using-AWS-DMS

Zero-Downtime-Cross-Region-Database-Migration-using-AWS-DMS

Comments
3 min read
Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)

Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)

Comments
5 min read
Filtering Data Where It Matters: SQL vs Application Logic

Filtering Data Where It Matters: SQL vs Application Logic

1
Comments
2 min read
How to get near-perfect, deterministic accuracy from your AI agents

How to get near-perfect, deterministic accuracy from your AI agents

22
Comments 1
14 min read
Pagination Done Right: Cursor vs Offset and Why It Matters at Scale

Pagination Done Right: Cursor vs Offset and Why It Matters at Scale

Comments
1 min read
Database Transactions: ACID, Isolation Levels, and Deadlocks

Database Transactions: ACID, Isolation Levels, and Deadlocks

Comments
1 min read
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

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