CrateDB Pros and Cons

I recently explored CrateDB in a demo project, and I must say, my experience was positive. Despite the limited scope of my usage, CrateDB performed well across various scenarios.

CrateDB's variety of supporting use cases stands out. One can use SQL to handle all of them. In our project, we tested it with relational data, timeseries data and geospatial data. We also tested the search capabilities. In each scenario, CrateDB performed well. During our primitive load testing, it efficiently managed substantial loads without any significant issues, displaying its robust architecture and scalability. Review collected by and hosted on G2.com.

As of now, I don't have any dislikes regarding CrateDB. However, it is important to mention that my experience was limited to a demo project, and I haven't tested it in a production environment. Further usage and testing would be necessary to draw conclusions about its capabilities over time. Review collected by and hosted on G2.com.

I had workshop with CrateDB employees where we worked with CrateDB. It was easy to set it up and start playing with it - testing, running queries, talking with genAI agent, etc..

After workshop I feel I know more about CrateDB and their product. And I am glad I met these people and stayed in a touch with them.

It is easy to integrate it in your app, whether it is new one, or already in prod.

Frequency of use: I will firstly use it for internal projects to make sure I know it well and then I'll see how often I will work with it. Review collected by and hosted on G2.com.

I am still at the beginning of using CrateDB, so currently no problems appeared along the way.

What could be challenging, is the fact that they are 'new' and that they don't have enough docs/bugs/problem discussions online, so problem solving could take more than expected. On another hand, they have nice customer support and did advice us to rely on this as much as possible, to speed up our onboarding and working with CrateDB. Review collected by and hosted on G2.com.

It is scalable, flexible and fast. Its many capabilites makes it able to adapt to different company needs. There are options for different deployment setups (on premise, cloud, and in between) Review collected by and hosted on G2.com.

As with any tool, there are some aspects that only reveal themselves once you deep dive into the product. (But the company has e-learning options and qualified expert so I would not worry too much.)

I only had the opportunity to try CrateDB with a limited scope of time series data and text analysis using large language models. It would be exciting to see how it handles "live" deployment in a complex architecture and diverse business need. Review collected by and hosted on G2.com.

simplke to setup & SQL querying which many are familiar with Review collected by and hosted on G2.com.

nothing yet. possibly only able to access the cloud version via a web gui Review collected by and hosted on G2.com.

It supports multi-model data, full text and vector search, and timeseries data search. Review collected by and hosted on G2.com.

Maybe need technical expertise for integration and deployment? Review collected by and hosted on G2.com.

Flexibility, Open Soure, Linear Pricing Review collected by and hosted on G2.com.

Haven't used to an extend of not liking something yet Review collected by and hosted on G2.com.

Scalability and Flexibility: CrateDB combines the best of both worlds by providing the benefits of an SQL database along with the scalability and flexibility typically associated with NoSQL databases. It can handle tens of thousands of records per second without breaking a sweat, making it suitable for large-scale data ingestion.

Horizontally Scalable and Fault-Tolerant: CrateDB clusters run well in virtualized and containerized environments. They remain horizontally scalable, highly available, and fault-tolerant even under heavy load. This means you can easily expand your cluster as needed without compromising on performance or reliability.

Blazing-Fast Distributed Query Execution: CrateDB’s query execution engine parallelizes query workloads across the entire cluster, resulting in extremely fast query performance. Whetherwe run ad-hoc queries or complex aggregations, CrateDB handles them efficiently. Review collected by and hosted on G2.com.

I like User-Defined Functions (UDFs) when we can extend CrateDB’s functionality by creating custom user-defined functions (UDFs). I feel CrateDB can extend these even more one day. Review collected by and hosted on G2.com.

As a seasoned data engineer, CrateDB captivates with its multifaceted capabilities, notably:

Aggregating diverse data sources seamlessly, spanning streaming, batch, structured, and unstructured data.

Leveraging parallel processing and distributed computing for enhanced performance.

Seamlessly scaling to meet evolving data demands.

Introducing CrateDB functions atop conventional SQL, streamlining accessibility for SQL-savvy users. Review collected by and hosted on G2.com.

A noteworthy enhancement for CrateDB Cloud would involve delineating compute and storage pricing, empowering businesses to optimize client billing strategies. It's encouraging to note that CrateDB is actively addressing this, and I anticipate its implementation in the near future. Review collected by and hosted on G2.com.

The CrateDB team can be very helpful in the initial onboarding phase.

The Console is user-friendly.

CrateDB documentation is also intuitive. Review collected by and hosted on G2.com.

There wasn't anything in particular that I disliked. Review collected by and hosted on G2.com.

The ease of integration with existing systems allowes for a smooth transition and minimal disruption to workflows. Review collected by and hosted on G2.com.

Documentation could be improved in some areas, like the integration with other drives/dialects. Review collected by and hosted on G2.com.