Inside pg_duckdb: From PostgreSQL Heap Rows to DuckDB Vectors
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
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
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
In our previous articles, we explored why Apache Kafka exists and how its architecture is structured. In this third part,…
Apache Kafka architecture
Apache Kafka Architecture: Built for Scale and Resilience
In Part 1 of this series, we explained why organisations adopt Apache Kafka and why traditional integration methods fail under…
Apache Kafka: The Backbone of Modern Data Architecture
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
Graph databases have evolved from niche technologies into essential components of modern data platforms. While Neo4j remains the most recognisable…
Graph databases
Graph Databases: When relationships matter more than rows
Traditional databases are excellent for storing structured data — but not always for understanding how that data connects.When the most…
Postgres18
PostgreSQL 18 released: Key features & upgrade tips
Today, on 25 September 2025, PostgreSQL 18 has been officially released. After months of betas and release candidate testing, the…
DuckDB for data professionals: Fast SQL without overhead
If you've ever waited for a huge CSV file to load into an overloaded BI tool just to run a…