Skip to main content

Vertica dialect for sqlalchemy

This module implements a Vertica dialect for SQLAlchemy. You can use it:

>>> import sqlalchemy as sa
>>> sa.create_engine(sa.engine.url.URL(
    drivername='vertica+pyodbc',
    username='myusername',
    password='mypassword',
    host='hostname',
    database='dbname',
))

This work is mainly a package of code [posted](https://groups.google.com/d/msg/sqlalchemy/ttJzN-t9R74/9W1d9KfHK_0J) to the SQLAlchemy mailing list by ‘Bo’ (Google groups won’t let me see the original author).

I have tested this for table introspection, selects and joins. However, I do not have access to a Vertica database to test against. If you do, let me know.

The primary, foreign and index constraints return nothing. This is because I’m told these are ‘enforced on select’. Maybe a Vertica expert can tell me the correct way to handle this.

Installation

With pip

pip install vertica-sqlalchemy

From git:

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

Metadata

Release files for vertica-sqlalchemy 0.13

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for vertica-sqlalchemy 0.13
File Size Uploaded
vertica-sqlalchemy-0.13.tar.gz 3.4 kB Details

Release files / vertica-sqlalchemy-0.13.tar.gz

Download URL vertica-sqlalchemy-0.13.tar.gz
Size 3.4 kB
Tags Source
SHA-256 checksum
How to use checksums
a94280e3914cd1058211b801990a53fe6e41edcdcea672b4dcd021816cb5363a
BLAKE2b-256 checksum
How to use checksums
45be10b23333c6cfa04f439c5b1d1cb9dde21a9a0480d5c6748fcef729766149
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

0.13 This release

1 release file

0.1

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page