Welcome Rockset Developers¶
Introduction
Because the Rockset HTTP API is sunsetting on September 30th, 2024, and CrateDB covers a reasonable amount of features, this page presents its capabilities to support your analytical workloads and data consolidation efforts.
Both Rockset and CrateDB use SQL, so there is no need for your teams to learn a new query language or querying regime.
Details
When it comes to real-time analytics and hybrid search, CrateDB is the only solution that offers a similar approach to converged indexing, full-text search, vector search, and geospatial support in a single storage engine, accessible via native SQL and HTTP endpoints.
Because CrateDB is truly open-source software with a clear commitment, you will no longer find yourself in vendor lock-in situations and service shutdowns due to M&A procedures and similar occasions, being forced to migrate to a different system once again.
As we work with more and more companies looking to migrate their workloads from Rockset to CrateDB, we have built expertise on the details of what a migration entails. This page shares a few insights on this topic, and why CrateDB is your go-to choice when selecting a cost-effective replacement solution.
Watch our Webinars
Why CrateDB is a perfect [Rockset] replacement for real-time analytics and hybrid search.
How CrateDB compares to [Rockset] and Elasticsearch/OpenSearch for streaming ingest.
Why CrateDB is a cost-effective alternative to [Rockset].
What’s Inside¶
Introduction and Comparison
An overview about CrateDB, and a side-by-side comparison, tuned for Rockset users.
Why CrateDB is a perfect Rockset replacement
Learn about the top five reasons for choosing CrateDB as a Rockset replacement.
Converged index aka. automated indexing.
Fully-featured SQL and HTTP interface.
Support for structured, semi-structured, and unstructured data.
Support for real-time streaming and updates.
CrateDB is fully open source and deployment-agnostic.
CrateDB vs. Rockset
Features
Blog
Performance Matters
Insights into how ingest performance compares between Rockset and CrateDB.
We used the Rockbench benchmark to evaluate ingestion performance on throughput and data latency. The results are impressive.
CrateDB outperforms Rockset on the same hardware while saving between 20% and 60% on costs.
CrateDB achieves 6-9x lower latencies than Rockset for streaming ingest. When data volume increases, the latency increased linearly in Rockset, while remaining mostly flat in CrateDB.
CrateDB vs. Rockset
Performance
Blog
Cost Matters
Based on Rockset’s pricing examples, we combined the experience of real-world customer projects as well as Rockbench benchmark runs, to compare the costs for multiple scenarios.
Examples: A geospatial search application for logistics tracking, a recommendation engine, a backend for in-app search and analytics, a backend for real-time game telemetry, and an anomaly detection application.
CrateDB vs. Rockset
Costs
Blog
Features and Benefits
CrateDB’s benefits and principles in a nutshell.
Fundamentals
CrateDB is a scalable and cost-effective real-time analytics database, combining complex JSON handling, time series, geospatial data, full-text search, and vector search in one single storage engine.
Foundation
Built on top of Apache Lucene and Elasticsearch, CrateDB automatically indexes all your data in exactly the same way as Rockset’s Converged Index™, in order to achieve millisecond response times for any kind of query and aggregation workloads.
Availability
CrateDB is offered as a managed service available on AWS, Azure, and GCP, and also as a fully open source edition.
No vendor lock-in and service sunsetting woes.
No capacity limits.
See CrateDB Cloud and CrateDB Editions.
Interoperability, Open Source, Open Standards
Rockset is a proprietary solution available as a managed service in AWS only.
With CrateDB, you leverage open standards to avoid vendor lock-in and future-proof your systems.
CrateDB’s open-source code base accepts contributions from community members and corporates, so you can easily add features you need, and distribute them to downstream users in multiple ways, without any licensing hassles.
Development and Embedding
The attributes enumerated above allow you to integrate CrateDB into your products seamlessly, and supply your engineers and continuous integration systems with dedicated instances of CrateDB, instead of needing to run them against a cloud-only service, which is slowing down development, mostly due to API rate-limiting measures.
Learn¶
Learn how to use CrateDB.
SQL Query Language
CrateDB’s lingua franca is SQL, ready for big data, very similar to Rockset’s SQL dialect.
Migrating queries from Rockset to CrateDB
Because both Rockset and CrateDB use SQL, there is no need for your teams to learn a new query language. There are a few differences in the SQL dialect, where we provide relevant support information to make transitioning easier.
Integrate¶
Learn how to migrate your database use cases and workloads from Rockset to CrateDB.
Migrating data using AWS DMS
Migrating data from DynamoDB to CrateDB
Migrating data from MongoDB to CrateDB
General I/O
Data loading with CrateDB.
Change Data Capture (CDC) with CrateDB.
Integrating data from other sources into CrateDB
With Rockset, as a complete data warehouse system, integrating data from other sources is a nobrainer, and provides exceptional UX/DX.
CrateDB offers a wide range of integration capabilities, is compatible with the PostgreSQL wire protocol, and offers adapter components to integrate with applications and frameworks.
Integrating CrateDB technologies into Rockset-based infrastructure
The Rockset HTTP API Adapter for CrateDB is an experiment to provide CrateDB’s features through an API that is compatible with the Rockset HTTP API, so client programs and libraries can work unmodified.
It has been verified to work for the most basic API calls with plain HTTP requests using curl or HTTPie, the Rockset CLI, and Java, JavaScript, and Python example programs.