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.
10 Bad Practices to Avoid When Writing SQL Queries for Better Performance

10 Bad Practices to Avoid When Writing SQL Queries for Better Performance

Comments
4 min read
Optimizing Your MySQL Queries for Maximum Efficiency

Optimizing Your MySQL Queries for Maximum Efficiency

Comments
3 min read
Detecting and Analyzing Comment Quality Using Vector Search

Detecting and Analyzing Comment Quality Using Vector Search

22
Comments
6 min read
MySQL Memory Usage: A Guide to Optimization

MySQL Memory Usage: A Guide to Optimization

1
Comments
4 min read
How to detect query which holds the lock in Postgres?

How to detect query which holds the lock in Postgres?

Comments
1 min read
Find high dead_tuples

Find high dead_tuples

Comments
1 min read
AWS Database Services: Find the Best Fit for Your Application

AWS Database Services: Find the Best Fit for Your Application

Comments
3 min read
Check Table size in Postgresql Database

Check Table size in Postgresql Database

Comments
1 min read
Failover in Amazon RDS Multi-AZ Architectures

Failover in Amazon RDS Multi-AZ Architectures

5
Comments
7 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

1
Comments
5 min read
How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step Guide.

How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step Guide.

21
Comments
5 min read
Bases de Datos Serverless: Por qué Turso Está Cambiando el Juego

Bases de Datos Serverless: Por qué Turso Está Cambiando el Juego

3
Comments
2 min read
Understanding MongoDB: Why It’s a NoSQL Powerhouse

Understanding MongoDB: Why It’s a NoSQL Powerhouse

1
Comments
3 min read
Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Comments
3 min read
Essential OOP/Database/Data Structures Interview Questions for Developers

Essential OOP/Database/Data Structures Interview Questions for Developers

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