Elasticsearch is an exceptional technology for building scalable databases of unstructured data and performing full-text searches.
But wouldn’t it be great if:
CrateDB is an open source SQL database that includes a healthy dose of Elasticsearch DNA.
CrateDB 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 CrateDB enriches your experience: