Skip to content
Blog

Articles about Engineering (4)

Run Your First CrateDB Cluster on Kubernetes, Part One

Run Your First CrateDB Cluster on Kubernetes, Part One

Part one of a miniseries that walks you through the process of setting up your first CrateDB cluster on Kubernetes.

Read more

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Two

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Two

This is part two of a three-part miniseries that looks at how we improved join performance in the CrateDB 3.0 release.

Read more

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part One

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part One

We made faster joins by implementing a block hash algorithm and distributing its execution across the cluster. Find out more in this post.

Read more

Lab Notes: Adding Support for Joins on Virtual Tables and Multi-Row Subselects

Lab Notes: Adding Support for Joins on Virtual Tables and Multi-Row Subselects

We recently added support for multi-row subselects. Memory can cause bottlenecks, but fortunately, we found the solution.

Read more

What to Look at When You're Monitoring a Distributed Java Application

What to Look at When You're Monitoring a Distributed Java Application

In this post we will show you what to look at when you're monitoring a distributed java application.

Read more

Lab Notes: Extending Support for Scalar Subqueries

Lab Notes: Extending Support for Scalar Subqueries

In this post, I will introduce scalar subqueries, explain what challenges we faced extending this feature in CrateDB, and then show you how we addressed those challenges.

Read more

Lab Notes: Implementing Non-Collapsable Subselects

Lab Notes: Implementing Non-Collapsable Subselects

CrateDB now supports non-collapsable subselects. Let us introduce you to the problem, and show you the steps Crate.io took to solve it.

Read more

Analyzing Docker Container Performance With Native Tools

Analyzing Docker Container Performance With Native Tools

In this blog post, we will set up a small CrateDB cluster with Docker and go through some useful Docker commands that let us take a look at performance.

Read more

How We Use StackRox to Secure CrateDB Clusters on Docker

How We Use StackRox to Secure CrateDB Clusters on Docker

How we deployed StackRox to harden database security on our public-facing, Docker-based CrateDB cluster.

Read more

When is a SQL Subquery 260x Faster than a Left Join?

Learn why SQL subquery performance was 260x faster than a left join when querying 4.6 millions rows of ecommerce cross-sell data in a CrateDB database.

Read more