CrateDB Documentation¶
Welcome to the official CrateDB Documentation. Whether you are a developer, database administrator, or just starting your journey with CrateDB, our documentation provides the information and knowledge needed to build real-time analytics and hybrid search applications that leverage CrateDB’s unique features.
Benefits
In a unified data platform approach, CrateDB includes analyzing relational, JSON, time-series, geospatial, full-text, and vector data within a single system, eliminating the need for multiple databases.
The fully distributed SQL query engine, built on top of Apache Lucene, and inheriting technologies from Elasticsearch/OpenSearch, provides performant aggregations and advanced SQL features like JOINs and CTEs on large datasets of semi-structured data.
Real-time indexing automatically indexes all columns, including nested structures, as data is ingested, eliminating the need to worry about indexing strategy.
The flexible data schema dynamically adapts based on the data you ingest, offering seamless integration and instant readiness for analysis.
Columnar storage enables fast search query and aggregation performance.
PostgreSQL wire protocol compatibility and a HTTP interface provide versatile integration capabilities.
AI-ready: The vector store subsystem integrates well with an extensive 3rd party ecosystem of AI/ML frameworks for advanced data analysis and data-driven decisions.
Start with a fully managed CrateDB instance to accelerate and simplify working with analytical data. CrateDB Cloud enables seamless deployment, monitoring, backups, and scaling of CrateDB clusters on AWS, Azure or GCPs, eliminating the need for direct database management.
With CrateDB Cloud, you can skip infrastructure setup and focus on delivering value for your business with a query console, SQL Scheduler, table policies and various connectors to import data.
Explore all functional, operational and advanced features of CrateDB at a glance.
Learn core CrateDB concepts, including data modeling, querying data, aggregations, sharding, and more.
Learn how to connect your applications using database drivers, libraries, adapters, and connectors.
CrateDB supports both the HTTP protocol and the PostgreSQL wire protocol, ensuring compatibility with many PostgreSQL clients.
Through corresponding drivers and adapters, CrateDB is compatible with ODBC, JDBC, and other database API specifications.
Learn¶
Introduction
Learn about the fundamentals of CrateDB, guided and self-guided.
Getting Started
The CrateDB Guide
Academy Courses
Community Portal
Database Clients and Tools
Learn about the fundamental tools and utility programs that support working directly with CrateDB.
Drivers and Integrations
Learn about database client libraries, drivers, adapters, connectors, and integrations with 3rd-party applications and frameworks.
Examples¶
Learn how to use CrateDB by digesting concise examples.
Resources: Academy • Blog • Community • Customers • Examples • GitHub • Guide • Support