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.
What's the solution to CAP theorem in Read Replicas?

What's the solution to CAP theorem in Read Replicas?

2
Comments
3 min read
Why You Should Use a Database In Your Projects!

Why You Should Use a Database In Your Projects!

Comments
3 min read
Lazy vs. Eager Loading & JPA Relationships

Lazy vs. Eager Loading & JPA Relationships

7
Comments
1 min read
Making DB Changes Predictable with Transactions

Making DB Changes Predictable with Transactions

15
Comments 1
4 min read
10x Query Performance Improvement: The Design and Implementation of the New Unique Key

10x Query Performance Improvement: The Design and Implementation of the New Unique Key

Comments
30 min read
When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

5
Comments 4
8 min read
No Foreign Keys in MongoDB: Rethinking Referential Integrity

No Foreign Keys in MongoDB: Rethinking Referential Integrity

Comments
8 min read
Secure Agent Database Access: Architecture Patterns That Actually Work

Secure Agent Database Access: Architecture Patterns That Actually Work

Comments
15 min read
How is Column Store fetch faster than Row Store?

How is Column Store fetch faster than Row Store?

Comments
2 min read
Location-Based Search at Scale: MongoDB Geospatial Queries for Marketplace Apps

Location-Based Search at Scale: MongoDB Geospatial Queries for Marketplace Apps

Comments
7 min read
Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Comments
3 min read
Indexes and the Rise of the DBMS

Indexes and the Rise of the DBMS

15
Comments
4 min read
VectorDatabase Showdown 2025: Pinecone vs Qdrant vs Weaviate con Benchmarks Reales

VectorDatabase Showdown 2025: Pinecone vs Qdrant vs Weaviate con Benchmarks Reales

Comments
3 min read
The Role of Excel in Business Intelligence(BI) and Data Driven Decision-Making

The Role of Excel in Business Intelligence(BI) and Data Driven Decision-Making

Comments
3 min read
LimeDB: Architectural Shift to Go with Consistent Hashing

LimeDB: Architectural Shift to Go with Consistent Hashing

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