Introducing G2.ai, the future of software buying.Try now

CrateDB Reviews & Product Details

CrateDB Overview

What is CrateDB?

The enterprise database for time series, documents, and vectors. Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source, multi-model, distributed and containerized database that runs queries in milliseconds, regardless of data complexity, volume and velocity.

CrateDB Details
Product Website
Languages Supported
English
Show LessShow More
Product Description

Crate.io is a distributed, document-oriented database designed to be used with traditional SQL syntax.


Seller

CrateDB

Description

The enterprise database for time series, documents, and vectors. Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source, multi-model, distributed and containerized database that runs queries in milliseconds, regardless of data complexity, volume and velocity.

Overview Provided by:

Recent CrateDB Reviews

LS
logasundharam s.Small-Business (50 or fewer emp.)
4.0 out of 5
"A well optimized multi-model database"
CrateDB excels at performing fast SQL queries on large datasets, making it ideal for applications that need to process high-frequency data streams.
Laura F.
LF
Laura F.Mid-Market (51-1000 emp.)
3.0 out of 5
"Useful platform for engineers"
Endless possibilities to create, if the engineer/analyst can write in Python. I expect this to be very easy to integrate with other tools.
javier s.
JS
javier s.Small-Business (50 or fewer emp.)
5.0 out of 5
"Really powerful tool"
Excellent Customer Service and onboarding

CrateDB Media

CrateDB Demo - CrateDB Cloud Free Tier
Get started for free with CrateDB Cloud. Be up and running in less than 5 minutes. No credit card required! No hidden costs.
CrateDB Demo - Scalability
Easily scale from three to hundreds of nodes directly from the console.
CrateDB Demo - Performance
Execute complex ad-hoc SQL queries on vast datasets in milliseconds, facilitating real-time analytics with superior performance.
CrateDB Demo - Easy of Use
Harness the power of native SQL to run any type of query and search, including JOINs, vector, and full-text capabilities. Use one single database for all types of data: tables, documents, time-series, vectors, geospatial data, and binary objects.
Introduction to CrateDB:
Key Concepts, Architecture, and Live Demo
Play CrateDB Video
Introduction to CrateDB: Key Concepts, Architecture, and Live Demo
In this video, we explore the integration of CrateDB and PyCaret to detect anomalies in machine data, crucial for identifying potential failures or inefficiencies in technological systems
Play CrateDB Video
In this video, we explore the integration of CrateDB and PyCaret to detect anomalies in machine data, crucial for identifying potential failures or inefficiencies in technological systems
Discover how to effortlessly create a table and seamlessly import weather data into CrateDB in this video.
Play CrateDB Video
Discover how to effortlessly create a table and seamlessly import weather data into CrateDB in this video.

Official Downloads

Answer a few questions to help the CrateDB community
Have you used CrateDB before?
Yes

80 CrateDB Reviews

4.4 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
80 CrateDB Reviews
4.4 out of 5
80 CrateDB Reviews
4.4 out of 5

CrateDB Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
FC
Strategy Analyst
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

The onboarding process to create an account and get a cloud cluster running was very easy and fast. I also like how they use Postgresql under the hood so you dont have to learn a new language. Integratio via javascript and python with sqlalchemy makes it easy to test and deploy production applications. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

The Admin dashboard's UI can be improved. Also, there is currently no way to control the database sharding. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

CrateDB will play a key role in managing time series data for tracking energy consumption patterns in real-time for my Utilities client. In this use case, CrateDB allows me to store and analyze massive amounts of energy meter readings, taken at frequent intervals across various locations. Its ability to handle continuous streams of data and execute complex queries quickly ensures that I can provide real-time insights into consumption trends. This helps in optimizing energy usage, forecasting demand, and identifying inefficiencies, ultimately driving cost savings and operational improvements for the business. Review collected by and hosted on G2.com.

AN
Machine Learning Engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

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. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

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. Review collected by and hosted on G2.com.

What problems is CrateDB 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. Review collected by and hosted on G2.com.

Hosein M.
HM
Research Student
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

For me, the fact that with CrateDB, we can use SQL while having the benefits of NoSQL and VectorDBs is the best. It is so easy to use, and with their built-in functions such as 'distance' or 'knn-match,' you can enjoy the process of data analysis. Considering that you can easily integrate different types of databases and data models is something that I have never seen before. To put it in a nutshell, RESPECT! Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

We should be aware of how challenging the world of databases is, and I believe that CrateDB is just at the beginning of its journey. For me, one thing I didn't like was that it did not support using ORMs, and we had to write the queries completely as strings. So, I think if this feature, along with other features such as allowing developers to add their own add-ons and extensions, is added, CrateDB could become even better. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

For me, the problem that CrateDB will solve is that I can combine different types of data and have them all together in one database. So, I don't have to use multiple databases, and I can easily manage my data, analyze it, and use it for further steps such as Deep Learning and Machine Learning.

Another issue that CrateDB can resolve for me is its compatibility with Python, the language of AI, making it much easier to use. You don't have to switch between different languages and databases. Review collected by and hosted on G2.com.

Laura F.
LF
Head of CS & CX Analytics
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best about CrateDB?

Endless possibilities to create, if the engineer/analyst can write in Python. I expect this to be very easy to integrate with other tools. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

Without highly technical teams supporting, this is a hard tool to implement. It is not easy to use if you are a receiving stakeholder presenting the results, as the data still needs to be visualised. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

CrateDB allows us to join different sources that might live in different environments. This is a huge benefit Review collected by and hosted on G2.com.

SJ
Data Architect
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

Scalable with ease whilst also offering options for edge computing. Integrating the system into an exsiting hyperscaler is easy, especially now that is is available as a one-click deployment. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

More regions for deploying through the CrateDB cloud would be excellent, I'd also to see further extension of the in-built commands for working with the data inside of the database. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

We've been looking for a solution that caters to real-time use cases, primarily looking at time series data in large volumes. It's a useful to have multiple models contained within the same product, offering flexibility in consumption patterns for diverse user groups.

This fits the bill, and looking forward to developing this further as an offering with for clients. Review collected by and hosted on G2.com.

DR
Associate Software Engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about CrateDB?

cratedb can manage a large volume of data, analysing of the data are made easy using cratedb. It suports real-time data processing, so that we can query and view the data easily. Cratedb is desgined with high reliability and availability for handling enormous data. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

need for more video tutorials and examples for beginners to learn. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

Cratedb solve the problem with complexity in data management so here we can analyse and understand what happening in real time. Review collected by and hosted on G2.com.

Ignasius  A.
A
Chief Technology Officer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

CrateDB gives me an option to handling large amounts of time series data and other structured data efficiently. The integration of this tools is quite easy to your production line. It also comes with pretty basic example of hands on experience in using this integrated tools. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

I think for those who has limited experience with database will require longer learning curve. The tutor was great, however I hope the after sales service would go along with it. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

I am doing a digital twin for various water distribution networks in the european and asian landscape where we utilize real time data from sensors. CrateDB helps me in handling large volumes of time-series data efficiently and in real-time. This is crucial for monitoring and managing complex water systems, as it allows for real-time data ingestion, analysis and scalability Review collected by and hosted on G2.com.

Johana A.
JA
Data Engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: G2 invite on behalf of seller
Incentivized Review
What do you like best about CrateDB?

The ability to adjust to the requirements of new solutions driven by generative and native AI and machine learning. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

That it is a very robust tool that would be misused on small projects. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

CrateDB is a tool that solves the coexistence of different types of data, this helps the current process of understanding old data and other formats that companies currently require to organize the company in function of artificial intelligence, and for automation processes that are not yet predictive because they do not have a tool that relates the data with decision making. I believe that CrateDB plays an important role in today's data revolution.

Translated with DeepL.com (free version) Review collected by and hosted on G2.com.

DB
Associate Software Engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about CrateDB?

To store and access different kinds of data such as Geospatial, vector, time-series, JSON data etc. Can able to store large amount of data. And ease of access for JSON object, Array kind of data. Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

Document need to be improved and more training need to be added. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

We can able to store the cyber security logs as JSON objects and able to access the data very easily. Review collected by and hosted on G2.com.

Shiv S.
SS
Data Engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
Rating Updated ()
What do you like best about CrateDB?

The thing I like the best about CrateDB is the usage of the "Dynamic column" option which makes it eaiser to implemenent the dynamic column import. While creating table for my data this option helped me to migrate all the columns from excel to database without any declaration of each and every column. I also loved the design of the Admin UI which has an option to query single table data with "just a click of a button".

Furthermore, the experience of Customer Support was also based on one on one meeting with the technical manager, which helped me a lot in solving technical difficulties more precisely.

There are multiple python libraries out there which supports the integration of the crateDB with my script.

Finally, I use this product daily and for data pipelining, and I would like to recommend this product to all the people out there.

Just try it once! Review collected by and hosted on G2.com.

What do you dislike about CrateDB?

There is nothing so far to dislike about CrateDB. Review collected by and hosted on G2.com.

What problems is CrateDB solving and how is that benefiting you?

During table creation, the issue of declaring columns with data type for each and every excel column is eliminated. It saves me a lot of time and helps me to use my time more towards productivity. Review collected by and hosted on G2.com.