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.
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
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
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
Why schema drift goes undetected

Why schema drift goes undetected

Comments 2
7 min read
Knowledge Graphs Beyond Fraud: The Substrate Insurance AI Actually Needs

Knowledge Graphs Beyond Fraud: The Substrate Insurance AI Actually Needs

Comments
3 min read
Zero Errors Isn't a Benchmark Score. It's a Design Law.

Zero Errors Isn't a Benchmark Score. It's a Design Law.

Comments
3 min read
designing multi-tenant data isolation without over-engineering it

designing multi-tenant data isolation without over-engineering it

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