CrateDB is targeted specifically at IoT applications and ingesting and processing machine data, and it can be deployed both at the edge and more centrally.

CrateDB is a NewSQL database. That is, it is a distributed, lock-free, ANSI standard SQL database with a fully searchable document data store underpinning the database management system. It is open source, written in Java, and based on a shared nothing architecture. The product is effectively multi-model in that it supports JSON documents, relational data, geospatial, full text, binary large objects (BLOBs) and offers time-series capabilities. While not a native time-series database it supports this because you can partition the data by any function, and that includes time as a function.

Author/s: Philip Howard

Staying ahead of the technology curve

Our CIOs will give you the edge you need to compete in the digital economy