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.
Top 5 Ways to Combine pg_dump with Cloud Storage

Top 5 Ways to Combine pg_dump with Cloud Storage

Comments
5 min read
Data Granularity: The Hidden Factor Behind AI Testing Quality

Data Granularity: The Hidden Factor Behind AI Testing Quality

Comments
8 min read
Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

2
Comments 1
5 min read
Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Comments
10 min read
Understanding Database Indexes: How They Work and When They Hurt Performance

Understanding Database Indexes: How They Work and When They Hurt Performance

Comments
6 min read
5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

1
Comments
4 min read
Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Comments
4 min read
A Critical Analysis of Kysera: Why This Project Exists

A Critical Analysis of Kysera: Why This Project Exists

Comments
7 min read
How I Built a "Story-to-Data" Engine in Python (Because Faker Wasn't Enough)

How I Built a "Story-to-Data" Engine in Python (Because Faker Wasn't Enough)

1
Comments
3 min read
Databases Made Easy: Understanding How Data Powers Modern Software

Databases Made Easy: Understanding How Data Powers Modern Software

Comments 1
2 min read
Supporting 3 Databases with One Codebase: The Adapter Pattern

Supporting 3 Databases with One Codebase: The Adapter Pattern

6
Comments
7 min read
1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
Why Bf-Tree Pins Inner Nodes and What That Unlocks

Why Bf-Tree Pins Inner Nodes and What That Unlocks

10
Comments
4 min read
1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
FAR SYNC Data Guard

FAR SYNC Data Guard

Comments
3 min read
Yellowbrick Data - Community Edition Blog

Yellowbrick Data - Community Edition Blog

Comments
5 min read
584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
DuckDB: how to fine tune parameters?

DuckDB: how to fine tune parameters?

Comments
2 min read
✅ *Power BI DAX Basics

✅ *Power BI DAX Basics

Comments
1 min read
How I Reduced a 53-Minute MySQL Job to 15 Minutes on MySQL 5.7 (Without Changing Hardware)

How I Reduced a 53-Minute MySQL Job to 15 Minutes on MySQL 5.7 (Without Changing Hardware)

Comments
1 min read
What I Learned While Architecting a Car Classified Marketplace: Real Engineering Problems & How I Solved Them

What I Learned While Architecting a Car Classified Marketplace: Real Engineering Problems & How I Solved Them

Comments
4 min read
The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

Comments
5 min read
Why Did You Choose That Database For Your Application?

Why Did You Choose That Database For Your Application?

Comments
4 min read
loading...