Skip to main content
TrustRadius
CrateDB

CrateDB

Overview

What is CrateDB?

CrateDB is an open-source, distributed SQL database for relational and time-series data, from Crate.io headquartered in San Francisco. A solution for machine data, the vendor states CrateDB is purpose-built for the need to scale volume, variety and velocity of data…

Read more
Recent Reviews

TrustRadius Insights

CrateDB has become a top choice for users looking for a performant NoSQL database engine. Users have reported having better performance …
Continue reading
TrustRadius

Leaving a review helps other professionals like you evaluate Open-Source Database Software

Be the first one in your network to review CrateDB, and make your voice heard!

Return to navigation

Pricing

View all pricing

Shared S2

$53

Cloud
per month

Shared S4

$103

Cloud
per month

Shared S6

$153

Cloud
per month

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://cratedb.com/product/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $53 per month
Return to navigation

Product Demos

Fundamentals: Getting started with CrateDB

YouTube

Introduction to CrateDB | Key Concepts, Architecture, and Live Demo

cratedb.com
Return to navigation

Product Details

What is CrateDB?

CrateDB is an open source distributed database running queries in milliseconds, whatever the complexity, volume and velocity of data. Users can store any type of data and combine the simplicity of SQL with the scalability of NoSQL.

Performance​

  • Ad-hoc queries​ can be run across 100s of billions of records in < 1 second​
  • Columnar storage for fast aggregations​
  • With fully distributed query engine on top of Apache Lucene®​

Ease of Use and Flexibility​

  • Standard SQL and PostgreSQL Wire Protocol for easy onboarding and tool compatibility​
  • Relational, object, time-series, geo and full-text data can be analyzed

Scalability and Reliability​

  • Scale from a single node to analyzing petabytes of data across hundreds of nodes in a cluster​
  • Built-in high availability and automatic failover​
  • Fully-managed Cloud, Hybrid and On-Premises (OSS)​

CrateDB Competitors

CrateDB Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Mac, Docker
Mobile ApplicationNo

Frequently Asked Questions

CrateDB is an open-source, distributed SQL database for relational and time-series data, from Crate.io headquartered in San Francisco. A solution for machine data, the vendor states CrateDB is purpose-built for the need to scale volume, variety and velocity of data while running aggregated complex real-time queries, anywhere and without driving up costs.

CrateDB starts at $53.

MongoDB, TimescaleDB, and InfluxDB are common alternatives for CrateDB.
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

CrateDB has become a top choice for users looking for a performant NoSQL database engine. Users have reported having better performance compared to other databases they've tested. The search engine and time series support are valuable features that lead users to choose CrateDB for their real-time big data projects. Thanks to the fast data retrieval and search capabilities, CrateDB has been a considerable asset in scenarios where speed is of the essence, such as tracking sensor data for hardware projects.

Software engineers designing schemas and developing databases have found CrateDB a handy tool that saves their time. Being effective in handling large volumes of data without significant performance degradation, users dealing with machine data for college or side projects find CrateDB to be an easy solution. Web or mobile applications that need to handle large amounts of data can benefit from CrateDB's fast search capabilities, allowing them to query terabytes of data in real-time, considerably improving user experience.

High scalability: Reviewers have consistently praised CrateDB's high scalability, with some stating that it is a highly scalable and flexible distributed SQL database. This feature allows it to handle large amounts of data in real-time, making it an excellent choice for real-time big data projects.

Real-time data processing: Many users have mentioned that CrateDB has impressive capabilities when it comes to handling thousands of records per second in real-time. They appreciate the speed at which SQL queries can be processed, making it an ideal choice for applications that require real-time data processing.

Flexibility with unstructured data: Several reviewers noted that CrateDB supports JSON and other structured and unstructured data types, making it more flexible than traditional relational databases. This feature enables applications to handle large amounts of messy and unstructured data efficiently.

Lack of Help Content: Some users have expressed frustration with the limited help content available online for transaction support and the lack of tutorials that teach how to properly set up a database and integrate it with other apps. This can be particularly challenging for new users who need guidance in getting started.

Limited SQL Support: Several reviewers have noted that CrateDB only supports basic SQL, which hinders its ability to take advantage of the relational model. For example, joins are not supported, making it difficult for users who want to use more complex SQL queries to manipulate their data.

Perceived Lack of Power and Reliability: A few users suggest that CrateDB is not very powerful or reliable compared to more expensive databases. They believe that a more robust solution may be needed to truly take advantage of the relational model.

Sorry, no reviews are available for this product yet

Return to navigation