v:latest

CrateDB Python Client

A Python client library for CrateDB.

This client library implements the Python Database API 2.0 specification, which defines a common interface for accessing databases in Python.

A CrateDB dialect for SQLAlchemy is also included.

Note

This is a basic CrateDB driver reference.

Check out the sample application (and the corresponding documentation) for a practical demonstration of this driver in use.

For general help using the Python Database API or SQLAlchemy, please consult PEP 0249, the SQLAlchemy tutorial, or the SQLAlchemy documentation.

See also

The CrateDB Python client library is an open source project and is hosted on GitHub.

Table of contents

• Getting started
  • Prerequisites
  • Install
  • Interactive use
  • Set up as a dependency
  • Next steps
• Connect to CrateDB
  • Connect to a single node
  • Connect to multiple nodes
  • Connection options
  • Authentication
  • Schema selection
  • Next steps
• Query CrateDB
  • Using a cursor
  • Inserting data
  • Selecting data
  • Accessing column names
• Blobs
  • Get a blob container
  • Working with the blob container
• Using the SQLAlchemy dialect
  • Connecting
  • Tables
  • Querying
• Appendices
  • Data types

Feedback

How helpful was this page?

5 stars 4 stars 3 stars 2 stars 1 star

Submit

New issue Edit on GitHub View on GitHub