# CrateDB Reviews **Vendor:** CrateDB **Category:** [Vector Database Software](https://www.g2.com/categories/vector-database) **Average Rating:** 4.4/5.0 **Total Reviews:** 85 ## About CrateDB The real-time database for analytics, search, and AI. 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 Pros & Cons **What users like:** - Users appreciate the **ease of use** of CrateDB, enjoying its straightforward setup and familiar SQL querying capabilities. (12 reviews) - Users appreciate the **fast SQL querying** capability of CrateDB, enabling efficient handling of large and high-frequency data streams. (11 reviews) - Users value the **easy integrations** of CrateDB, enabling smooth incorporation into existing production workflows. (10 reviews) - Users value the **flexibility** of CrateDB, seamlessly adapting to various needs and deployment options for diverse applications. (10 reviews) - Users value the **diverse data support** of CrateDB, enabling powerful searches and easy data integration for various models. (9 reviews) - Querying (8 reviews) - Users appreciate the **scalability** of CrateDB, enabling effective handling of massive datasets with speed and flexibility. (8 reviews) - SQL Support (8 reviews) - Users appreciate the **ease of integration** with existing systems, enabling smooth transitions and minimal disruption to workflows. (7 reviews) - Users praise CrateDB for its **scalability with large datasets** , ensuring efficient handling of diverse data types. (7 reviews) **What users dislike:** - Users note a **lack of features** , particularly in comparative information and advanced SQL functions, limiting overall value perception. (5 reviews) - Users note the **limited ecosystem** of connectors and tools in CrateDB, impacting versatility and integration options. (4 reviews) - Users express concerns about **limited features** in CrateDB, particularly regarding connectors, advanced SQL functions, and extensibility. (3 reviews) - Users find the **poor documentation** of CrateDB lacking in essential details for custom configurations and integrations. (3 reviews) - Users struggle with **complex configuration** related to Kubernetes and the lack of control over database sharding. (2 reviews) - Users find **insufficient training** makes CrateDB challenging to implement and utilize effectively without technical support. (2 reviews) - Users face a **steep learning curve** , especially those with limited experience in database technology, complicating implementation. (2 reviews) - Limited Community Growth (2 reviews) - Users find **poor customer support** and limited documentation, making the learning curve challenging for beginners. (2 reviews) - Poor UI (2 reviews) ## CrateDB Reviews ### 1. Easy Setup, High Performance SQL **Rating:** 4.0/5.0 stars **Reviewed by:** Marcin G. **Reviewed Date:** December 04, 2025 **What do you like best about CrateDB?** I appreciate CrateDB being open-source and how incredibly easy it is to use. Its performance is consistently good, which makes it reliable for my testing with AWS. I also find the SQL compatibility a strong point, enabling familiar and efficient database management. Additionally, the initial setup is a breeze, taking only a few minutes to create an account and set up a database, which I find very convenient. **What do you dislike about CrateDB?** I find the lack of comparative information to other database solutions on the market as a limitation. It would be beneficial if CrateDB provided more detailed comparisons, which would help in understanding its unique value propositions relative to other databases. Besides this aspect, I do not currently see any issues with the product itself, though I plan to explore it further to gain a deeper understanding. **What problems is CrateDB solving and how is that benefiting you?** I find CrateDB easy to use and its open-source nature combined with good performance enhance my testing with AWS. ### 2. Scalable Real-Time Time-Series SQL That’s Built for Observability **Rating:** 5.0/5.0 stars **Reviewed by:** Cristian M. | Data Center & Sites Manager, Enterprise (> 1000 emp.) **Reviewed Date:** March 09, 2026 **What do you like best about CrateDB?** Its combination of horizontal scalability and standard SQL for real-time time-series data. It feels practical for large-scale telemetry and observability use cases without adding unnecessary complexity. **What do you dislike about CrateDB?** I would like to see more detailed production-scale benchmarks and clearer architectural guidance for large observability workloads. **What problems is CrateDB solving and how is that benefiting you?** It solves the complexity of handling high-volume telemetry and time-series data at scale while keeping SQL as the query interface. This simplifies observability workflows and supports faster operational decision-making in infrastructure environments. ### 3. Fast SQL Queries with Seamless Data Streaming **Rating:** 4.5/5.0 stars **Reviewed by:** Timo T. | Agile Coach, Small-Business (50 or fewer emp.) **Reviewed Date:** December 01, 2025 **What do you like best about CrateDB?** I like the speed and native SQL interface over structured and semi‑structured data. It builds an index on the fly. It lets you stream data into the cluster, query it instantly with familiar SQL. No need for separate storage or query layers. That blend of performance, simplicity, and flexibility is what makes CrateDB stand out. **What do you dislike about CrateDB?** I haven’t worked with CrateDB myself, so take this with a grain of salt. Potential downsides may be a limited ecosystem of ready‑made connectors and admin tools and a SQL dialect that may lack advanced analytical functions. **What problems is CrateDB solving and how is that benefiting you?** I’m not handling data pipelines right now, but for my previous work with digital Rezept‑Prüfung system, CrateDB would have been useful to query massive amounts of document data fast. ### 4. Versatile Data Support Perfect for Agentic AI Applications **Rating:** 4.0/5.0 stars **Reviewed by:** Kazi Masudur R. | Software developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 01, 2025 **What do you like best about CrateDB?** I like the support for multiple data types which could be useful for agentic AI applications that we develop in our startup, to provide real-time data context **What do you dislike about CrateDB?** Some data sources might not be useful for use-cases at our startup presently. But there might be need for it in future. **What problems is CrateDB solving and how is that benefiting you?** It provides adaptability to multiple data sources and real-time streaming under one platform. ### 5. Evaluating CrateDB capabilities **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** December 18, 2025 **What do you like best about CrateDB?** Simple and Easy to use UI, good support for GeoJSON and Time Series DB and possibility to run it locally **What do you dislike about CrateDB?** I have not yet came across any shortcomings yet. **What problems is CrateDB solving and how is that benefiting you?** POC for understanding Databases of different types which can run on premise or in the cloud, ### 6. Fast setup and simple UX **Rating:** 5.0/5.0 stars **Reviewed by:** Fabio Taro C. | Strategy Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** October 24, 2024 **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. **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. **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. ### 7. CrateDB offers an excellent balance between SQL simplicity and the power of NoSQL scalability **Rating:** 4.5/5.0 stars **Reviewed by:** ALI N. | Machine Learning Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 24, 2024 **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. **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. **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. ### 8. CrateDB, a name that we will hear more in the future **Rating:** 4.5/5.0 stars **Reviewed by:** Hosein M. | Research Student, Small-Business (50 or fewer emp.) **Reviewed Date:** October 24, 2024 **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! **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. **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. ### 9. Useful platform for engineers **Rating:** 3.0/5.0 stars **Reviewed by:** Laura F. | Head of CS & CX Analytics, Mid-Market (51-1000 emp.) **Reviewed Date:** May 15, 2025 **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. **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. **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 ### 10. Excellent product for scalable data warehousing that also supports OSS **Rating:** 4.5/5.0 stars **Reviewed by:** Simon J. | Data Architect, Enterprise (> 1000 emp.) **Reviewed Date:** December 12, 2024 **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. **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. **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. ### 11. Cratedb-what is brings out **Rating:** 4.0/5.0 stars **Reviewed by:** Deepak R. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 17, 2024 **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. **What do you dislike about CrateDB?** need for more video tutorials and examples for beginners to learn. **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. ### 12. Wonderful workshop to sharpening your skillset in database engineering **Rating:** 4.5/5.0 stars **Reviewed by:** Ignasius A. | Chief Technology Officer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 25, 2024 **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. **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. **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 ### 13. Unlocking the power of CrateDB **Rating:** 5.0/5.0 stars **Reviewed by:** Johana A. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 12, 2024 **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. **What do you dislike about CrateDB?** That it is a very robust tool that would be misused on small projects. **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) ### 14. Cyber security log analysis with CrateDB **Rating:** 4.0/5.0 stars **Reviewed by:** Dhivyabharathi B. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 17, 2024 **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. **What do you dislike about CrateDB?** Document need to be improved and more training need to be added. **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. ### 15. The boss of Dynamic Migration - CrateDB **Rating:** 5.0/5.0 stars **Reviewed by:** Shiv S. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 03, 2024 **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! **What do you dislike about CrateDB?** There is nothing so far to dislike about CrateDB. **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. ### 16. Great power in vector databases **Rating:** 5.0/5.0 stars **Reviewed by:** Gonzalo L. | Senior Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 01, 2024 **What do you like best about CrateDB?** 1.- High performance and scalability for processing large amounts of real-time data 2.- Native integration with SQL, which simplifies complex queries and advanced analysis 3.- Geospatial indexing and similarity search **What do you dislike about CrateDB?** Less support and documentation compared to more popular solutions **What problems is CrateDB solving and how is that benefiting you?** With CrateDB I can scale how much real-time data I work with and query using vector databases and vector similarity search. I can actually take something random like a vector, and know what’s the closest vector to it [the k-nearest neighbours (kNN) algorithm], and could be mostly correct and deliver a good prediction forfinding a good match with high velocity. So, by more or less just me code into ETLs and machine learning, you will increase the prediction powers of these processes and improve performance. This is really good and now I can address different complex questions for my data products in a fast and accurate manner ### 17. Many good technologies under one roof **Rating:** 5.0/5.0 stars **Reviewed by:** Luis a. | Principal Data Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** October 14, 2024 **What do you like best about CrateDB?** A very good blend between SQL, NoSQL, Lucene, Vector, timeseries DB etc all under one roof. Performance is also fenomenal and it supports ANSI SQL **What do you dislike about CrateDB?** of course there are a few compromises when trying to use such a broad spectrum of technologies, but they are pretty minor when copared to the advantages **What problems is CrateDB solving and how is that benefiting you?** We are using it i mainly as a time series database for near real-time analytics and there is a bunch of other applications connecting through it via SQL. Migration was very easy as integration with other applications was done through SQL so this was pretty much lift and shift from one DB to another but way more performant and enabling many more use cases. (not just SQL) ### 18. Uses of cratedb **Rating:** 4.5/5.0 stars **Reviewed by:** dhineshkumar v. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 17, 2024 **What do you like best about CrateDB?** Cratedb is a NoSQL database so it is useful in handling large data such as vector data, geo location data, time series data analytics and real time data analytics. **What do you dislike about CrateDB?** Kubernetes support needs to be improved. **What problems is CrateDB solving and how is that benefiting you?** Collect Cybersecurity alerts from multiple endpoint as JSON object and view the details as Postgres SQL statement. ### 19. A well optimized multi-model database **Rating:** 4.0/5.0 stars **Reviewed by:** logasundharam s. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 17, 2024 **What do you like best about CrateDB?** CrateDB excels at performing fast SQL queries on large datasets, making it ideal for applications that need to process high-frequency data streams. **What do you dislike about CrateDB?** The CrateDB documentation doesn't fully cover the custom configurations for Kubernetes clusters when using the Helm chart for self management. **What problems is CrateDB solving and how is that benefiting you?** Ingesting cyber security logs to cratedb to analyze the alerts ### 20. a DBaaS with interesting functionalities for developers **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 26, 2024 **What do you like best about CrateDB?** I liked the keyword search with fuzzy functionalities. I liked the interpolation in time series analysis. I liked the idea the information can be compared by mathematical vectors. I liked the traditional SQL interface. I appreciated how it is easy to do these tasks in the programmer point of view. I liked the idea of integration that this product seems to provide. **What do you dislike about CrateDB?** I understood the product was built in particular for real time data processing and for data analysis (time series) . I did not understood if it can be used for others operations the companies usually are facing. For instance reporting production that have to satisfy particular templates or to be published in a distributed environment (es. Qlik, SAS,..). Data quality activities that implies data comparing and data correction. I did not understood if the tool supports effectively the security/authorization issues that normally a big company has, for instance some office can see some data, other can not. I fear the latencies due to newtwork infrastructure. How to handle with table with 60 million records? **What problems is CrateDB solving and how is that benefiting you?** I think the possibility to handle easly the situations with incomplete data is interesting ### 21. Really powerful tool **Rating:** 5.0/5.0 stars **Reviewed by:** javier s. | Data Analyst freelance, Small-Business (50 or fewer emp.) **Reviewed Date:** February 20, 2025 **What do you like best about CrateDB?** Excellent Customer Service and onboarding **What do you dislike about CrateDB?** From my perspective there is nothing to dislike **What problems is CrateDB solving and how is that benefiting you?** Connecting real time data ### 22. CyberSecurity Analysis with CrateDB **Rating:** 4.5/5.0 stars **Reviewed by:** Chander P. | Founder and CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2024 **What do you like best about CrateDB?** We liked very much about native postgresql support. We can store logs directly into CrateDB without another wrapper layer. **What do you dislike about CrateDB?** CrateDB support channel/forum should be improved. Even though it's good product, people start seeing how the community is active. As of now it's closed box. **What problems is CrateDB solving and how is that benefiting you?** We can stream cycber security logs directly store into the database. ### 23. Powerful and easy to use **Rating:** 4.0/5.0 stars **Reviewed by:** Federico V. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 28, 2024 **What do you like best about CrateDB?** I like how it integrates different type of data with a SQL-like syntax. **What do you dislike about CrateDB?** I think all that power requires a lot of resources, which can result in higher costs. **What problems is CrateDB solving and how is that benefiting you?** CrateDB solves the challenge of analyzing large volumes of time-series and IoT data in real-time using SQL, which makes it easy to integrate with existing systems. ### 24. a workshop with CrateDB- native SQL is very robust **Rating:** 5.0/5.0 stars **Reviewed by:** ran o. | Data & AI Solution architect consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2025 **What do you like best about CrateDB?** its a large all in one data solution for the AI age **What do you dislike about CrateDB?** there are still gaps in the solution that can be fullfilled **What problems is CrateDB solving and how is that benefiting you?** a all in one DB for all types of data from unstructured to relational ### 25. Review based on workshop at tech vault in Berlin in february **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 20, 2025 **What do you like best about CrateDB?** Vector + keyword + sql.. being able to to joins on keyword searches (so between indices) and have the same filter behaviour for both vector and keyword search. **What do you dislike about CrateDB?** I don't think i have enough experience to judge, but the community seems (still) quite small compared to e.g. postgresql or ES. I hope that will change in the future. **What problems is CrateDB solving and how is that benefiting you?** Hybrid search for Vectors and Documents. ### 26. Discovering the potential of CrateDB **Rating:** 5.0/5.0 stars **Reviewed by:** Nathaly B. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 12, 2024 **What do you like best about CrateDB?** Its SQL-based syntax and the superset of new functionalities on top of this language, make there is no barrier to entry and enhance the possibilities of the data. **What do you dislike about CrateDB?** CrateDB is designed for robust, data-intensive solutions, but it may overlook lightweight options that also have significant potential. **What problems is CrateDB solving and how is that benefiting you?** CrateDB will be a tool to consider when implementing AI and Machine Learning solutions. ### 27. Positive Demo Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Mitesh M. | Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** June 06, 2024 **What do you like best about CrateDB?** 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. **What do you dislike about CrateDB?** 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. **What problems is CrateDB solving and how is that benefiting you?** CrateDB shows great potential for projects with diverse database requirements, making it a good candidate for future use when dealing with various use cases and different database needs. ### 28. Great and knowledgeable employees presented great tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** May 09, 2024 **What do you like best about CrateDB?** 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. **What do you dislike about CrateDB?** 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. **What problems is CrateDB solving and how is that benefiting you?** It has really fast mechanism of getting data, which is important for my genAI apps that rely on RAG. ### 29. A capable solution to consolidate your diverse data sources and fulfill analytics needs **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** September 19, 2024 **What do you like best about CrateDB?** 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) **What do you dislike about CrateDB?** 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. **What problems is CrateDB solving and how is that benefiting you?** CrateDB enables consoidation and analysis of vast amounts of time series data with suitable performance. ### 30. it would provide an excellent system for our telemetry logging requirements . **Rating:** 4.5/5.0 stars **Reviewed by:** John L. | Technical Director§, Small-Business (50 or fewer emp.) **Reviewed Date:** December 12, 2024 **What do you like best about CrateDB?** simplke to setup & SQL querying which many are familiar with **What do you dislike about CrateDB?** nothing yet. possibly only able to access the cloud version via a web gui **What problems is CrateDB solving and how is that benefiting you?** looking to implement a realtime telemetry monitoring systems for mobile workers **Official Response from Stephane Castellani:** > Thank you for your review. In addition to the CrateDB Cloud Web interface and its integrated SQL query console, you can use the Croud CLI, a command-line interface tool for remote interaction. ### 31. Join CrateDB EU Tour, 2024. **Rating:** 4.0/5.0 stars **Reviewed by:** PoHsuan C. | NLP Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 17, 2024 **What do you like best about CrateDB?** It supports multi-model data, full text and vector search, and timeseries data search. **What do you dislike about CrateDB?** Maybe need technical expertise for integration and deployment? **What problems is CrateDB solving and how is that benefiting you?** Time series data storage and analysis. ### 32. Excellent session **Rating:** 4.0/5.0 stars **Reviewed by:** Srihari v. | Data Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** December 13, 2024 **What do you like best about CrateDB?** Flexibility, Open Soure, Linear Pricing **What do you dislike about CrateDB?** Haven't used to an extend of not liking something yet **What problems is CrateDB solving and how is that benefiting you?** For our offers to Clients, CrateDB seems a good fit for some clients problems ### 33. A distributed SQL database that offers several advantages for storing large amounts of data **Rating:** 5.0/5.0 stars **Reviewed by:** Alistair M. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 07, 2024 **What do you like best about CrateDB?** 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. **What do you dislike about CrateDB?** 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. **What problems is CrateDB solving and how is that benefiting you?** Scaling ### 34. Unveiling the Essential Database Solution for Businesses **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammad Huzaifah H. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 29, 2024 **What do you like best about CrateDB?** 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. **What do you dislike about CrateDB?** 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. **What problems is CrateDB solving and how is that benefiting you?** CrateDB resolves critical data management challenges by consolidating disparate data sources, facilitating streamlined operations, and fostering informed decision-making. Its parallel processing and distributed computing capabilities ensure optimal performance and scalability, accommodating evolving data volumes and complexities. With support for diverse data types and CrateDB functions built atop conventional SQL, the platform offers a familiar yet advanced interface adaptable to varied business requirements. From real-time analytics in IoT environments to log analytics and monitoring, CrateDB's capacity to efficiently handle large datasets and deliver actionable insights positions it as a valuable asset for businesses seeking to enhance their data infrastructure and analytics capabilities. ### 35. User friendly **Rating:** 5.0/5.0 stars **Reviewed by:** Won K. | European Business, Small-Business (50 or fewer emp.) **Reviewed Date:** May 31, 2024 **What do you like best about CrateDB?** The CrateDB team can be very helpful in the initial onboarding phase. The Console is user-friendly. CrateDB documentation is also intuitive. **What do you dislike about CrateDB?** There wasn't anything in particular that I disliked. **What problems is CrateDB solving and how is that benefiting you?** I got to experiment with CrateDB and its use of the OpenAI api to create chatbots leveraging the existing data. ### 36. Efficient and easy to integrate **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Consulting | Mid-Market (51-1000 emp.) **Reviewed Date:** November 07, 2024 **What do you like best about CrateDB?** The ease of integration with existing systems allowes for a smooth transition and minimal disruption to workflows. **What do you dislike about CrateDB?** Documentation could be improved in some areas, like the integration with other drives/dialects. **What problems is CrateDB solving and how is that benefiting you?** CrateDB efficiently handles large-scale, complex datasets, making it suitable for a vector database for a RAG system. ### 37. A well optimized multi-model database with decent performance **Rating:** 4.0/5.0 stars **Reviewed by:** Vivek P. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 10, 2024 **What do you like best about CrateDB?** Time series functionlity. Supportive team from Crate. Performance while handeling variety of data considering huge volume. **What do you dislike about CrateDB?** Stored Procedures can be added. Running different queries inside the console without commenting the other queries is not possible right now. **What problems is CrateDB solving and how is that benefiting you?** Timeseries Data, Multi Model Support. **Official Response from Stephane Castellani:** > Thank you for your review Vivek. I am happy to share that with the new console in CrateDB Cloud, you can now run multiple commands in one go. ### 38. Great demo! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Program Development | Mid-Market (51-1000 emp.) **Reviewed Date:** September 23, 2024 **What do you like best about CrateDB?** CrateDB showcased their product in different usecases, their SQL queries are very advanced and can solve many problems. **What do you dislike about CrateDB?** The downsides of using CrateDB is the same downside as another other piece of software, they have unique functionality that can't be changed fast if needed. **What problems is CrateDB solving and how is that benefiting you?** CrateDB is a potential db for a RAG system in production. ### 39. CrateDB is fast distributed and multimodel data base **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 05, 2024 **What do you like best about CrateDB?** I've been using CrateDB and am impressed with its performance and scalability. Its real-time SQL capabilities make it very easy to use and its distributed nature allows for effortless horizontal scaling. The SQL support ensures easy integration with existing workflows, and the community and support team have been very responsive. CrateDB's flexibility and ease of use have significantly enhanced the data handling capabilities for our customer and we are evaluating more use cases together. CrateDB is also a vector database, making it ideal for large language models (LLMs) and generative AI use cases, with the capability of adding context Highly recommended for anyone in need of a robust, scalable database solution **What do you dislike about CrateDB?** I am vey pleaesd i don't have any dislikes. **What problems is CrateDB solving and how is that benefiting you?** We implemented CrateDB for one of our customers in Financial Services for log analysis. The speed and ease of use made it the database of choice for this use case ### 40. Very versatile tool suited for hybrid setup **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consulting | Mid-Market (51-1000 emp.) **Reviewed Date:** November 07, 2024 **What do you like best about CrateDB?** Ease of use, versatility. A solid data warehousing alternative to most popular solutions. **What do you dislike about CrateDB?** It's hard to find a fault. Maybe it being less known. **What problems is CrateDB solving and how is that benefiting you?** Data warehousing alternative ### 41. High Performance Distributed Multimodal Database **Rating:** 5.0/5.0 stars **Reviewed by:** Abhishek G. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 26, 2024 **What do you like best about CrateDB?** CrateDB is High performance performance-distributed multimodal database. Data-driven applications in today's world require fast response times, real-time insights, and constant improvement, which can be very challenging when integrating multiple data sources and databases. CrateDB solves this problem by providing a unified representation for all types of data, enabling hyper-fast and scalable execution, and offering various deployment options. **What do you dislike about CrateDB?** So far I haven't seen any downside. It's a multi-purpose database that can handle TSDB, Geospatial, vector for AI, etc. **What problems is CrateDB solving and how is that benefiting you?** We are collecting data that are time-critical. ### 42. Yet another SQL database with possibilities **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** September 19, 2024 **What do you like best about CrateDB?** The extended possibilities with features like vector search in combination with other SQL criterias **What do you dislike about CrateDB?** I do not see any issues with the knowledge I have today **What problems is CrateDB solving and how is that benefiting you?** It is a database that scales to high ingestion rates and with some advanced features ### 43. CrateDB covers all our needs for database solutions. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Automotive | Mid-Market (51-1000 emp.) **Reviewed Date:** March 01, 2024 **What do you like best about CrateDB?** It is a single, standalone solution covering a wide range of our needs. CrateDB stands its place for different database workloads, be it time-series data, document indexing, or vector search, and still, it comes with ease of use, deployment has never been so straightforward so far. **What do you dislike about CrateDB?** No drawbacks of using CrateDB have been realized so far. **What problems is CrateDB solving and how is that benefiting you?** CrateDB acts as the primary time-series database, it stores the raw data collected from different sources and acts as the backend for subsequent data analytics. ### 44. Easy to integrate in complex system **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consulting | Mid-Market (51-1000 emp.) **Reviewed Date:** November 04, 2024 **What do you like best about CrateDB?** Performance, UI for monitoring, easiness of integration in existing systems. **What do you dislike about CrateDB?** Nothing to be mentioned here, it works well. **What problems is CrateDB solving and how is that benefiting you?** Robust DB for client solutions. ### 45. A powerful database with wide range of features **Rating:** 4.0/5.0 stars **Reviewed by:** Abdulkhader S. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2024 **What do you like best about CrateDB?** Easy to use, support for vector storage, timeseries etc., a single solution for multiple problems **What do you dislike about CrateDB?** Learning curve is a bit complex due to lack of practical examples even though the documentation is quite good. However they seem to be working on making tutorials available, so it's bound to get better **What problems is CrateDB solving and how is that benefiting you?** We were able to set up a custom monitoring solution to gather logs and analyse the behaviour of out ML models in real time using CrateDB's time series support ### 46. Efficiently Scalable with a Learning Curve **Rating:** 4.5/5.0 stars **Reviewed by:** Omidreza A. | Data Science/Software Engineering Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** March 01, 2024 **What do you like best about CrateDB?** I appreciate CrateDB's ability to handle massive amounts of data with ease, thanks to its distributed architecture. It scales efficiently, making it a great choice for time-series data, IoT applications, and any scenario requiring high write and read speeds. **What do you dislike about CrateDB?** While CrateDB boasts impressive performance and scalability, its learning curve can be steep for those not already versed in distributed database management. The documentation, though extensive, sometimes lacks practical examples, making it challenging for new users to implement specific features or troubleshoot issues. **What problems is CrateDB solving and how is that benefiting you?** Handling Large-Scale Data Real-Time Data Analysis Ease of Use with SQL Simplified Data Architecture ### 47. Excellent DB providing high performances and high availbility **Rating:** 5.0/5.0 stars **Reviewed by:** Charles-Edouard R. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** June 01, 2024 **What do you like best about CrateDB?** Fault-Tolerant, Scaling, Ease of setup & maintenance. Can run with low-memory footprint. **What do you dislike about CrateDB?** not much to say here ... I've been using the product for 8 years **What problems is CrateDB solving and how is that benefiting you?** Storing my IOT sensors data as well as all the information that's required to make my customer facing front-end portal working. ### 48. One single solution for different varieties of data - Multimodal Database **Rating:** 4.5/5.0 stars **Reviewed by:** Raja D. | Co-Founder, Small-Business (50 or fewer emp.) **Reviewed Date:** May 24, 2024 **What do you like best about CrateDB?** CrateDB's scalability and cost-effectiveness make it a strong option for companies requiring real-time data analytics solutions that can handle a wide variety of data formats. **What do you dislike about CrateDB?** Looking forward to have some more features on the relational database features/capabilities as well. **What problems is CrateDB solving and how is that benefiting you?** Real-time Data Ingestions and analytics ### 49. CrateDB Review **Rating:** 5.0/5.0 stars **Reviewed by:** Klaudia G. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 01, 2024 **What do you like best about CrateDB?** It's a database for relational data, objects, geospatial data and more in one place. It has a readable UI and since it uses PostgreSQL, the querying is fast and easy for everyone who has already workes with any SQL DB:) **What do you dislike about CrateDB?** I am still waiting for the full postgreSQL integration :) **What problems is CrateDB solving and how is that benefiting you?** CrateDB for time-series data is an ideal choice because of its robust support for standard SQL commands , along with window functions which make querying faster. ### 50. Interesting Session **Rating:** 4.0/5.0 stars **Reviewed by:** Mayank A. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 31, 2024 **What do you like best about CrateDB?** Because it works on timeseries functionality, it's definitely help us in future. **What do you dislike about CrateDB?** it takes 2-3 seconds to execute the command **What problems is CrateDB solving and how is that benefiting you?** It resolves the problem of indexing and timestamp issue **Official Response from Stephane Castellani:** > Thank you very much for your review, we are glad you liked the workshop. Regarding your mention of the time to execute a command, the use of resource-limited Jupyter notebooks combined with an entry-level CRFREE single-node cluster is of course meant for educational purposes only. - [View CrateDB pricing details and edition comparison](https://www.g2.com/products/cratedb/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-07+12%3A35%3A53+-0500&secure%5Bsession_id%5D=b32b6bed-d627-4dd5-b789-8aa702f8c3f3&secure%5Btoken%5D=4f83a38cb3f70b6261185e6d9664d38652369798ec75c3ce903ce3dc711291cb&format=llm_user) ## CrateDB Integrations - [AWS CloudFormation](https://www.g2.com/products/aws-aws-cloudformation/reviews) ## CrateDB Features **Data Management** - Data Model - Data Types - Built - In Search - Event Triggers **Storage** - Data Model - Data Types **Data Indexing** - Semantic Search - Indexing Data **Query latency** - Lower query latency - Continuous queries **Configuration** - Application Performance - Orchestration - Database Monitoring - Anomaly Detection - Network Security **Availability** - Auto Sharding - Auto Recovery - Data Replication **Availability** - Auto Sharding - Auto Recovery - Data Replication **Data latency** - Lower data latency - Data pipeline performance **Database Administration** - Provisioning - Governance - Auditing **Performance** - Query Optimization **Performance** - Integrated Cache **Filters** - Accurate Search - Single Stage Filtering - Vector Database **Connectors** - Faster ingestion - Built-in connectors **Availability** - Scalability - Backup - Archiving - Indexing **Security** - Data Masking - Authentication And Single Sign-On - Data Anonymization **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Scale** - Linearly scalable database - Storage management **Data Management** - Data Replication - Advanced Data Analytics **Support** - Multi-Model - Operating Systems - BI Connectors **Support** - Multi-Model - Operating Systems **Architecture** - Data security - Lockless architecture **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top CrateDB Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (706 reviews) - [MongoDB Atlas](https://www.g2.com/products/mongodb-atlas/reviews) - 4.5/5.0 (350 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (927 reviews)