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.
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
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.

29
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
Kubernetes Üzerinde Az Veri İçeren Veritabanı İçin PostgreSQL ve TimescaleDB Storage Kıyaslaması

Kubernetes Üzerinde Az Veri İçeren Veritabanı İçin PostgreSQL ve TimescaleDB Storage Kıyaslaması

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
Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

2
Comments
5 min read
Incremental Backup with PostgreSQL 17

Incremental Backup with PostgreSQL 17

4
Comments 1
7 min read
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

33
Comments 4
13 min read
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

5
Comments
3 min read
Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

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