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.
Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Comments
3 min read
Quick Recap: Elasticsearch & Lucene

Quick Recap: Elasticsearch & Lucene

Comments
2 min read
Oracle AI Database 26ai — Dictionary Protection

Oracle AI Database 26ai — Dictionary Protection

1
Comments
4 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.