Skip to main content

Vertica dialect for sqlalchemy using vertica_python

Project description

Vertica dialect for sqlalchemy.

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 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.0.0.tar.gz (3.2 kB view details)

Uploaded Source

File details

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

File metadata

File hashes

Hashes for sqlalchemy-vertica-python-0.0.0.tar.gz
Algorithm Hash digest
SHA256 257cc1b8640532632913ef78444e9c7b7de1c3ac19891598a3bf7290705af365
MD5 2651312d2800471d825a9bcff5e98ac1
BLAKE2b-256 74c4657a0e0e9d10d360cf7b48c1eb2ff46ab247bb5b7405d4a906a351e9e19f

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