Skip to main content

Vertica dialect for sqlalchemy using vertica_python

Project description

Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect.

This module implements a Vertica dialect for SQLAlchemy using vertica-python. Engine creation:

import sqlalchemy as sa
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

Installation

From PyPI:

pip install sqlalchemy-vertica-python

From git:

git clone https://github.com/LocusEnergy/vertica-sqlalchemy
cd vertica-sqlalchemy
python setup.py install

Known Issues

  • Error handling is subpar. In particular, sqlalchemy attempts to raise a dbapi.Error, which vertica_python does not have. This can likely be fixed in the future by overriding some of the Default Dialect methods.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy-vertica-python-0.1.1.tar.gz (3.3 kB view details)

Uploaded Source

File details

Details for the file sqlalchemy-vertica-python-0.1.1.tar.gz.

File metadata

File hashes

Hashes for sqlalchemy-vertica-python-0.1.1.tar.gz
Algorithm Hash digest
SHA256 bc4aedcf0ae822dbf8a8976c8daaa662a61d7f83e431c0b57d241052b4f53dda
MD5 303132beb9fe06da39cb0df022dc3873
BLAKE2b-256 fb94c569674cede322f1e002e59eef9d504f8eb5a129b8ec40bed12c3ac5a733

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page