Elasticsearch is an exceptional technology for building scalable databases of unstructured data and performing full-text searches.
But wouldn't it be great if:
Crate is an open source SQL database that includes a healthy dose of Elasticsearch DNA.
Crate uses a standard SQL interface and provides bindings for different languages, such as JDBC, SQL Alchemy, PHP, PDO and makes it very easy to use with the existing frameworks.
If you are an Elasticsearch user, here are some ways Crate enriches your experience: