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.
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

Comments
3 min read
Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning

Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning

Comments
2 min read
Day 16: ClickHouse Dictionaries – Eliminating Expensive JOINs with High-Speed In-Memory Lookups

Day 16: ClickHouse Dictionaries – Eliminating Expensive JOINs with High-Speed In-Memory Lookups

1
Comments
4 min read
Metadata Filtering Before Vector Search: The Recall Win Nobody Measures

Metadata Filtering Before Vector Search: The Recall Win Nobody Measures

Comments
7 min read
Using SurrealDB Graph Queries to Power Video Recommendations

Using SurrealDB Graph Queries to Power Video Recommendations

Comments
8 min read
PostgreSQL 2200F Error: Causes and Solutions Complete Guide

PostgreSQL 2200F Error: Causes and Solutions Complete Guide

Comments
3 min read
10 API and Database Blunders Every Beginner Makes (and How to Fix Them Before Production Bites Back)

10 API and Database Blunders Every Beginner Makes (and How to Fix Them Before Production Bites Back)

Comments
10 min read
Late Nights and Fixes: Two Internship Tasks That Stuck

Late Nights and Fixes: Two Internship Tasks That Stuck

Comments
5 min read
37/60 Days System Design Interview Questions

37/60 Days System Design Interview Questions

1
Comments 5
1 min read
Struggling with Boyce-Codd Normal Form as a Junior Developer

Struggling with Boyce-Codd Normal Form as a Junior Developer

1
Comments 1
2 min read
Build an AI travel planner easily with Google Cloud's Multi Model Spanner

Build an AI travel planner easily with Google Cloud's Multi Model Spanner

Comments
7 min read
Day 15 of #100DaysOfClickHouse: Mastering the ClickHouse Client

Day 15 of #100DaysOfClickHouse: Mastering the ClickHouse Client

2
Comments
2 min read
MongoDB vs PostgreSQL: Which Database Should You Choose in 2026?

MongoDB vs PostgreSQL: Which Database Should You Choose in 2026?

Comments
4 min read
Sharding Hot Partitions in DynamoDB: Why Your Single-Partition Log Table Will Break at Scale

Sharding Hot Partitions in DynamoDB: Why Your Single-Partition Log Table Will Break at Scale

2
Comments
6 min read
ClickHouse® Projections and Skip Indexes - The Hidden Query Optimization Challenge

ClickHouse® Projections and Skip Indexes - The Hidden Query Optimization Challenge

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