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.
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

Comments
2 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

6
Comments
5 min read
Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Comments
4 min read
Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Comments
4 min read
The Evolution of Data Architectures: From Lakes to Mesh and Beyond

The Evolution of Data Architectures: From Lakes to Mesh and Beyond

1
Comments
9 min read
Entenda Teorema CAP

Entenda Teorema CAP

1
Comments
5 min read
How we built our metadata layer on FoundationDB

How we built our metadata layer on FoundationDB

Comments
5 min read
Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Comments
5 min read
Smarter Databases with SQL Views and Triggers

Smarter Databases with SQL Views and Triggers

Comments
5 min read
Understanding Query Cost in SQL

Understanding Query Cost in SQL

2
Comments 1
7 min read
Understanding T-SQL vs PL/SQL Database Curveballs

Understanding T-SQL vs PL/SQL Database Curveballs

1
Comments
3 min read
How Joins work?

How Joins work?

Comments
2 min read
Best MySQL Database Design Tools in 2025

Best MySQL Database Design Tools in 2025

11
Comments 2
8 min read
The Scaling Gauntlet: The Art of Query Archaeology

The Scaling Gauntlet: The Art of Query Archaeology

Comments 1
5 min read
SQL And PHP: People whose birthday is today

SQL And PHP: People whose birthday is today

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