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.
Entendendo a Replicação de Banco de Dados: Uma Chave para Sistemas Robustos

Entendendo a Replicação de Banco de Dados: Uma Chave para Sistemas Robustos

Comments
3 min read
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

1
Comments
12 min read
Adicionando um certificado cliente em uma wallet Oracle

Adicionando um certificado cliente em uma wallet Oracle

Comments
3 min read
I built an Event-Sourcing Database Engine, because I love Event-Driven Architectures: Meet GenesisDB

I built an Event-Sourcing Database Engine, because I love Event-Driven Architectures: Meet GenesisDB

Comments
2 min read
ORMs: The Good, The Bad, and The Ugly Performance

ORMs: The Good, The Bad, and The Ugly Performance

1
Comments
9 min read
How to Bring SQL Database Online From Recovery Pending State

How to Bring SQL Database Online From Recovery Pending State

1
Comments 1
6 min read
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

2
Comments
5 min read
The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

Comments
6 min read
How to Design a Relational Database Schema in 2025

How to Design a Relational Database Schema in 2025

17
Comments 1
8 min read
DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

Comments
3 min read
The Seven Types of Locks in InnoDB

The Seven Types of Locks in InnoDB

Comments
5 min read
Automating PostgreSQL Backups with a Shell Script

Automating PostgreSQL Backups with a Shell Script

3
Comments
3 min read
Segmented Accumulation by Condition — From SQL to SPL #30

Segmented Accumulation by Condition — From SQL to SPL #30

6
Comments 1
1 min read
Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

5
Comments
7 min read
Best Practices for Syncing Hive Data to Apache Doris — From Scenario Matching to Performance Tuning

Best Practices for Syncing Hive Data to Apache Doris — From Scenario Matching to Performance Tuning

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