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

Stream Technologies Partners with Sagemcom on LoRa

By: Ken Briodagh    5/24/2017

Stream Technologies, an IoT connectivity management platform company, and Sagemcom, a developer of LoRa solutions, have together announced that Sagemc…

Read More

New Wireless UNB Transceiver Purports to Be World's First, Enables IoT Apps

By: Ken Briodagh    5/24/2017

In a recent announcement, Leti, a technology research institute of CEA Tech, has said it has developed the world's first wireless transceiver dedicate…

Read More

Orange Business Services Works with UK Startup Stonelin to Bring IoT Tracking to Market

By: Ken Briodagh    5/22/2017

Orange Business Services has agreed to support UK-based startup Stonelin Communications in the upcoming launch of a trio of tracking devices, which ar…

Read More

Telit Introduces Slim, Smart Antenna GNSS Location Module

By: Ken Briodagh    5/18/2017

New Telit module simplifies development process and delivers superior performance for wearables, personal trackers, and other battery-dependent applic…

Read More

Fon Highlights 7 Points to Define the Future of Wi-Fi

By: Ken Briodagh    5/17/2017

Fon, global leader in Wi-Fi implementation, has nailed the importance of Wi-Fi as an integrated and customer-centric technology through an in depth an…

Read More