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.
Ujorm3: A New Lightweight ORM for JavaBeans and Records

Ujorm3: A New Lightweight ORM for JavaBeans and Records

Comments 1
5 min read
Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

22
Comments 4
5 min read
SQL Query Optimization Guide

SQL Query Optimization Guide

Comments
5 min read
ACID Properties in Database Systems: The Foundation of Reliable Data Management

ACID Properties in Database Systems: The Foundation of Reliable Data Management

2
Comments
4 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Comments
6 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
Number Guessing Game

Number Guessing Game

1
Comments 1
2 min read
Two ClickHouse Internals That Change How You Write Queries

Two ClickHouse Internals That Change How You Write Queries

2
Comments
4 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

1
Comments
12 min read
I Built a Free Open Source Tool That Saved Me From Deleting My Production Database (Again)

I Built a Free Open Source Tool That Saved Me From Deleting My Production Database (Again)

1
Comments
5 min read
Introducing MoltenDB: A Local-First, Pure Rust Database for the Browser and Server

Introducing MoltenDB: A Local-First, Pure Rust Database for the Browser and Server

1
Comments 1
3 min read
Data governance just became a conversation, not a workflow.

Data governance just became a conversation, not a workflow.

20
Comments
1 min read
Redis Beyond Caching: 7 Powerful Patterns You Should Know

Redis Beyond Caching: 7 Powerful Patterns You Should Know

1
Comments
3 min read
Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

Comments
4 min read
A post-mortem on the fastest database breach of 2026 - and the quality gate that would have stopped it cold.

A post-mortem on the fastest database breach of 2026 - and the quality gate that would have stopped it cold.

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