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.
Stop Installing MongoDB for This: SQLite Is Already a Document Database

Stop Installing MongoDB for This: SQLite Is Already a Document Database

Comments
6 min read
Built, not assembled

Built, not assembled

Comments
4 min read
API Pagination Patterns: Offset vs Cursor vs Keyset

API Pagination Patterns: Offset vs Cursor vs Keyset

Comments
3 min read
VentStream — open source CDC engine that syncs your database to search, cache, and AI agents in realtime

VentStream — open source CDC engine that syncs your database to search, cache, and AI agents in realtime

Comments 2
2 min read
When Database Read Replicas Introduce More Problems Than They Solve

When Database Read Replicas Introduce More Problems Than They Solve

1
Comments 1
5 min read
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
Fixed grids on vector search - comparing 3 approaches to quantization: FAISS, Turbovec, and Infino

Fixed grids on vector search - comparing 3 approaches to quantization: FAISS, Turbovec, and Infino

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