Inside pg_duckdb: From PostgreSQL Heap Rows to DuckDB Vectors

Post author:Jan Suchánek
Post published:09/09/2026
Post category:Best Practices Database How to...PostgreSQL
Reading time:18 mins read

pg_duckdb embeds DuckDB's vectorised analytical engine inside a PostgreSQL backend. It can accelerate aggregation- and join-heavy queries without exporting PostgreSQL…

Kafka and Databases: CDC, Debezium and the Outbox Pattern

Post author:Jan Suchánek
Post published:28/08/2026
Post category:Apache Kafka Database
Reading time:27 mins read

Part 5 of the Apache Kafka series An order is committed in PostgreSQL. The application then tries to publish an…

Kafka Connect vs Kafka Streams vs ksqlDB: When to Use Each

Post author:Jan Suchánek
Post published:28/07/2026
Post category:Apache Kafka Best Practices
Reading time:25 mins read

Part 4 of the Apache Kafka Series In the previous three parts of this series, we covered why Apache Kafka…

Why Kafka is so fast

Why Kafka Is So Fast: The Architecture Behind Its Performance

Post author:Jan Suchánek
Post published:25/02/2026
Post category:Apache Kafka
Reading time:17 mins read

In our previous articles, we explored why Apache Kafka exists and how its architecture is structured. In this third part,…

Apache Kafka: The Backbone of Modern Data Architecture

Post author:Jan Suchánek
Post published:11/12/2025
Post category:Apache Kafka
Reading time:14 mins read

Modern digital systems generate unprecedented volumes of data. Users expect instant responses, and modern applications must react in real time.…

Working with graph data

Working with Graph Data in Neo4j, PostgreSQL, and Oracle

Post author:Jan Suchánek
Post published:28/10/2025
Post category:Uncategorised
Reading time:36 mins read

Graph databases have evolved from niche technologies into essential components of modern data platforms. While Neo4j remains the most recognisable…

Unlock SQL power: Essential guide to analytic functions

Post author:Jan Suchánek
Post published:15/07/2025
Post category:SQL
Reading time:21 mins read

A theoretical introduction Analytic functions (often referred to as window functions) are a cornerstone of modern SQL and data processing.…

Oracle Database 23ai

Oracle 23ai: The future is here – at least in the cloud

Post author:Jan Suchánek
Post published:15/04/2025
Post category:Database Overview
Reading time:10 mins read

Explore the top databases 2024, including Oracle, MySQL, SQL Server and PostgreSQL and understand their importance and unique features.

Staging tables 3

The role of staging tables in database administration (part 3)

Post author:Jan Suchánek
Post published:30/07/2024
Post category:Best Practices Database administration How to...
Reading time:8 mins read

Discover the efficiency of Oracle Database 23ai staging tables. They reduce UNDO and enhance performance in ETL processes, making them superior to traditional heap tables.

Installing and deploying Dremio on AWS

Comprehensive guide to installing and deploying Dremio on AWS

Post author:Jan Suchánek
Post published:05/03/2024
Post category:Dremio How to...
Reading time:13 mins read

Ensure a seamless installation of Dremio on AWS with our guide for optimal performance and analysis.