Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
The Tree Module: Where Pages Turn Into Rows in SQLite
Cover image for The Tree Module: Where Pages Turn Into Rows in SQLite

The Tree Module: Where Pages Turn Into Rows in SQLite

25
Comments
4 min read
MongoDB schema design — 6 patterns every developer should master
Cover image for MongoDB schema design — 6 patterns every developer should master

MongoDB schema design — 6 patterns every developer should master

Comments
9 min read
🚀 UUIDv4 vs UUIDv7 in PostgreSQL
Cover image for 🚀 UUIDv4 vs UUIDv7 in PostgreSQL

🚀 UUIDv4 vs UUIDv7 in PostgreSQL

4
Comments
3 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
Statement Subtransactions and Tree Mutation in SQLite
Cover image for Statement Subtransactions and Tree Mutation in SQLite

Statement Subtransactions and Tree Mutation in SQLite

13
Comments
4 min read
Why I Built DDL to Data
Cover image for Why I Built DDL to Data

Why I Built DDL to Data

Comments
4 min read
Step by Step Guide to Elasticsearch

Step by Step Guide to Elasticsearch

1
Comments
17 min read
MariaDB mysqldump guide — Using mysqldump for MariaDB database backups
Cover image for MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

Comments
9 min read
My Data Lake Runs on MongoDB and PostgreSQL and I’m Not Sorry
Cover image for My Data Lake Runs on MongoDB and PostgreSQL and I’m Not Sorry

My Data Lake Runs on MongoDB and PostgreSQL and I’m Not Sorry

3
Comments
10 min read
Stop Manually Tracing Azure Synapse Dependencies

Stop Manually Tracing Azure Synapse Dependencies

Comments
1 min read
AWS Databases!
Cover image for AWS Databases!

AWS Databases!

Comments
2 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today
Cover image for 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
The Tree Interface: Where Pages Become Structure in SQLite
Cover image for The Tree Interface: Where Pages Become Structure in SQLite

The Tree Interface: Where Pages Become Structure in SQLite

15
Comments
4 min read
Part 5: Building a ZIP Code Dimension Table
Cover image for Part 5: Building a ZIP Code Dimension Table

Part 5: Building a ZIP Code Dimension Table

Comments
2 min read
MariaDB vs MySQL — 8 reasons developers are switching in 2026
Cover image for MariaDB vs MySQL — 8 reasons developers are switching in 2026

MariaDB vs MySQL — 8 reasons developers are switching in 2026

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