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.
Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

5
Comments
3 min read
How to design an ER diagram?

How to design an ER diagram?

Comments
3 min read
How Slow Queries Lead to HikariCP Connection Timeouts

How Slow Queries Lead to HikariCP Connection Timeouts

Comments
4 min read
How to Document SQL Server Schemas Visually in 2025

How to Document SQL Server Schemas Visually in 2025

5
Comments
4 min read
Oracle 21c — Comparing Explain Plans Using the COMPARE_EXPLAIN Function

Oracle 21c — Comparing Explain Plans Using the COMPARE_EXPLAIN Function

Comments
2 min read
Oracle 23ai— The INMEMORY(ALL) and NO INMEMORY(ALL) Clauses

Oracle 23ai— The INMEMORY(ALL) and NO INMEMORY(ALL) Clauses

Comments
2 min read
Optimizing SQL Queries with Partitioning: The Secret Weapon for Managing Massive Databases

Optimizing SQL Queries with Partitioning: The Secret Weapon for Managing Massive Databases

Comments
6 min read
🔍 PostgreSQL Index Types Explained with Real-World Examples

🔍 PostgreSQL Index Types Explained with Real-World Examples

Comments
2 min read
Ten tips and tricks for your database schema

Ten tips and tricks for your database schema

11
Comments
6 min read
Features I Wish Postgres Had but MySQL Already Has

Features I Wish Postgres Had but MySQL Already Has

5
Comments
4 min read
𝗪𝗵𝘆 𝗘𝗻𝘁𝗲𝗿𝗽𝗿𝗶𝘀𝗲𝘀 𝗧𝗵𝗶𝗻𝗸 𝗧𝘄𝗶𝗰𝗲 𝗕𝗲𝗳𝗼𝗿𝗲 𝗔𝗱𝗼𝗽𝘁𝗶𝗻𝗴 𝗢𝗿𝗮𝗰𝗹𝗲 𝗚𝗼𝗹𝗱𝗲𝗻𝗚𝗮𝘁𝗲: 𝗧𝗼𝗽 𝗣𝗮𝗶𝗻 𝗣𝗼𝗶𝗻𝘁𝘀 𝗥𝗲𝘃𝗲𝗮𝗹𝗲𝗱

𝗪𝗵𝘆 𝗘𝗻𝘁𝗲𝗿𝗽𝗿𝗶𝘀𝗲𝘀 𝗧𝗵𝗶𝗻𝗸 𝗧𝘄𝗶𝗰𝗲 𝗕𝗲𝗳𝗼𝗿𝗲 𝗔𝗱𝗼𝗽𝘁𝗶𝗻𝗴 𝗢𝗿𝗮𝗰𝗹𝗲 𝗚𝗼𝗹𝗱𝗲𝗻𝗚𝗮𝘁𝗲: 𝗧𝗼𝗽 𝗣𝗮𝗶𝗻 𝗣𝗼𝗶𝗻𝘁𝘀 𝗥𝗲𝘃𝗲𝗮𝗹𝗲𝗱

Comments
2 min read
ACID in Databases: What It Really Means (with Real-Life Bank Scenarios in the USA & Germany)

ACID in Databases: What It Really Means (with Real-Life Bank Scenarios in the USA & Germany)

2
Comments
2 min read
MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

Comments
3 min read
Database locking revisited

Database locking revisited

Comments
21 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

1
Comments
1 min read
Learning SQL for 30-days. Day 4.

Learning SQL for 30-days. Day 4.

Comments
1 min read
No pre-filtering in pgvector means reduced ANN recall

No pre-filtering in pgvector means reduced ANN recall

Comments
12 min read
[Share] SQLite

[Share] SQLite

Comments
4 min read
How to Bring SQL Database Online From Recovery Pending State

How to Bring SQL Database Online From Recovery Pending State

1
Comments 1
6 min read
Airtable Data Limit Reached: 3 Common Solutions

Airtable Data Limit Reached: 3 Common Solutions

Comments
8 min read
Real-time AI Unleashed: The Power of Time-Series and Vector Database Synergy

Real-time AI Unleashed: The Power of Time-Series and Vector Database Synergy

Comments
3 min read
🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

5
Comments
3 min read
Supabase + Express + Drizzle ORM

Supabase + Express + Drizzle ORM

Comments
4 min read
The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

Comments
6 min read
Database Mastery: Hands-On Labs for Country GNP, Student Course Analysis & Stored Procedures

Database Mastery: Hands-On Labs for Country GNP, Student Course Analysis & Stored Procedures

Comments
2 min read
loading...