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.
Sparse & Dense Indexes in DBMS

Sparse & Dense Indexes in DBMS

Comments
3 min read
The Seven Types of Locks in InnoDB

The Seven Types of Locks in InnoDB

Comments
5 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
🌍 How STPX Global Is Fueling a World Revolution in AI and Growing Fast

🌍 How STPX Global Is Fueling a World Revolution in AI and Growing Fast

5
Comments
3 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
ETL vs. ELT: A Comprehensive Analysis of Modern Data Integration Strategies

ETL vs. ELT: A Comprehensive Analysis of Modern Data Integration Strategies

6
Comments 2
3 min read
SQL Subqueries: Power Up Your Data Retrieval

SQL Subqueries: Power Up Your Data Retrieval

Comments
7 min read
Welcome back to Part 3 of the Immo Finder App project! 👷‍♂️

Welcome back to Part 3 of the Immo Finder App project! 👷‍♂️

Comments
1 min read
What is SQL and Why Does It Matter

What is SQL and Why Does It Matter

Comments
2 min read
🚀 Supercharge Your App with Redis: Caching, Queues & Real-Time Power 🔥

🚀 Supercharge Your App with Redis: Caching, Queues & Real-Time Power 🔥

1
Comments
2 min read
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

9
Comments 2
2 min read
🏗️ Building data pipelines in 2025?

🏗️ Building data pipelines in 2025?

Comments
1 min read
Types of SQL statements

Types of SQL statements

Comments
1 min read
Why we built Springtail: Scaling out Postgres shouldn’t mean starting over

Why we built Springtail: Scaling out Postgres shouldn’t mean starting over

Comments
3 min read
MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

Comments 1
2 min read
Oracle PL/SQL - Basic Terms

Oracle PL/SQL - Basic Terms

Comments
1 min read
An Exclusive guide to MongoDB 2024

An Exclusive guide to MongoDB 2024

Comments
1 min read
I wish I knew this before mixing SQLAlchemy ORM with raw SQL: Python Database Access, Two Ways

I wish I knew this before mixing SQLAlchemy ORM with raw SQL: Python Database Access, Two Ways

Comments 1
2 min read
Using NoSQL Features in PostgreSQL

Using NoSQL Features in PostgreSQL

7
Comments
3 min read
Establish And Set Up Network Security Groups (NSGs).

Establish And Set Up Network Security Groups (NSGs).

Comments
4 min read
Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

1
Comments
5 min read
Best Oracle Database Design Tools in 2025

Best Oracle Database Design Tools in 2025

9
Comments 7
7 min read
Inside Databases: BSTs, B-Trees, & LSM Trees

Inside Databases: BSTs, B-Trees, & LSM Trees

1
Comments
7 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

12
Comments 3
2 min read
loading...