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 Stopped Using Gemini 3.1 Pro for Agentic Coding — Why I Moved to Gemini 3.7 Flash High Mode

I Stopped Using Gemini 3.1 Pro for Agentic Coding — Why I Moved to Gemini 3.7 Flash High Mode

1
Comments
4 min read
Building a Real-Time Dashboard with FastAPI, WebSockets, and MySQL

Building a Real-Time Dashboard with FastAPI, WebSockets, and MySQL

1
Comments
3 min read
Powerful regression tests for your PostgreSQL project

Powerful regression tests for your PostgreSQL project

Comments
13 min read
Magento 2 MySQL Read/Write Replication Splitting: Scale Your Database Horizontally

Magento 2 MySQL Read/Write Replication Splitting: Scale Your Database Horizontally

1
Comments
7 min read
Representing Roguelite Build Effects Without Hard-Coding Every Combination

Representing Roguelite Build Effects Without Hard-Coding Every Combination

Comments
2 min read
Designing a Data-First Companion Wiki for DragonSword: Awakening

Designing a Data-First Companion Wiki for DragonSword: Awakening

Comments
2 min read
Install Manticore Search with one command

Install Manticore Search with one command

Comments
5 min read
Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)

Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)

Comments 1
2 min read
That VARCHAR(255) Was Never a Decision. It Was a Default.

That VARCHAR(255) Was Never a Decision. It Was a Default.

Comments 1
4 min read
Self-hosting ArangoDB: one database for graph, document, and vector search

Self-hosting ArangoDB: one database for graph, document, and vector search

Comments
2 min read
Solon Data SQL: Three Layers of Data Access Without the Bloat

Solon Data SQL: Three Layers of Data Access Without the Bloat

Comments 3
5 min read
What I Learned Partitioning a Billion-Row Table in Production

What I Learned Partitioning a Billion-Row Table in Production

2
Comments
6 min read
Why Replit's AI Agent Deleted a Production Database

Why Replit's AI Agent Deleted a Production Database

Comments
4 min read
Double-Entry Ledger Design for Software Engineers

Double-Entry Ledger Design for Software Engineers

Comments 1
2 min read
Building an LSM-Tree So I Could Kill It

Building an LSM-Tree So I Could Kill It

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