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.
MySQL Admin Scripts

MySQL Admin Scripts

1
Comments
4 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
I built Envoy - Control Plane for Painless PostgreSQL Schema Migrations

I built Envoy - Control Plane for Painless PostgreSQL Schema Migrations

1
Comments
3 min read
How Databricks Fits in the Modern Data Stack

How Databricks Fits in the Modern Data Stack

1
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
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
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

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