Crate

Crate is a database coded in Java that uses the classic SQL syntax to index and store information in one machine or using server clusters.

Data can be easily queried and made available in real-time, allowing developers to easily scale up their applications without losing performance.

Unlike many similar database solutions that make it hard for non-technical users to work with them, Crate comes with a beautiful and easy to use administration panel by default, alongside the classic DB terminal.

This simplifies the process of managing the data and expanding the storage system, without having to hire a company or database specialized professionals.

As for performance, Crate delivers very fast results, will keep up with you when you scale your applications, important factors that played a big part in winning TechCrunch's 2014 Disrupt London Startup Battlefield competition.

If you want to learn more about Crate, you can also watch this short video presentation:

What is new in this release:

• Added plugin support
• Fixed performing queries on a partitioned table could cause unnecessary ``execution rejected`` errors
• Removed the limitation that the WHERE clause couldn't contain certain expressions in `select count(*)` queries.
• Expose REST URL of node in ``sys.nodes`` table
• Increased speed and reduced amount of used memory on sorted queries
• Ordering by `_score` must be defined explictly now even when using a `match` predicate.

What is new in version 0.53.0:

• Added plugin support
• Fixed performing queries on a partitioned table could cause unnecessary ``execution rejected`` errors
• Removed the limitation that the WHERE clause couldn't contain certain expressions in `select count(*)` queries.
• Expose REST URL of node in ``sys.nodes`` table
• Increased speed and reduced amount of used memory on sorted queries
• Ordering by `_score` must be defined explictly now even when using a `match` predicate.

What is new in version 0.49.1:

• Added plugin support
• Fixed performing queries on a partitioned table could cause unnecessary ``execution rejected`` errors
• Removed the limitation that the WHERE clause couldn't contain certain expressions in `select count(*)` queries.
• Expose REST URL of node in ``sys.nodes`` table
• Increased speed and reduced amount of used memory on sorted queries
• Ordering by `_score` must be defined explictly now even when using a `match` predicate.

What is new in version 0.49.0:

• Added plugin support
• Fixed performing queries on a partitioned table could cause unnecessary ``execution rejected`` errors
• Removed the limitation that the WHERE clause couldn't contain certain expressions in `select count(*)` queries.
• Expose REST URL of node in ``sys.nodes`` table
• Increased speed and reduced amount of used memory on sorted queries
• Ordering by `_score` must be defined explictly now even when using a `match` predicate.

What is new in version 0.47.4:

• Added support for array comparisons using the equals ``=`` operator.
• Support `INSERT ... ON DUPLICATE KEY UPDATE` statement.
• Added case-insensitive regex operator ~*.
• Support PCRE compatible regular expressions.

What is new in version 0.46.3:

• SELECT statements that involved tables from the information_schema schema or from the sys schema could fail if they contained columns in the ORDER BY clause but didn't contain these columns in the result column list.
• Fixed return zero row count instead of an exception if update by id
• doesn't match any document.
• Fixed an issue in the ``sys.shards`` table which caused an exception when the select limit was lower then the number of matching shards on a node.
• Fixed type conversion of bulk parameters.
• Updated crate-admin to version 0.11.2.

What is new in version 0.45.5:

• Updated crate-admin to version 0.10.2.
• Fixed:
• Correctly handle empty values and values containing commas for clustered by columns in the where clause. e.g: ``where _id=''``
• Forbid using ``alter table add column`` on a single partition.
• Do not consider rootfs in ``sys.nodes.fs['data']['dev']``