---
title: CrateDB Reviews
meta_title: 'CrateDB Reviews 2026: Details, Pricing, & Features | G2'
meta_description: Filter 85 reviews by the users' company size, role or industry to
  find out how CrateDB works for a business like yours.
aggregate_rating:
  rating_value: 4.4
  review_count: 85
  scale: '5'
date_modified: '2026-07-17'
parent_category:
  name: Database Software
  url: https://www.g2.com/categories/database-software
---

# 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 setup and SQL querying** , which makes CrateDB accessible and efficient for data analysis. (12 reviews)
- Users value the **fast SQL queries** in CrateDB, enabling seamless streaming and processing of complex data efficiently. (11 reviews)
- Users appreciate the **easy integrations** of CrateDB, facilitating seamless connections with tools for efficient data handling. (10 reviews)
- Users value the **flexibility** of CrateDB, appreciating its adaptability to various data types and deployment setups. (10 reviews)
- Users praise the **multi-model data support and advanced search capabilities** , finding it versatile and easy to use. (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** in CrateDB, particularly in comparative insights and advanced SQL functions. (5 reviews)
- Users find **software limitations** in CrateDB, including a lack of advanced features and support for complex operations. (4 reviews)
- Users express concerns about the **limited features** of CrateDB, particularly regarding connectors and analytical capabilities. (3 reviews)
- Users find the **poor documentation** of CrateDB lacking, especially regarding custom configurations and integrations. (3 reviews)
- Users find **complex configuration** challenges in CrateDB, especially regarding Kubernetes and sharding management. (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. RAG empowerd by SQL and SImilarity search

**Rating:** 4.0/5.0 stars

**Reviewed by:** Ali B. | Small-Business (50 or fewer emp.)

**Reviewed Date:** February 22, 2024

**What do you like best about CrateDB?**

I have to say that by using Cratedb I will be able to use both SQL and Similarity search in developing a QA chatbot. In other words, we could combine the vector similarity search and SQL query to create the chatbot.

**What do you dislike about CrateDB?**

Nothing. I like it and see possiblity for improvements.

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

Improving RAG by using similarity search and SQL.

  ### 2. Create cool stuff with CrateDB

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 01, 2024

**What do you like best about CrateDB?**

CrateDB effortlessly scales horizontally, making it ideal for managing massive datasets with consistent performance. Its real-time data processing capabilities empower businesses to derive insights swiftly from high-speed data streams. Furthermore, leveraging SQL as its query language, CrateDB offers familiarity and ease of integration with existing systems.
Built-in fault tolerance mechanisms ensure data integrity and system reliability, even in the face of failures.

**What do you dislike about CrateDB?**

While offering connectors for popular frameworks, CrateDB's ecosystem integrations could be broader, limiting versatility.

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

CrateDB is helping us a with a few time series projects to provide a scalable and fast storage layer.

  ### 3. CrateDB is single consolidated db for most of the analytics and ML usecases

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 04, 2024

**What do you like best about CrateDB?**

It provides best of both worlds, for unstructured and structured data. As it inbuilt lucene features it helps us to do faster queries, while the Postgres wire protocol provides as easy to manage integration with existing applications.

**What do you dislike about CrateDB?**

None experienced so far in our usage and application development.

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

We ingest user interactions with one of the e commerce platform and then this data is fed to real time sales and analytics insights.
To showcase analytics dashboard and also let stakeholders query adhoc  without creating more tech choices, crateDB is the best platform.

  ### 4. Promising technology

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** April 30, 2024

**What do you like best about CrateDB?**

Helpful team demonstrated the technology behind and practical application of CrateDB in a hands on workshop where it was integrated with LangChain to utilize its power combined with LLMs

**What do you dislike about CrateDB?**

steep learning curve if you are not familiar with similar technolgy

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

Streamlined data management by supporting various data models like time series, vector ect

  ### 5. Cratedb review

**Rating:** 4.5/5.0 stars

**Reviewed by:** Dinesh S. | Software Engineer, Computer Software, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 03, 2023

**What do you like best about CrateDB?**

Great DP is very easy to use and we can execute large amount of data queries and get their results in a very minimal time around milliseconds. The additional features includes integrating with the third party application is very easy. The application is very scalable and flexible to use.

**What do you dislike about CrateDB?**

The application request specific data engineers to work and it has complex infrastructure to use. It is expensive to use.

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

The application configuration is very easy and it has minimal set of instructions to install. We can integrate this application with multiple data bases and it can accommodate slminimal space for complex queries.

  ### 6. High Performant Database for Predictive Maintenance

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ihor S. | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 01, 2024

**What do you like best about CrateDB?**

Speed, ease of use, SQL interface, easy integration, active open source community

**What do you dislike about CrateDB?**

Eventual consistency doesnt fit all usecases

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

Predictive Maintenance of thehundreds of servers for cloud based infrastructure.

  ### 7. Efficient tool for Time series database

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Research | Small-Business (50 or fewer emp.)

**Reviewed Date:** April 06, 2024

**What do you like best about CrateDB?**

What makes CrateDB ineteresting is its scalability, distributed architecture, flexibility and hadndling both unstructured and structured data [with the focus on time-series].

**What do you dislike about CrateDB?**

Needs more practical examples in tuturials. The execustion speed and UI can be improved

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

Creating queries easily. Protecting and handling large amount of data

  ### 8. Participated in CrateDB workshop for using private data in generative AI

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Industrial Automation | Enterprise (> 1000 emp.)

**Reviewed Date:** May 07, 2024

**What do you like best about CrateDB?**

It is highly appreciated the integration of SQL

**What do you dislike about CrateDB?**

It is complex working with time-series data

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

Time-series data management and scalable data storage

  ### 9. interesting, but nothing new

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Real Estate | Enterprise (> 1000 emp.)

**Reviewed Date:** May 07, 2024

**What do you like best about CrateDB?**

I found it was easy to use and intuitive

**What do you dislike about CrateDB?**

It wasn't working properly during the workshop

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

Mantain a vector database

**Official Response from Stephane Castellani:**

> Thank you for your valuable feedback. We apologize for any inconvenience you experienced during this workshop. The team did their best to fix this temporary issue when it occurred and we hope the rest of the session could run smoothly. We are glad you found the product easy to use and intuitive. If you have any further feedback or suggestions for improvement, please feel free to share them with us. Your input is valuable in helping us enhance our workshops.

  ### 10. Simple and fast

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Gambling & Casinos | Mid-Market (51-1000 emp.)

**Reviewed Date:** February 29, 2024

**What do you like best about CrateDB?**

Scalability and ease of use
Very fast for time-series data
Supportive community

**What do you dislike about CrateDB?**

I haven't faced any yet as I utilize it for pretty simple cases.

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

Analyzing of huge amount of time-series logs and building dashboards

  ### 11. CrateDB - A versatile database.

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.)

**Reviewed Date:** January 08, 2023

**What do you like best about CrateDB?**

1. Database can be automatically scaled and partitioned as per the data volume. Also, data rebalancing is done automatically by Crate.
2. Good for big datasets as it is scalable, unlike relational databases, and suitable for accessing real-time data like time-series databases.
3. Useful to process both structured and unstructured data.
4. Using the queries utilises optimal memory from the system and hence is more efficient.

**What do you dislike about CrateDB?**

The UI access for CrateDB could be improved as currently there are two options: HTTP end-point and PostgreSQL wire protocol. An application type of interface would be better to connect to the database, as with MySQL.

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

CrateDB helps store relational and non-relational types, making it one of the more versatile databases in the market. Also, bulk data can easily be managed as it scales as per the size of the data. Querying is easy and does not overload the system to fetch results.

  ### 12. Easy creation cluster i like it

**Rating:** 4.5/5.0 stars

**Reviewed by:** Emre A. | Software engineer, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

Creating without time loss
You keep focus on your structure is the best hing. 
When i fisrt use i very impressed without any bullshit use create and deploy somehow is make great

**What do you dislike about CrateDB?**

Some typing and some ux stuff but i am pretty new. 
Maybe needs adding good tutorial. 
Maybe afding needs some migration explanation guide to new user ll be very nice.

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

I dont have time for setup or db i want to focus on my product an this tools make this happened i am pretty sure to creating mvp needs this tool. Use it focus customer

  ### 13. An amazing Database management system - with real-time analytics

**Rating:** 5.0/5.0 stars

**Reviewed by:** Osama A. | Cybersecurity Specialist, Computer & Network Security, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

CrateDB provides enhanced and real-time performance, which means you can query and manage databases in real time, which is something traditional SQL doesn't provide. Also, CrateDB provides simple SQL access and scalability - which increases efficiency.
It also comes with a comprehensive set of performance monitoring tools and allows for optimized cybersecurity analyzes.

**What do you dislike about CrateDB?**

Integration and deployment of CrateDB were a little complex at first and technical support would be delayed in answering our inquiries. (although, to be fair, we did ask many questions).

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

Performing secure analyzes (in real-time) of our data with speedy queries and guaranteed service. All the while increasing the allowable data volume, which reflected positively on the performance of our system.

  ### 14. Easy to use

**Rating:** 3.5/5.0 stars

**Reviewed by:** Bhavesh B. | ServiceNow Developer, Enterprise (> 1000 emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

CreateDB is really easy to use application. When you first Lear the basic of database then while using new application you have to change or upgrade your skill. However it is really helpful to use it's commnads and merging tables and sort the data.

**What do you dislike about CrateDB?**

For new developer is it hard to understand the terminology so if there are hints present it will be better to use. Also there needs more forum and discussion regarding this application.

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

It is really helpful to use it's commnads and merging tables and sort the data. For data sorting it is very useful and also we can use commnads more easily and try different things.

  ### 15. Great tool for managing large scale databases

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Building Materials | Mid-Market (51-1000 emp.)

**Reviewed Date:** October 20, 2022

**What do you like best about CrateDB?**

The analytics you can pull from complex databases was second to none. Very useful tool when combing through databases to help drive our in house marketing efforts and give data to the outside sales teams.

**What do you dislike about CrateDB?**

The integrations for this could be more robust, would be great if this could integrate to more CRM's including Zoho and salesforce. This would help opitmize the data driven from the tool to then drive marketing campaigns and other efforts within the CRM.

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

We used this tool to analyze all the construction permits being pulled throughout the US. The sales teams could then drill down to understand where construction was happening most within the US and then further understand where the opportunities for commercial construction landed.

  ### 16. Nice S/W with good Ui

**Rating:** 5.0/5.0 stars

**Reviewed by:** Kumar s. | Software Associate, Enterprise (> 1000 emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

It is good s/w with nice user interface
It never lags. It's very easy to write db operations using this product

**What do you dislike about CrateDB?**

Some times it happens it lags, may be multiple users are using at same time. We can enhance its stability by making its more stable versions with multiple servers

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

It helps in writing db query in very efficiently.
Storing data also in very securely.

  ### 17. CrateDB a single place to store all data

**Rating:** 4.5/5.0 stars

**Reviewed by:** Sharada B. | Software Engineer, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 02, 2022

**What do you like best about CrateDB?**

The concept of run anywhere and everywhere is really helpful in today's world of hybrid technology. It's highly scalable

**What do you dislike about CrateDB?**

Need more tutorials to understand the feature in depth for beginners

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

It's really helpful by using its commands to store the data. Easy setup in the machines

  ### 18. Need improvment

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Accounting | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 20, 2022

**What do you like best about CrateDB?**

Tool UI is vert fast and its intitutive. I recommend this for beginners. Good one to go during starting phases. Also the menu interfaces are freat and helps in learning

**What do you dislike about CrateDB?**

Tool is very slow and need lots of improvement. Many times tool hangs and gives wrong messages and is not able to understand easily. For sure needs improvement here

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

Solving all DB related. Helps on creating queries easily and also there are some automates click, that helps user to write it quickly. Better one overall if i say

  ### 19. Great tool for Real time analytics

**Rating:** 4.5/5.0 stars

**Reviewed by:** Juan  R. | Marketing Consultant, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

Easy of use and great features to use the product

**What do you dislike about CrateDB?**

None so far. data insights are very important to my client and we are finding that the product fits well

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

Being able to create a SQL database for real-time analytics in our labs may solve issues that we need to solve

  ### 20. very efficient and straight forward service

**Rating:** 3.5/5.0 stars

**Reviewed by:** Dennis M. | Information Systems consultant, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 25, 2022

**What do you like best about CrateDB?**

improved security and implicit data sharing. I also like increased productivity on the app

**What do you dislike about CrateDB?**

damages to the platform affect virtually all programs that are related to the DB

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

crate has helped me solve the problem of better decision making as well as consistent data

  ### 21. Excellent open-source system for database management

**Rating:** 4.5/5.0 stars

**Reviewed by:** 💡 Alberto P. | 📌 Equipo de Diseño Gráfico Creativo y Edición de Vídeos de Calidad, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 23, 2022

**What do you like best about CrateDB?**

The best thing is its simplicity and ease of integration, in addition to the open source that gives us freedom.

**What do you dislike about CrateDB?**

They could improve customer service, in relation to the tool it works perfectly.

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

Open system for database management, excellent tool

  ### 22. Excellent Cloud SQL DB

**Rating:** 4.0/5.0 stars

**Reviewed by:** Aidan A. | Technical Consultant, Small-Business (50 or fewer emp.)

**Reviewed Date:** October 18, 2022

**What do you like best about CrateDB?**

I value the pricing over competitors like CockroachDB, and MongoDB Atlas for similar amounts of data stored and retrieved.

**What do you dislike about CrateDB?**

The documentation is lacking in real world examples, just alot of technical applications.

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

No risk of data loss from project databases, at an affordable price.

  ### 23. Go-To DB to analyze vast machine data in real-time!!

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.)

**Reviewed Date:** October 19, 2022

**What do you like best about CrateDB?**

Offers execution of geospatial queries using geo-point & geo-shape types!
Offers easy integrated search capabilities for data and sql query versatility.
Supports Container architecture with 
automatic data sharing for scalability.
Supports fast & complex cybersecurity data analyses.
Can be configured  in high availability mode with automatic replication & self-healing capacity.

**What do you dislike about CrateDB?**

I've got everything I needed to accomplish my use-case using CrateDB.

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

We've used it for huge dataset storage and analysis within real-time.

  ### 24. Useful DB management tool

**Rating:** 5.0/5.0 stars

**Reviewed by:** Mallikarjuna K. | Sr. Customer Success Lead, E-Learning, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 27, 2022

**What do you like best about CrateDB?**

Very easy to create the sql quer, and can be easily fetch the data.

**What do you dislike about CrateDB?**

Compared to other sql tools, this is best.

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

Time saving, easy to manage the data.

  ### 25. Best database management system

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 23, 2022

**What do you like best about CrateDB?**

Best database management system with more efficient in memory and storage. Provides the real time response with high data volume.

**What do you dislike about CrateDB?**

As of now nothing to dislike about CrateDB

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

Easy to store and analyse large amount of data. We can easily analyse data in real time. Easier to scale. Gives the best results when operated in multi node cluster

  ### 26. Good solution

**Rating:** 3.0/5.0 stars

**Reviewed by:** Armen N. | Chief Marketing Officer + GM of Threat Research , Small-Business (50 or fewer emp.)

**Reviewed Date:** October 20, 2022

**What do you like best about CrateDB?**

flexibility and control are strong, easy to use

**What do you dislike about CrateDB?**

Database configuration challenges abound

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

Fast database configuration

  ### 27. Crate db review

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 22, 2022

**What do you like best about CrateDB?**

It's very easy to use and handle..it takes very less time to create the db

**What do you dislike about CrateDB?**

It needs to have some more migration explanation guide.would have more creative and neat UX

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

It benefits in retrieving data faster  and test search is very helpful. Performance is better when compares to other Nosql engines.

  ### 28. Good Database for lightweight projects

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 27, 2022

**What do you like best about CrateDB?**

CrateDb offers typical features any Database should support, such as indexing

**What do you dislike about CrateDB?**

CrateDB could use better scaling features such as database sharding

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

Using CrateDB in small scale projects at work, it runs well with these types of projects. It also makes the team be more productive

  ### 29. Very Professional Implemented platform

**Rating:** 5.0/5.0 stars

**Reviewed by:** Limuel O. | Associate Unit Manager, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 04, 2021

**What do you like best about CrateDB?**

This is one of my favorite software because of its ease of use very ease to create a database, It can handle a massive amount of data, and it provides solutions in our database developers

**What do you dislike about CrateDB?**

It cost a lot when you're planning to store a large amount of database, and it has no proper tutorial for first-time users like us; it supports some SQL, but most of all, I like it as my primary database software

**Recommendations to others considering CrateDB:**

They should use JSON functions for a more reliable experience and support other SQL queries

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

The storing, fetching, and sorting of data is significantly less time consuming, and it can handle the massive volume of data somehow, and I'm astonished the platform can take that amount of data

  ### 30. Power of NoSQL in the form of SQL

**Rating:** 5.0/5.0 stars

**Reviewed by:** Ali R. | Software Engineer, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 04, 2021

**What do you like best about CrateDB?**

One of my favorite distributed SQL database with the scalability and flexibility of a NoSQL database, it also support ad-hoc queries using standard SQL syntax. Using it's cluster feature we can run thousands of records per second in real-time, and it's also easily integrable with containerization tools like kubernates, AWS and Azure. I highly suggest this for real-time big data project

**What do you dislike about CrateDB?**

Not much to say but needs to support triggers and contraints like native SQL

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

Primarily I am working on real-time big data projects, so it's very challenging to manage and retrieve data fastly especially when searching is involve by using the text search capability of crateDB we can easily accomplish this task.

  ### 31. One of the good open source distributed nosql engine

**Rating:** 4.5/5.0 stars

**Reviewed by:** Mohan G. | Software Architecture, Mid-Market (51-1000 emp.)

**Reviewed Date:** February 16, 2022

**What do you like best about CrateDB?**

Distributed engine
SQL Support
Dynamic Schema support

**What do you dislike about CrateDB?**

Transaction Support
Help content is less in online

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

Performance is better compared to other NoSQL engines which we have tested. And It has a search engine and time series support. These all these features made us choose CrateDB.

  ### 32. Process Data Fastly

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 30, 2021

**What do you like best about CrateDB?**

CrateDb is one of my favorite Database management systems. It is very fast in processing data as compared to other relational database management systems I have used. It is easy to create databases in CrateDb.

**What do you dislike about CrateDB?**

I do not dislike any thing about CrateDb.

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

I am a software engineer, and I always work on databases and programming languages  . I used "CrateDb" to design schemas and develop databases for storing the data and fetching the data within less time as compared to other software which are used for the same purpose.
The main benefit that I have using CrateDb is that it saves my time.

  ### 33. CrateDB is the best open source SQL database for real-time analytics.

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.)

**Reviewed Date:** June 07, 2018

**What do you like best about CrateDB?**

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 about CrateDB?**

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 CrateDB:**

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

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

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.

  ### 34. CrateIO brings the power of SQL and NoSQL

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** June 14, 2018

**What do you like best about CrateDB?**

Version 2 of CrateDB features new authorization tools, Also they improved monitoring dashboard and support for user-defined functions which makes your real-time database more powerful than before.

**What do you dislike about CrateDB?**

There is no enough tutorials out there that teaches your how to properly setup your database and integrate it with other apps.

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

Its a great way to track your sensor data as i used it in many of my hardware projects and it did really great in terms of speed. Also you can perform queries in real-time and the results are fascinating. 

  ### 35. No one mixed SQL database with No SQL before!

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.)

**Reviewed Date:** June 03, 2018

**What do you like best about CrateDB?**

I have never seen this speed in SQL queries before that happens in real time.

**What do you dislike about CrateDB?**

It needs a very powerful and reliable database which costs a lot of money. 

**Recommendations to others considering CrateDB:**

CrateIO is different, believe me mixing between SQL and NoSQL makes difference in performance that SQL or NoSQL alone can't make.

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

Their fast search which happens in real time while you have tons of data is insane.This makes a huge difference in user experience in web or mobile applications.



- [View CrateDB pricing details and edition comparison](https://www.g2.com/products/cratedb/reviews?page=2&section=pricing&secure%5Bexpires_at%5D=2026-07-22+03%3A52%3A52+-0500&secure%5Bsession_id%5D=d51c7d9e-b080-4264-b6a1-e23b8509af57&secure%5Btoken%5D=0fab9920045858315b70a4ed2e6d432a33b5a65dbc4786eb347a3c71859135c6&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 (708 reviews)
  - [MongoDB Atlas](https://www.g2.com/products/mongodb-atlas/reviews) - 4.5/5.0 (848 reviews)
  - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (931 reviews)

