Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn
Cover image for 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
I built an Event-Sourcing Database Engine, because I love Event-Driven Architectures: Meet Genesis DB

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

Comments
2 min read
How to Achieve Website Accessibility Compliance in 2025

How to Achieve Website Accessibility Compliance in 2025

Comments
1 min read
How to Design a Relational Database Schema in 2025
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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! 👷‍♂️
Cover image for 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
Cover image for N+1 Query Problem

N+1 Query Problem

8
Comments
1 min read
📰 NewsHub: AI News Platform
Cover image for 📰 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
Cover image for 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
Cover image for Firebase Data Connect: forget about boring repetitive tasks

Firebase Data Connect: forget about boring repetitive tasks

1
Comments
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
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
Cover image for 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
🚀 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
loading...