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…
Pricing
Shared S2
$53
Shared S4
$103
Shared S6
$153
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $53 per month
Product Demos
Fundamentals: Getting started with CrateDB
Introduction to CrateDB | Key Concepts, Architecture, and Live Demo
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is CrateDB?
- 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®​
- Standard SQL and PostgreSQL Wire Protocol for easy onboarding and tool compatibility​
- Relational, object, time-series, geo and full-text data can be analyzed
- 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 Integrations
CrateDB Competitors
CrateDB Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Mac, Docker |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews
Community Insights
- Business Problems Solved
- Pros
- Cons
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.