CrateDB Ecosystem Catalog¶

Database drivers, libraries, frameworks, and applications for CrateDB.

About CrateDB

CrateDB is a distributed and scalable open-source SQL database based on Lucene, with PostgreSQL compatibility. CrateDB clusters store information in the range of billions of records, and terabytes of data, and run analytics in near real time, even with complex queries. CrateDB can be used for enterprise data warehouse workloads, it works across clouds and scales with your data.

Connectivity¶

The canonical set of database drivers, client- and developer-applications, and how to configure them to connect to CrateDB.

Just to name a few, the sections below are about the CrateDB Admin UI, the Crash CLI terminal program, connecting with PostgreSQL’s psql client, the DataGrip, and DBeaver IDE applications, the Java/JDBC/Python drivers, the SQLAlchemy and Flink dialects, and more.

IDE

Connect to CrateDB using a database IDE like DataGrip or DBeaver.

Database IDEs

CLI

Connect to CrateDB using command-line based terminal programs.

Using command-line programs with CrateDB

Drivers

List of HTTP and PostgreSQL client drivers, and tutorials.

Connect to a CrateDB cluster

ORM Libraries

Connectivity with ORM libraries like SQLAlchemy.

CrateDB and ORM libraries

DataFrame Libraries

Connectivity with DataFrame libraries like pandas and Dask.

CrateDB and DataFrame libraries

Integrations¶

CrateDB integrates with a diverse set of applications and tools concerned with analytics, visualization, and data wrangling, in the areas of data loading and export (ETL), business intelligence (BI), metrics aggregation and monitoring, machine learning, and more.

Overview

Learn how to use CrateDB with popular applications, frameworks, and tools. All on one page.

https://community.cratedb.com/t/overview-of-cratedb-integration-tutorials/1015

Programming Frameworks

Connectivity with open-source programming frameworks and libraries like Gradio, Plotly, or Streamlit.

Using Programming Frameworks with CrateDB

ETL

ETL applications and frameworks for transferring data in and out of CrateDB.

ETL with CrateDB

System Metrics

Integrations and long-term storage for systems monitoring tools like Prometheus and Telegraf.

Monitoring and Metrics with CrateDB

Data Visualization

Visualize information in your CrateDB cluster.

Visualize data in CrateDB

Business Intelligence

Analyze information in your CrateDB cluster.

Business Analytics and Intelligence with CrateDB

Machine Learning

Adapters and integrations with machine learning frameworks.

Machine Learning with CrateDB

Note

Contributions to the pages in this section and subsections are much welcome. If you would like to add items about integrations with other tools to this documentation section, please get in touch, or directly edit this page on GitHub. You will find corresponding links within the topmost right navigation element.