{"id":24478,"library":"pyvertica","title":"pyvertica","description":"Tools for performing batch imports into Vertica. Current version 1.6.1, last released in 2015, maintained in low activity mode.","status":"maintenance","version":"1.6.1","language":"python","source_language":"en","source_url":"https://github.com/spilgames/pyvertica","tags":["vertica","batch","import","database"],"install":[{"cmd":"pip install pyvertica","lang":"bash","label":"Install from PyPI"}],"dependencies":[{"reason":"Required for database connection to Vertica via its PostgreSQL compatibility layer","package":"psycopg2","optional":false}],"imports":[{"note":"Incorrect module name, causes ImportError","wrong":"from vertica import VerticaPipe","symbol":"VerticaPipe","correct":"from pyvertica import VerticaPipe"}],"quickstart":{"code":"from pyvertica import VerticaPipe\nimport os\n\nconn_params = {\n    'host': os.environ.get('VERTICA_HOST', 'localhost'),\n    'port': 5433,\n    'user': os.environ.get('VERTICA_USER', 'dbadmin'),\n    'password': os.environ.get('VERTICA_PASSWORD', ''),\n    'database': os.environ.get('VERTICA_DB', 'vdb')\n}\n\nwith VerticaPipe(**conn_params) as pipe:\n    pipe.executemany(\n        \"INSERT INTO test_table (id, name) VALUES (:1, :2)\",\n        [(1, 'Alice'), (2, 'Bob')]\n    )\n    pipe.commit()","lang":"python","description":"Basic batch insert using VerticaPipe and parameterized queries."},"warnings":[{"fix":"Migrate to vertica-python library for active support and Python 3 compatibility.","message":"pyvertica last updated in 2015; unmaintained for years. May not support modern Python (3.6+). Recommended replacement is vertica-python.","severity":"deprecated","affected_versions":">=1.6.0"},{"fix":"Ensure Vertica database is listening on a port with PostgreSQL protocol enabled.","message":"Uses psycopg2 under the hood; Vertica's JDBC/ODBC drivers not required but the Vertica server must be configured to accept PostgreSQL wire protocol connections (default on port 5433).","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"last_verified":"2026-05-01T00:00:00.000Z","next_check":"2026-07-30T00:00:00.000Z","problems":[{"fix":"Use the correct import: from pyvertica import VerticaPipe","cause":"Importing from the wrong module name; correct module is pyvertica.","error":"ImportError: No module named vertica"},{"fix":"Ensure executemany('INSERT INTO t (c) VALUES (:1)', [(1,)]) uses a sequence of tuples.","cause":"Passing a string as the query or data when executemany expects a tuple/list.","error":"TypeError: string indices must be integers"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}