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.
The Concept of Data Abstraction in Databases

The Concept of Data Abstraction in Databases

Comments
3 min read
I scaled my database just to destroy it

I scaled my database just to destroy it

Comments
3 min read
MongoDB Views or Materialized Views: When to Use?

MongoDB Views or Materialized Views: When to Use?

Comments
10 min read
How to count 100B events: Comparing architectures

How to count 100B events: Comparing architectures

Comments
7 min read
Help Build Doguino – A Dutch Online Dog Game

Help Build Doguino – A Dutch Online Dog Game

Comments
2 min read
EF Core seeding data

EF Core seeding data

1
Comments
3 min read
Database Normalization Summary

Database Normalization Summary

Comments
1 min read
Introducing AnuDB: A Lightweight, Serverless Document Database

Introducing AnuDB: A Lightweight, Serverless Document Database

Comments
2 min read
🧩 The Microservices Database Dilemma: Patterns, Challenges, and Best Practices

🧩 The Microservices Database Dilemma: Patterns, Challenges, and Best Practices

Comments
3 min read
🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

10
Comments 2
2 min read
Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Comments 2
27 min read
Optimizing ClickHouse for Financial Time Series

Optimizing ClickHouse for Financial Time Series

Comments
6 min read
I am Learning SQL(mysql) in 2025.

I am Learning SQL(mysql) in 2025.

4
Comments 2
1 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

6
Comments 1
2 min read
Rails 7.1: How Ruby on Rails Developers Can Use the .with Query Method for CTEs

Rails 7.1: How Ruby on Rails Developers Can Use the .with Query Method for CTEs

5
Comments
7 min read
Unlocking 10x Revenue Growth with Data Analytics in Gaming

Unlocking 10x Revenue Growth with Data Analytics in Gaming

Comments
16 min read
Why Denormalizing in ClickHouse will come back to bite you

Why Denormalizing in ClickHouse will come back to bite you

Comments
3 min read
Mismatch Between SSAS Tabular Model Measures and Data Warehouse Values in Power BI (Direct Query)

Mismatch Between SSAS Tabular Model Measures and Data Warehouse Values in Power BI (Direct Query)

Comments
1 min read
Kapper benchmarks - how does Kapper 1.3 compare to the competition?

Kapper benchmarks - how does Kapper 1.3 compare to the competition?

Comments
8 min read
How Timescale Solves Real-Time Analytics in Postgres

How Timescale Solves Real-Time Analytics in Postgres

Comments
5 min read
𝗨𝗻𝗹𝗼𝗰𝗸𝗶𝗻𝗴 𝘁𝗵𝗲 𝗣𝗼𝘄𝗲𝗿 𝗼𝗳 `𝗘𝗻𝘁𝗶𝘁𝘆𝗠𝗮𝗻𝗮𝗴𝗲𝗿.𝗰𝗹𝗲𝗮𝗿()` 𝗶𝗻 𝗦𝗽𝗿𝗶𝗻𝗴 𝗕𝗼𝗼𝘁: 𝗪𝗵𝗲𝗻 𝗮𝗻𝗱 𝗪𝗵𝘆 𝗦𝗵𝗼𝘂𝗹𝗱 𝗬𝗼𝘂 𝗨𝘀𝗲 𝗜𝘁?

𝗨𝗻𝗹𝗼𝗰𝗸𝗶𝗻𝗴 𝘁𝗵𝗲 𝗣𝗼𝘄𝗲𝗿 𝗼𝗳 `𝗘𝗻𝘁𝗶𝘁𝘆𝗠𝗮𝗻𝗮𝗴𝗲𝗿.𝗰𝗹𝗲𝗮𝗿()` 𝗶𝗻 𝗦𝗽𝗿𝗶𝗻𝗴 𝗕𝗼𝗼𝘁: 𝗪𝗵𝗲𝗻 𝗮𝗻𝗱 𝗪𝗵𝘆 𝗦𝗵𝗼𝘂𝗹𝗱 𝗬𝗼𝘂 𝗨𝘀𝗲 𝗜𝘁?

Comments
1 min read
Cracking MySQL Performance: What is Indexing and Why It Matters

Cracking MySQL Performance: What is Indexing and Why It Matters

5
Comments
2 min read
Spinning Up PostgreSQL with Docker Compose + Dashboard

Spinning Up PostgreSQL with Docker Compose + Dashboard

Comments
2 min read
How Debezium captures changes from Postgres

How Debezium captures changes from Postgres

Comments
5 min read
Choosing the right, real-time, Postgres CDC platform

Choosing the right, real-time, Postgres CDC platform

Comments
8 min read
loading...