On May 16, Crate.io announced the availability of CrateDB 2.0, an open source SQL database that specializes in IoT and machine data. The innovation of CrateDB consists in leveraging SQL to aggregate and perform real-time analytics on IoT and machine data instead of the NoSQL databases commonly used in the industry for related use cases. CrateDB’s ability to accommodate the ingestion of high velocity streams of data and to perform queries on rapidly changing datasets, with impressive levels of scalability and latency, allows developers to combine their familiarity with SQL alongside a solution specially designed for the unique needs of IoT and machine data applications. CrateDB 2.0 features clustering upgrades that deliver improved query performance by means of faster aggregations and new index structures. In addition, CrateDB 2.0 contains a bevy of SQL enhancements that give developers a greater range of options regarding joins, sub-selects and the renaming and re-indexing of tables. The Enterprise Edition of CrateDB 2.0 offers performance monitoring, enhanced security as well as the ability for end users to create user-defined functions. CrateDB 2.0’s clustering upgrades, SQL enhancements and enterprise-grade security and performance monitoring mark a new milestone in the platform’s evolution that testifies to its readiness to embrace enterprise-grade workloads that include sensor data, GPS data and the industrial internet more generally. Subsequent to news of its general availability in December 2016, Crate.io’s release of open source and enterprise-grade versions of CrateDB underscores the early traction the platform has received, with over 1.3 million downloads and 50 customers using Crate.io in production. With the IoT and machine data space gearing up for a rampant proliferation of devices and corresponding datasets in forthcoming years, expect Crate.io to continue building on its recent momentum, particularly as organizations look for scalable databases that allow organizations to leverage widely available skillsets in SQL.
The graphic below illustrates the platform’s Enterprise Edition user interface for monitoring the performance of clusters gives users real-time visibility into cluster performance with respect to the ingestion and transformation of IoT and machine data: