Install & Compatibility
Where this runs
tested against v1.6.1 · pip install
no network on importno background threads
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
muslpy 3.10–3.95 runs
installs and imports cleanly · install 0.0s · import 0.000s · 24.3MB
glibcpy 3.10–3.95 runs
installs and imports cleanly · install 4.2s · import 0.000s · 21MB
20MB installed
● package 20MB
Code
Verified usage
Verified import paths — ran on the pinned version, not inferred.
VerticaPipe
✓ import pyvertica
✗ from pyvertica import VerticaPipe
Basic batch insert using VerticaPipe and parameterized queries.
from pyvertica import VerticaPipe
import os
conn_params = {
'host': os.environ.get('VERTICA_HOST', 'localhost'),
'port': 5433,
'user': os.environ.get('VERTICA_USER', 'dbadmin'),
'password': os.environ.get('VERTICA_PASSWORD', ''),
'database': os.environ.get('VERTICA_DB', 'vdb')
}
with VerticaPipe(**conn_params) as pipe:
pipe.executemany(
"INSERT INTO test_table (id, name) VALUES (:1, :2)",
[(1, 'Alice'), (2, 'Bob')]
)
pipe.commit()
Upgrade
Version history
1.6.1latest on PyPI · released Jan 9, 2014
Audit
Dependencies
psycopg2requiredRequired for database connection to Vertica via its PostgreSQL compatibility layer