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.
Four problems you inherit the moment your SQL client runs on a server

Four problems you inherit the moment your SQL client runs on a server

Comments
6 min read
SQLite doesn't enforce foreign keys by default, and it cost us three bugs

SQLite doesn't enforce foreign keys by default, and it cost us three bugs

Comments
4 min read
My AI Remembered Everything Important. It Forgot What I Did Last Night.

My AI Remembered Everything Important. It Forgot What I Did Last Night.

Comments 1
5 min read
Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out

Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out

Comments
4 min read
Let Claude Code and Cursor query your database (safely) — the MCP setup

Let Claude Code and Cursor query your database (safely) — the MCP setup

Comments
6 min read
Why Fast-Growing Products Develop Slow Databases

Why Fast-Growing Products Develop Slow Databases

Comments
7 min read
1,750 Pluses Later: The Query That Could Kill Every Connection at Once

1,750 Pluses Later: The Query That Could Kill Every Connection at Once

Comments
7 min read
Moving MultiXactOffset to 64 Bits in Postgres

Moving MultiXactOffset to 64 Bits in Postgres

Comments
7 min read
ACID vs BASE is a false dichotomy: Why your system needs both

ACID vs BASE is a false dichotomy: Why your system needs both

Comments
5 min read
The migration that shipped with the code and locked the table for eleven minutes

The migration that shipped with the code and locked the table for eleven minutes

Comments
2 min read
PATM: Handle SQL-based databases and provide useful tools and workflows, all in one app!

PATM: Handle SQL-based databases and provide useful tools and workflows, all in one app!

Comments
1 min read
Building a Role-Governed Student Association Portal with WSO2 Asgardeo, React, and Cloud Firestore

Building a Role-Governed Student Association Portal with WSO2 Asgardeo, React, and Cloud Firestore

Comments
4 min read
One Cell, Many Values: When a Column Holds a List

One Cell, Many Values: When a Column Holds a List

Comments
8 min read
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

Comments
2 min read
The Memory Engine Will Become the Enterprise's Next Database

The Memory Engine Will Become the Enterprise's Next Database

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