Sign in to see all reviews and comparisons. It's Free!
CrateDB is a distributed SQL database built on top of a NoSQL foundation. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL, enabling developers to: Use SQL to process any type of data, structured or unstructured.
• Dynamic schemas: Add columns anytime without slowing performance or downtime • Geospatial queries: Store and query geographical information using the geo_point and geo_shape types • SQL with integrated search for data and query versatility • Container architecture and automatic data sharding for simple scaling • Indexing optimizations enable fast, complex cybersecurity analyses • Performance-monitoring tools
Contact for Pricing
Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)
What is best?
• Geospatial queries: Store and query geographical information using the geo_point and geo_shape types • SQL with integrated search for data and query versatility • Container architecture and automatic data sharding for simple scaling • Indexing optimizations enable fast, complex cybersecurity analyses • Performance-monitoring tools
What are the benefits?
• Transactional: Allows synchronous real-time access to single records, immediately after they are written • Scalable: Automatically shards and redistributes data across the cluster as it changes size to optimize performance • Real-time speed: Distributed, columnar field caches enable in-memory SQL query performance • Built-in high availability: Automatic replication & self-healing for non-stop performance
Aggregated User Rating
Ease of use
Features & Functionality
Renew & Recommend
CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.
Aggregated User Rating
You have rated this
CrateDB is a distributed SQL database built on top of a NoSQL foundation. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL, enabling developers to: Use SQL to process any type of data, structured or unstructured; Perform SQL queries at real time speed, even JOINs and aggregates and scale simply. CrateDB’s distributed SQL query engine features columnar field caches, and a more modern query planner. These give CrateDB the unique ability to perform aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. CrateDB also integrates native, full-text search features, which enable users to store and query structured or unstructured data together. Automatic replication of data across the cluster and rolling software updates help ensure hardware failures and scheduled maintenance do not interrupt access to data. In addition, CrateDB clusters are self healing, so when nodes are added to the cluster, CrateDB automatically loads them with data. Analytic data is often loaded in batches, with transactional locks and other overhead. By contrast, CrateDB eliminates locking overhead to enable massive write performance (e.g. 40.000+ inserts per second per node on commodity hardware). Furthermore, CrateDB can deliver millisecond-speed query performance, even when writes are in action. All nested JSON attributes can be included in any SQL command. CrateDB makes time series analysis fast and easy with automatic table partitions, which are like virtual tables that can be queried, moved or deleted. Partitioning data by time intervals delivers very fast time series query performance. It offers Optimistic Concurrency Control by providing an internal versioning that allows detection and resolution of write conflicts.
Every day, thousands of potential buyers including CEO's, CIO's, Directors, and Executives use PAT RESEARCH.
PAT RESEARCH is a B2B discovery platform which provides Best Practices, Buying Guides, Reviews, Ratings, Comparison, Research, Commentary, and Analysis for Enterprise Software and Services. We provide Best Practices, PAT Index™ enabled product reviews and user review comparisons to help IT decision makers such as CEO’s, CIO’s, Directors, and Executives to identify technologies, software, service and strategies.