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.
Crate.io and the EU General Data Protection Regulation
Crate.io takes data protection very seriously. We started work months ago to make sure we are compliant with the GDPR. Here's what we've been up to so far.
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.
Whitepaper: The Impact of IoT on the Packaging Industry
Have you ever had a Coke? There’s a good chance the bottle was made by ALPLA. The world leader in packaging solutions uses CrateDB to ingest sensor data from multiple factories and production lines into a central “mission control”.
5 Ways to Invest $5 Billion in IoT
$5 billion is a significant investment and could be used to develop many different areas of IoT. Here's where we see the greatest upside and need in large-scale IoT systems development.
The Rise of the Distributed SQL Database
The rise of distributed SQL databases has revolutionized application architecture, allowing scalability & flexibility without sacrificing the SQL power.
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.
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.
Lab Notes: Query Execution Pipeline Overhaul
Engineering blog post explaining the CrateDB query processing pipeline and recent modifications to improve it.