What do you like best about the product?

What I find most valuable about CrateDB is its ability to handle massive datasets with impressive speed and efficiency. It seamlessly combines the ease of SQL with the scalability of NoSQL, making it perfect for real-time data analysis in scenarios like IoT or machine data projects. CrateDB’s flexibility to store and query structured, semi-structured, and unstructured data, along with its high scalability and real-time processing capabilities, make it an excellent choice for applications needing fast, reliable, and scalable database solutions.

What do you dislike about the product?

The project is still so young that still no real world stress test have been conducted on it. It takes some time for companies to migrate from their comfort zone on their heart of the system, database, to a new system. As a result, we still have to wait and see what happens. Also, some featuers such as a good extension system and implementation of basic algorithms like Approximate Nearest Neighbors are missing.

What problems is the product solving and how is that benefiting you?

On the business side, due to similarity of cratedb syntax to postgresql, there is no need to hire a mongoDB expert to work on noSQL databases. Every database engineer with a basic knowledge of SQL can start to learn about cratedb and have the best of both worlds.