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.
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

4
Comments 2
3 min read
I Build libSQL Server Web GUI - MylibSQLAdmin

I Build libSQL Server Web GUI - MylibSQLAdmin

7
Comments 4
2 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
N+1 Query Problem

N+1 Query Problem

8
Comments
1 min read
📰 NewsHub: AI News Platform

📰 NewsHub: AI News Platform

5
Comments
3 min read
What is SQL and Why Does It Matter

What is SQL and Why Does It Matter

Comments
2 min read
Firebase Data Connect: forget about boring repetitive tasks

Firebase Data Connect: forget about boring repetitive tasks

3
Comments
2 min read
Firebase Data Connect: forget about boring repetitive tasks

Firebase Data Connect: forget about boring repetitive tasks

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

10
Comments 3
2 min read
Data Comparison between Different Types of Databases-SPL Practice

Data Comparison between Different Types of Databases-SPL Practice

6
Comments
5 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
🏗️ 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
One million $lookup challenge (performance comparison)

One million $lookup challenge (performance comparison)

6
Comments
6 min read
A Unified, Type-Safe Database Adapter System for Multi-DB Applications

A Unified, Type-Safe Database Adapter System for Multi-DB Applications

3
Comments
5 min read
I Built a Free CSV Toolkit That Runs Everything in Your Browser (No Signups)

I Built a Free CSV Toolkit That Runs Everything in Your Browser (No Signups)

5
Comments
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
5 Things I Learned Building a Database File Format from Scratch

5 Things I Learned Building a Database File Format from Scratch

Comments
5 min read
Best Oracle Database Design Tools in 2025

Best Oracle Database Design Tools in 2025

13
Comments 8
7 min read
loading...