We are excited to announce the availability of the testing release of CrateDB 2.0 and CrateDB Enterprise Edition. Here’s an explanation of what’s new, and how the CrateDB open source and CrateDB Enterprise editions will evolve over time.

2.0 Release Notes

Firstly, here’s what’s new for everyone in CrateDB 2.0, which contains many important enhancements, including:

SQL improvements - We expanded CrateDB support for SQL with the following: Aggregations on Joins Group-by on Joins Sub-select improvements including support for grouping in sub selects

We expanded CrateDB support for SQL with the following: Major upgrade to the CrateDB clustering layer - Changes to CrateDB’s internal workings, such as query pipelining (described here by Jordi Fußenegger), numeric indexing, and networking have improved performance and resiliency. The performance impact of the clustering improvements will be most noticeable on queries that include: Aggregations Joins Geospatial data processing Ranged searches Operations on IP data type

Changes to CrateDB’s internal workings, such as query pipelining (described here by Jordi Fußenegger), numeric indexing, and networking have improved performance and resiliency. The performance impact of the clustering improvements will be most noticeable on queries that include: New database administration features - Renaming tables is now supported, which makes database administration simpler.

Download CrateDB

CrateDB 2.0 Enterprise Edition

For mission-critical, customer-facing applications, we now offer the CrateDB Enterprise Edition. The Enterprise Edition contains premium features that enhance ease of use and CrateDB application performance. Before we get into what’s in the Enterprise version, let us explain our product packaging philosophy.

What happens in core stays in core

CrateDB open core version is a full-on distributed SQL database that you can use freely under the Apache 2.0 license. It’ll stay that way too...you can cluster the schnitzel out of it today (we’ve scaled it up to 1001 nodes for fun), and even back it up and restore it. Features in open core today and in the future, will remain in the open core edition.

"Enterprise First"

The CrateDB 2.0 binary combines Enterprise and non-Enterprise (open core) features and code together. The Enterprise features are enabled by default for you to try. They do not time out after 30 days, but before you deploy CrateDB into production use, you must either request a license from Crate.io, or disable the Enterprise Edition features.

Enterprise - free for personal use & do-gooders

CrateDB Enterprise Edition can be used for free for personal use or by people in non-profit (.org) and educational (.edu) institutions, as long as projects are not funded by sponsors. If this applies to you, request a license here.

Now, here are the premium features in CrateDB 2.0 Enterprise Edition:

Cluster Performance Monitoring A new JMX monitoring plugin enables CrateDB clusters to be monitored by popular 3rd-party tools like Grafana. You can see cluster performance and resource utilization in real time. CrateDB cluster performance is also visualized in the CrateDB AdminUI:



Host-based Authentication - Historically, CrateDB access is controlled externally, via firewall rules. CrateDB Enterprise can be configured to limit access from specific clients and access protocol combinations. In the future, certificate authentication and encryption will be added to CrateDB.

- Historically, CrateDB access is controlled externally, via firewall rules. CrateDB Enterprise can be configured to limit access from specific clients and access protocol combinations. In the future, certificate authentication and encryption will be added to CrateDB. User-Defined Functions - UDFs enable CrateDB users to embed complex processing like machine learning within SQL queries. In Enterprise Edition 2.0, UDFs are programmed with Javascript; and support for the R language is coming soon.

You can keep track of upcoming new enterprise features here.

One more thing! We have a goat now.

If you like our new mascot (still unnamed, just "Goat"), then complete a CrateDB feedback survey to request some stickers and a CrateDB shirt.

Why a mountain goat? Because they scale.

Ba-dum-tish!

If you have a name to suggest for Goat, let us know.

Have fun with CrateDB 2.0!