by Angela Guess

A new press release reports, “Crate.io today announced general availability of CrateDB 1.0, an open source SQL database that enables real-time analytics for machine data applications. CrateDB makes machine data applications that were previously only possible using NoSQL solutions available to mainstream SQL developers. The company also announced today that it has opened a new world headquarters in San Francisco, adding to its existing presence in Berlin, Germany and Dornbirn, Austria. ‘The growth of machine data and the opportunities that businesses have to capitalize on it are outstripping the ability of their data management infrastructure to act on it,’ said Jason Stamper, Analyst, Data Platforms and Analytics at 451 Research. ‘CrateDB’s power lies in its ability to enable users to collect and analyze vast amounts of data in real-time, using SQL commands they already know’.”

The release goes on, “Downloaded more than one million times since its introduction in 2014, CrateDB combines the familiarity of SQL with the versatility of search and the ease of scalability of containers. It provides an alternative to existing analytic datastores including Splunk. CrateDB’s unique capabilities are enabled by the following innovations: Distributed SQL query engine for faster JOINs, aggregations, and ad-hoc queries — Columnar field caches and a fully distributed query planner enable CrateDB to perform complex queries in real time and overcome many of the performance and flexibility limitations of first-generation distributed SQL databases. SQL with integrated search for data and query versatility — CrateDB is a unique combination of SQL and search technology, which enables a wide range of analytics, including machine learning and predictive analytics, on time series, full text, JSON, geospatial, and other structured and unstructured data without having to use different database engines to do so.”

Read more at Business Wire.

Photo credit: CrateDB