CrateDB

Additional features

Unified Data Layer

Serves as a single platform for analytics, search, and AI.

Real-Time Ingest to Insights

Processes data from ingestion to actionable insights in real-time.

Real-Time Data Insights

Provides immediate access to data for rapid decision-making.

Turbocharged Aggregations

Runs ad-hoc queries on billions of records in milliseconds using columnar storage.

Hybrid Search Powered by Lucene

Enables full-text, geospatial, vector similarity, and combined searches via a distributed SQL query engine built on Apache Lucene.

Seamless AI Model Integration

Allows effortless integration of AI models for storing, searching, and querying vectors, supporting real-time training and predictions.

Dynamic Schema and Indexing

Automatically adapts to evolving data types and schema changes with dynamic optimization of indexing.

Built for Scale and Resilience

Manages massive data volumes (millions to petabytes) with high-speed performance and a fault-tolerant, distributed architecture.

Enhanced Developer Productivity

Offers native SQL for simple queries and quick onboarding.

Multi-Model Data Support

Analyzes relational, JSON, time-series, geospatial, full-text, and vector data within a single system.

PostgreSQL Compatibility

Ensures easy integration with third-party tools like Grafana and Tableau.

Vector Store

Seamlessly integrates with AI/ML tools and LangChain, offering flexibility in choosing LLMs and embedding algorithms.

Open-Source Licensing Model

Provides freedom from vendor lock-in and support from a growing developer community.

Time-Series Data Support

Handles complex analytics on rapidly increasing time-series datasets.

JSON Data Support

Efficiently stores and queries JSON data.

Vector Data Support

Manages and queries vector embeddings.

Text Data Support

Handles full-text search capabilities.

Geospatial Data Support

Supports geospatial data and queries.

Streamlined Operations

Offers a cost-efficient, robust, and scalable architecture.

Eliminates Database Combinations

Reduces overhead by removing the need to combine and synchronize different databases.

High Availability

Ensures data safety and accessibility with automatic failover, recovery, and replication.

Resilient Architecture

Detects failures and maintains cluster health in distributed environments.

Multiple Deployment Models

Offers DBaaS (Database-as-a-Service), hybrid cloud, and self-managed options.

Edge Deployment

Supports deployment in environments with limited connectivity.

Scalability from Prototype to Production

Seamlessly scales from single-laptop prototypes to dozens of servers with terabytes of data.

Distributed Query Engine

Distributes queries across the whole cluster for efficient execution.

Continuous Optimization

The database evolves continuously to enhance AI-driven workflows.

Automatic Query Distribution

Distributes queries automatically across the cluster.

Horizontal Scalability

Allows adding nodes to scale the system easily.

DBaaS (CrateDB Cloud)

Fully managed service operated by CrateDB engineers, deployable on AWS, Azure, or Google Cloud.

Cloud Native

Designed for cloud environments.

Automation (Cloud)

Includes SQL Scheduler, table policies, and logging.

Embedded Query Console (Cloud)

Provides a web-based interface for queries.

Connectors to Import Data (Cloud)

Connectors for on-demand or real-time data ingestion.

CrateDB Cloud CLI

Programmatically creates and manages deployments.

Automatic Backup (Cloud)

Ensures data safety with automated backups.

SOC 2 Type 2 Compliant

Adheres to security compliance standards on Azure and AWS.

Data Encryption

Encrypts data for security.

Authorization

Manages user permissions.

Auditing

Logs user activity for accountability.

ISO 27001 Certification

Adheres to information security management standards.

Support Plans

Offers Standard or Premium support plans with contractual SLAs.

Dedicated Customer Success Manager

Provides personalized assistance for critical workloads.