Migrating from [Rockset] to CrateDB

Rockset is shutting down on the 30th of September. If you are looking for a real-time search and analytics database, we've got you covered. CrateDB is a distributed SQL database purposely built for real-time analytics across large datasets of structured and semi-structured data. Similarly to Rockset, CrateDB indexes all data in real-time (text, vector, geospatial, time-series, and JSON) for the most efficient search and fast ad hoc query execution at any scale. CrateDB is built on top of Apache Lucene and unlike Rockset, it is open-source

"We explored several solutions like Clickhouse, Rockset, Snowflake, among others. CrateDB is a great fit for us. Having a Cloud offer was perfect along with having the nested structure we were looking for."
 
David Sargeant Director of Software Engineering GovSpend Learn more
cr-quote-img-white

Live Webinar

From Rockset to CrateDB

Why Choose CrateDB as a Rockset replacement?

Unmatched Performance: 

  • Execute ad-hoc queries on hundreds of billions of records in milliseconds;
  • Combine Columnar and Row-Oriented Storage (with distributed inverted indexes and BKD trees) for optimal data retrieval and query performance;
  • Real-time indexing of all data without compromising speed.

Developer Experience and Scalability:

  • Utilize standard SQL and PostgreSQL Wire Protocol for easy onboarding and compatibility with 3rd party tools;
  • Object, time-series, geo, full-text, and vector data in one system;
  • Scale from a single node to petabytes of data across hundreds of nodes. 

Powerful Search:

  • Full-text Search: Utilize Lucene-powered full-text search for powerful data retrieval;
  • Geo Search: Execute precise spatial data queries;
  • Vector Search: Enhance your analytics and AI applications with advanced vector search capabilities.

Secure, Open Source, and Integrated:

  • Open Source: Transparent and flexible, leveraging a robust community;
  • Secure and Compliant: Ensuring data protection and regulatory compliance; 
  • Growing Ecosystem: Choose from a wide range of integrations for data ingestion, visualization, language clients, and more. 

CrateDB is deployed by hundreds of companies across the globe for their real-time analytics projects. 

 

Technical analysis, benchmarks and cost analysis on [Rockset] replacement

> Why CrateDB is a perfect [Rockset] replacement for real-time analytics and hybrid Search

   This article talks about:

  • Converged index aka automated indexing
  • Fully-Featured SQL and HTTP interface
  • Support for handling structured, semi-structured, and unstructured data
  • Support for real-time streaming and updates
  • CrateDB is fully open source and deployment-agnostic

> How CrateDB Compares to Rockset (and ElasticSearch/OpenSearch) for Streaming Ingest

   Key take-aways of this article are:

  • CrateDB outperforms Rockset on the same hardware while saving about 20% costs.
  • CrateDB achieves 6-9x lower latencies than Rockset for streaming ingest.
  • When volumes increase, the latency increases linearly in Rockset, while remaining mostly flat in CrateDB.

> CrateDB as a cost effective alternative to [Rockset]

   This article explains you can save 20% with CrateDB. 

 

FAQ

Yes, all your data can be migrated, CrateDB supports a variety of data types and structures.

CrateDB can easily integrate with a large ecosystem thanks to the Postgres Wire Protocol.

Yes, both Rockset and CrateDB use SQL as their native query language.

 

Want to know more? 

Book a meeting
Discuss your use case with our solution engineers