CrateDB 4.0 is easier to work with time-series data via improvements to the options for specifying a frame for window functions; provides better clustering and node discovery by moving to Zen 2 to stay in sync with Elasticsearch; includes more PostgreSQL interoperability with synced data types names, synced timestamp formatting, the addition of the pg_catalog schema with its associated tables, and new functions that some tools require when connecting.
PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or web services with many concurrent users.
Currently available for download, CrateDB 4.0 also features improved ANSI SQL compliance through new support for the default clause in the CRATE TABLE statement, among other changes; stricter access controls with the introduction of a dedicated privilege type for administrative tasks; masking of sensitive information has also been added to further bolster security when handling Azure and AWS credentials with enhanced resiliency by exposing _seq_no and _primary_term, which can be used for optimistic concurrency control.
With key updates that address several components of the highly scalable open source database, 4.0 makes it easier, faster, and more cost-effective for IoT- and IIoT-fueled organizations to put their machine and sensor data to work.
CrateDB’s distributed SQL query engine features columnar field caches and a more modern query planner. These give CrateDB the ability to perform aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. CrateDB also integrates native, full-text search features, which enable users to store and query structured or unstructured data together; thus customers no longer have to use separate SQL and search databases to manage tabular and non-tabular data.
CrateDB is a distributed SQL database based on a NoSQL architecture that takes advantage of the convenience of SQL for processing any structured or unstructured data type. Dynamic schemas make it extremely easy to add new data types or indexes, and the architecture allows horizontal scaling by interconnecting servers to capture millions of IoT and IIoT data inputs per second (totaling hundreds of terabytes in cluster size). Distributed processing, data partitioning, and in-memory indexes return millisecond responses to time-series requests – even when many clients are working in the database simultaneously.
CrateDB has consistently proven valuable to organizations where vast amounts of sensor and machine data (in a variety of formats) need to be instantly and continually captured, stored, and analyzed. Deployed and trusted by large enterprises including Nokia, Gantner Instruments, Qualtrics, Comcast and ALPLA, CrateDB handles millions of data points per second with fast, linearly-scalable data ingestion.
“CrateDB 4.0 is an important release for our userbase,” said Johannes Moser, head of product at Crate.io. “Fast access to secure data – massive, massive volumes of data – is so crucial to IoT and IIoT applications, and we’re proud to continue to find new ways to improve our core database to meet customer requirements.”