v:latest

CrateDB Python Client

A Python client library for CrateDB.

This client library implements the Python Database API Specification v2.0 (PEP 249), which defines a common interface for accessing databases in Python.

It also includes the CrateDB dialect for SQLAlchemy.

Note

This is a basic CrateDB driver reference.

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

For general help using the Python Database API or SQLAlchemy, please consult PEP 249, 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
  • Data type conversion
  • Custom data type conversion
  • TIMESTAMP conversion with time zone
• Blobs
  • Get a blob container
  • Working with the blob container
• SQLAlchemy support
  • Introduction
  • Connecting
  • Tables
  • Querying
• By example
  • About
• 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