Crate is a distributed SQL database. Simply install a Crate cluster directly on your favorite cloud provider and make the unwieldy centralized database a thing of the past.
No matter which cloud provider you use: Packet, Amazon Web Services, IBM Softlayer, or Microsoft Azure, Crate is the perfect fit for a highly scalable, distributed data store. Crate enables you to focus on developing your product and worry less about maintaining your database cluster.
Crate, a data store for data-intensive apps is persistent, horizontally scale-able and has been built to support these five requirements
Crate utilizes the indexing engine Lucene for storing documents.
Blob storage is done transparently, using the Crate blob implementation, which distributes and replicates blobs evenly across all nodes.
Crate uses Elasticsearch for fulltext search – that’s pretty much the best there is for speed.
Crate enables real time data analytics using SQL through the distributed query analyzer, planner and execution engine in real time.
Remember the good old days when restructuring an entire relational database was possible by using a single SQL script? Crate implements that functionality by borrowing the ability to put the result of a query directly into one or more indexes. This requirement becomes even more eminent on document based databases, where data is often stored in a highly denormalized format.