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 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
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
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
How Timescale Solves Real-Time Analytics in Postgres

How Timescale Solves Real-Time Analytics in Postgres

Comments
5 min read
How I Replaced Python with C in My Project

How I Replaced Python with C in My Project

2
Comments 2
4 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
A developer's reference to Postgres change data capture (CDC)

A developer's reference to Postgres change data capture (CDC)

Comments
12 min read
I've operated petabyte-scale ClickHouse® clusters for 5 years

I've operated petabyte-scale ClickHouse® clusters for 5 years

Comments
14 min read
Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

Comments
8 min read
Get Total Count of Tables per Database in MySQL

Get Total Count of Tables per Database in MySQL

Comments
1 min read
Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more

Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more

Comments
5 min read
Understanding Complex Database Concepts: An In-Depth Guide

Understanding Complex Database Concepts: An In-Depth Guide

Comments
25 min read
How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

6
Comments 1
3 min read
loading...