CRATE: The Scalable SQL Database*

* with the NoSQL goodies

Crate allows to query and compute data with SQL in real time by providing a distributed aggregation engine, native search and super simple scalability.

https://crate.io

Features include

Familiar SQL syntax:

select * from users;
insert into users (name) values ('Arthur');

Semi-structured data:

create table demo (
    name string,
    obj object (dynamic) as (
        age int
    ),
    tags array (string)
);

insert into demo (name, obj, tags) values
    ('Trillian',
     {age = 39, gender='female'}, // Note that gender wasn't defined in the schema!
     ['mathematician', 'astrophysicist']);

select * from demo where obj['gender'] = 'female';

select * from demo where 'mathematician'= any (tags);

High availability, resiliency, and scalability in a distributed design:

create table t (string name)
clustered into 5 shards with (number_of_replicas = 1); // this is actually the default!

select count(*) from sys.nodes;
select table_name, count(*) from sys.shards group by 1;

Powerful Lucene based full-text search:

select title from wikipedia where match((title 1.5, text 1.0), 'Hitchhiker')

Getting Started

Get Crate

There are many ways to install Crate. The fastest way to try it out is just one command-line:

bash -c "$(curl -L try.crate.io)"

Or with docker:

docker pull crate && docker run -p 4200:4200 crate

Visit the download page to see all available download and install options.

Use Crate

Crate includes an Administration UI that is available under http://localhost:4200/admin/.

It also ships with a CLI called crash that can be used to run queries in a shell.

Next steps

Start some more server to form a cluster and take a look at the documentation to learn more.

Especially the crate introduction is a great place to start learning more.

Are you a Developer?

Clone the repository:

git clone https://github.com/crate/crate.git
cd crate
git submodule update --init

And build it with gradle:

./gradlew compileJava

Develop in IntelliJ:

./gradlew idea

Run tests:

./gradlew test

Refer to DEVELOP.rst and CONTRIBUTING.rst for further information.

Help & Contact

Do you have any questions? Or suggestions? We would be very happy to help you. So, feel free to to contact us via Gitter.

Or for further information and official contact please visit https://crate.io/.