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.
Webinar
From Rockset to CrateDB
Why Choose CrateDB as a Rockset replacement?
Unmatched Performance:
- Real-time indexing of all data without compromising speed.
- 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;
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.
Resources
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.
Yes, CrateDB supports three search functions: kNN search via KNN_MATCH, bm25 search via MATCH, and geospatial search via MATCH which can be combined for Hybrid Search to achieve better accuracy and relevancy than each algorithm would individually.
Yes. We can support you with automated data migration from MongoDB, DynamoDB, S3, or any other product.
Yes, you can achieve the same functionality by using views and HTTP endpoint.