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.
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
Why I Built DDL to Data

Why I Built DDL to Data

Comments
4 min read
MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

Comments
9 min read
CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

1
Comments
10 min read
Stop Manually Tracing Azure Synapse Dependencies

Stop Manually Tracing Azure Synapse Dependencies

Comments
1 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

31
Comments
3 min read
I Built a Scalable Financial Transaction System That Stays Correct Under Load

I Built a Scalable Financial Transaction System That Stays Correct Under Load

1
Comments
4 min read
AWS Databases!

AWS Databases!

Comments
2 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

5
Comments 1
4 min read
🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

1
Comments
2 min read
Part 5: Building a ZIP Code Dimension Table

Part 5: Building a ZIP Code Dimension Table

Comments
2 min read
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

14
Comments
3 min read
AI News Roundup: AliSQL Vector MySQL, Notepad++ Supply Chain, and Europe’s Digital Autonomy

AI News Roundup: AliSQL Vector MySQL, Notepad++ Supply Chain, and Europe’s Digital Autonomy

2
Comments
2 min read
Oracle 26NG SDE Interview Experience Offer After Five VO Rounds – Full Process Breakdown

Oracle 26NG SDE Interview Experience Offer After Five VO Rounds – Full Process Breakdown

Comments 1
4 min read
🗂️ Designing a Scalable Category System for an E-Commerce App

🗂️ Designing a Scalable Category System for an E-Commerce App

4
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.