Feedback

  Suggest improvement

  Edit page

  View page source

Other connectivity options for Python

Introduction

Using the PostgreSQL wire protocol interface of CrateDB, there are a few other connectivity options for Python. This section enumerates the verified drivers, together with some example and test case code using them.

Details

• asyncpg, see testing CrateDB with asyncpg.

• psycopg2

  The CrateDB Astronomer/Airflow tutorials repository includes a few orchestration examples implemented using Apache Airflow DAGs for different import and export tasks, and for automating recurrent queries. It accompanies a series of articles starting with CrateDB and Apache Airflow » Automating Data Export to S3.

• psycopg3, see testing CrateDB with psycopg3.

• ODBC connectivity is offered by pyodbc and turbodbc, see testing CrateDB with pyodbc and using CrateDB with turbodbc.

• connector-x promises to be the fastest library to load data from DB to DataFrames in Rust and Python. It is the designated database connector library for Apache Arrow DataFusion.