Posts tagged "database"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

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

This is the second part of this series. You can read the first one here. Handling load This section is mostly about reads. I talked about ingestion in the previous post, and while reads and ...

16.04.2025 0 Read More

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data with WHERE The WHERE clause filters rows that meet specific conditions.Example: ⛶SELECT * FROM users WHERE Age > 25; Combining Filters with AND, OR, and NOT AND: ...

16.04.2025 0 Read More

🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

Sometimes in ClickHouse, you need to move or copy data between tables — especially when you're changing the table engine, for example from MergeTree to ReplicatedMergeTree.At first glance, it may se...

16.04.2025 0 Read More

Choosing the right, real-time, Postgres CDC platform

Change Data Capture (CDC) has become a critical component of modern data architectures. Teams use CDC to build event-driven workflows that react to database changes. Or to maintain state across servic...

16.04.2025 0 Read More

How Debezium captures changes from Postgres

Debezium is a popular solution for streaming changes from Postgres. It was amongst the first generation of tools purpose built to help developers implement a change data capture (CDC) pattern. While D...

16.04.2025 0 Read More

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

As a developer researching change data capture (CDC) on Postgres, what do you need to know?We’ve worked with hundreds of developers as they implement CDC specifically on Postgres. We’ve written ex...

16.04.2025 0 Read More

Mastering SQLite: Efficient Database Management Tips

SQLite is the unsung hero of lightweight databases. It’s embedded in everything from mobile apps and IoT devices to your favorite desktop tools—all thanks to its simplicity, portability, and zero-...

17.04.2025 0 Read More

How to test Umbraco against a real database

In my last post about Test Driven Development, I briefly touched on testing with a real database and how I used TestContainers to do it. Learning TDD by doing: Umb...

17.04.2025 0 Read More

Are SQL Joins Expensive?

If you’re building a web app or working with a database, you’ve probably used joins — they help you combine data from multiple tables. But you might wonder: "Are joins slow or expensive?"Let’s...

17.04.2025 0 Read More

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

Working with JPA and Spring Boot, we often focus on persisting and retrieving entities, but rarely stop to consider how our persistence context management can impact application performance and data c...

17.04.2025 0 Read More

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

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

Choosing the right, real-time, Postgres CDC platform

How Debezium captures changes from Postgres

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

Mastering SQLite: Efficient Database Management Tips

How to test Umbraco against a real database

Are SQL Joins Expensive?

#reading

#popular