Building Query Lambdas with CrateDB's Views and the HTTP Endpoint
Learn how to create reusable queries in CrateDB using views and the HTTP Endpoint. Simplify query management for former Rockset users transitioning to CrateDB.
Doing Hybrid Search in CrateDB
Learn how to enhance search relevancy with Hybrid Search in CrateDB, combining BM25 and Vector Search for better accuracy and results.
Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers
Learn about CrateDB 5.7's integration with PostgreSQL using Foreign Data Wrappers for seamless data access and advanced analytics.
CrateDB 5.4 Feature Focus: Session Timeouts
With the statement_timeout setting, you can define the maximum duration for any database statement, enhancing your control over query execution. Know more!
Cluster Cloning: The Ultimate Feature for Duplicating Your Cloud Cluster
Do you want a faster, more efficient way to test new versions, migrate data, or try new features in a safe environment? Check the Cluster Cloning feature!
Feature Focus: UNION ALL
The CrateDB 2.3.x release line isn't stable yet, but if you're interested in trying it out for testing purposes, head on over to the downloads page. In this post, I will take a closer look at some of the new features.
Bulk Inserts with unnest
CrateDB 0.55 introduces support for unnesting. Unnest uses arrays to generate a transient table with each array representing a column.
Improving on Joins
We've doubled the JOINs performance for almost all queries, and removed many of the previously existing restrictions.
CrateDB adds support for JOINs & Geo shapes at DockerCon 15
Today we've taken two huge steps forward in our journey by releasing support for table joins, and support for Geo Shapes in our newest testing release (0.53.0).
Using Crate As a BLOB Store
Crate provides BLOB storage so you can persistently store and retrieve BLOB – typically pictures, videos or large unstructured files, providing a fully distributed cluster solution for BLOB storage.