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 Started Building a Storage Engine in C++ ! It Became PacificDB, a Multi-Model Database

I Started Building a Storage Engine in C++ ! It Became PacificDB, a Multi-Model Database

Comments
3 min read
Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Why Is My SQL Server Slow? A 4-Step Diagnosis with Blocking, Wait Stats, Execution Plans and Missing Indexes

Comments
9 min read
I built db-studio, a free, open-source database studio you can run with npx

I built db-studio, a free, open-source database studio you can run with npx

Comments
2 min read
How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

Comments
2 min read
ORA-12514: The Database Is Up. The Listener Just Doesn't Know It.

ORA-12514: The Database Is Up. The Listener Just Doesn't Know It.

Comments
10 min read
The new machine with the old map: how GitHub routed writes to servers that no longer existed

The new machine with the old map: how GitHub routed writes to servers that no longer existed

Comments
6 min read
Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser

Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser

Comments
5 min read
How-to: the MariaDB settings that really matter, and how to check them

How-to: the MariaDB settings that really matter, and how to check them

Comments
8 min read
Optimizing Large-Scale MongoDB Aggregation Pipelines: A Deep Dive

Optimizing Large-Scale MongoDB Aggregation Pipelines: A Deep Dive

Comments
10 min read
Why Moving Only the Web Server to a Neighboring Region Is a Mistake — 5ms vs 37ms DB Round Trips

Why Moving Only the Web Server to a Neighboring Region Is a Mistake — 5ms vs 37ms DB Round Trips

Comments
3 min read
I Wrote a Wasteful JOIN on Purpose. It Ran Faster, Until It Didn't.

I Wrote a Wasteful JOIN on Purpose. It Ran Faster, Until It Didn't.

6
Comments
6 min read
Building My Own Knowledge Base: From PDF Ingestion to AI-Generated Memory Cards

Building My Own Knowledge Base: From PDF Ingestion to AI-Generated Memory Cards

Comments
14 min read
DuckDB 2.0's quack server lets ten writers share one file for under 2ms a query

DuckDB 2.0's quack server lets ten writers share one file for under 2ms a query

11
Comments 2
7 min read
Don't DROP COLUMN while old app code still reads it

Don't DROP COLUMN while old app code still reads it

1
Comments
3 min read
Shelf-Life Is Versioned Config, Expiry Is a Derived Field: Modelling Shelf-Life Studies, Lot Expiry and FEFO in a Food ERP

Shelf-Life Is Versioned Config, Expiry Is a Derived Field: Modelling Shelf-Life Studies, Lot Expiry and FEFO in a Food ERP

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.