{"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.","language":"python","status":"maintenance","last_verified":"Fri May 01","install":{"commands":["pip install pyvertica"],"cli":null},"imports":["from pyvertica import VerticaPipe"],"auth":{"required":false,"env_vars":[]},"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.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}