Menu

M2M FEATURE NEWS

Clustering, Security Enhance Crate.IO IoT Database

By Paula Bernier May 16, 2017

Crate.io, a company that specializes in databases for Internet of Things applications, today came out with CrateDB 2.0. The SQL database is also now available in an enterprise version.

Special databases are required to handle the fire hose of data that IoT creates and the fact that this data can be messy as opposed to tabular and neat, said Andy Ellicott, Crate.io’s chief marketing officer. CrateDB addresses all that, and enables organizations to query and analyze data in real time. Now, version 2.0 of CrateDB brings clustering upgrades for better performance and resiliency. “It just makes CrateDB faster,” Ellicott explained.

CrateDB 2.0 also lets users drill down into sensor readings based on such parameters as sensor type, time, geographic region, IP addresses, etc. “Those are pretty complex queries for any database…and clustering makes it even faster,” said Ellicott.

This new version of the database also features SQL improvements. That includes aggregations on Joins, sub selects, table renaming, and reindexing.

And the new Enterprise Edition of CrateDB 2.0 offers premium features including better security, which leverages authentication and authorization; better visibility on who’s doing what; and improved analytics. CrateDB is available via three annual subscription levels. That starts at $500 per month per cluster. And CrateIO offers discounts for startups. The company also now offers CrateDB as a managed service. CrateIO, which was founded in 2014, in December launched its open source, SQL database. Today CrateIO has more than 60 customers in production and more than 12 paying customers. 

Among the CrateDB users are a fleet tracking company called Clickdrive.io out of Singapore. Roomonitor is another CrateDB customer. The company, which is out of Barcelona, Spain, enables rental property owners and managers to monitor whether air conditioning is being wasted and whether there’s too much noise at their locations.




Edited by Ken Briodagh

Executive Editor, TMC

SHARE THIS ARTICLE
Related Articles

NetFoundry Announces Cloud Gateway Availability on DigitalOcean Marketplace

By: Arti Loftus    9/13/2019

NetFoundry has released its newly available application that allows solution providers to utilize a programmable and comprehensive approach for securi…

Read More

ON Semiconductor Offers New Power over Ethernet Solutions for IoT Endpoints

By: Ken Briodagh    9/13/2019

Compliance with IEEE 802.3bt delivers 90 Watts of power to applications including smart sensors, building automation and connected lighting

Read More

KYOCERA and Ube Join Forces on Ceramic Filters for 5G Base Stations

By: Ken Briodagh    9/10/2019

In a recent release, Kyocera and Ube Industries together announced that the two companies have signed a joint venture agreement to manufacture ceramic…

Read More

OmniVision Announces Image Sensor with Tiny BSI Global Shutter Pixel

By: Ken Briodagh    9/9/2019

BSI Global Shutter Sensor With Nyxel Technology Combines 2.2 micron Pixel With Near-Infrared Performance for Images in Consumer and Industrial Applica…

Read More

White Paper from WBA & NGMN Examines Intersection of Wi-Fi 6 & 5G

By: Ken Briodagh    9/9/2019

White Paper Assesses Current Implementations, Identifies Solutions to Address Gaps, Explores Validation for Use Cases

Read More