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¶
-
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.
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.