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.
SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

Comments 1
17 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
SQL Aliases: How to Read a Query Out Loud

SQL Aliases: How to Read a Query Out Loud

Comments
13 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
Why Replit's AI Agent Deleted a Production Database

Why Replit's AI Agent Deleted a Production Database

Comments
4 min read
Your app doesn't know when another program changed your database

Your app doesn't know when another program changed your database

Comments 2
1 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
designing multi-tenant data isolation without over-engineering it

designing multi-tenant data isolation without over-engineering it

Comments
4 min read
Manticore Search authentication rollout checklist for production

Manticore Search authentication rollout checklist for production

Comments
12 min read
Postgres Full-Text Search in Production: How to Load-Test the Index and Pin Down Relevance

Postgres Full-Text Search in Production: How to Load-Test the Index and Pin Down Relevance

Comments 5
6 min read
dbt Semantic Layer vs Cube vs AtScale: Choosing an Enterprise Semantic Layer

dbt Semantic Layer vs Cube vs AtScale: Choosing an Enterprise Semantic Layer

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