sqlalchemy-vertica-python

What it is and what it does

This package bridges SQLAlchemy and Vertica by implementing a SQLAlchemy dialect that uses vertica-python, a pure-Python DB-API driver. It allows you to use SQLAlchemy's ORM and expression language to query and manipulate Vertica databases without needing ODBC or other system-level drivers. The package was forked from an earlier ODBC-based dialect and is maintained by BlueLabs.

You create a Vertica engine by specifying a connection URL with the vertica+vertica_python scheme, then use standard SQLAlchemy patterns to define tables, run queries, and manage transactions. The documentation notes a quirk: Vertica sequences must be explicitly declared for primary keys rather than relying on auto-increment, since direct ID insertion will fail.

Use it for:

• Build Python applications that query Vertica using SQLAlchemy's ORM without installing ODBC drivers.
• Migrate from other databases to Vertica while keeping SQLAlchemy code largely unchanged.
• Run data pipelines that read from or write to Vertica using SQLAlchemy expressions and bulk operations.
• Integrate Vertica into web frameworks that use SQLAlchemy for database abstraction.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a SQLAlchemy dialect for Vertica using the pure-Python vertica-python driver, enabling ORM and SQL expression language access to Vertica databases.

Yes, if you are already committed to Vertica and SQLAlchemy and can tolerate dormant maintenance. The package is stable and has no known vulnerabilities, but expect no active support or updates. Verify that vertica-python itself meets your needs and that the dialect works with your target SQLAlchemy and Vertica versions before adopting it for new projects.

Install

sqlalchemy-vertica-python on PyPI

pip install sqlalchemy-vertica-python

uv add sqlalchemy-vertica-python

poetry add sqlalchemy-vertica-python

Installing sqlalchemy-vertica-python

Before you install

Low install friction with a single pure-Python runtime dependency. Maintenance is dormant—last commit was 2023-12-19 and no releases in over a year—so expect no active bug fixes or feature updates, though the repository remains unarchived.

License in practice

MIT license permits commercial and private use with minimal restrictions, making it safe for most projects that can tolerate dormant maintenance.

Quickstart

pip install sqlalchemy-vertica-python

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

Requires vertica-python to be installed and a running Vertica database instance accessible at the specified host and port.

Verify before relying

• Whether vertica-python itself is actively maintained and compatible with modern Vertica server versions.
• Whether the dialect works reliably with SQLAlchemy versions released after 2023-06-05.
• Current compatibility with Python versions beyond 3.8 (classifiers list only up to 3.8).

Package facts

Evidence: sqlalchemy_vertica_python-0.6.3-py3-none-any.whl

Keywords: sqlalchemy, vertica, python

Tags

More Front-Ends packages