CrateDB

What do you like best?

CrateDB which is CrateIO's project makes machine data applications that previously were found only in NoSQL solutions available to developers who use SQL. It can handle large amount of messy data and acquire it in real-time. It also provides support for JSON and other structured and unstructured data.

What do you dislike?

They only support very basic SQL. For example, joins are not supported. And i think the best thing in SQL is taking advantage of the relational model.

Recommendations to others considering the product:

You should definitely try the power of combining SQL and NoSQL foundations.

What problems are you solving with the product? What benefits have you realized?

I deal with machine data for some of my college projects regarding embedded systems and IoT and also for some side projects. So i often use CrateDB to store and query these data. This is because CrateDB makes it easy to handle the volume of machine and log data. While also querying terabytes of data in real time.