skatrych / vertica-php-adapter
PHP Adapter for Vertica Database from HP. Uses php ODBC extension.
Installs: 7 847
Dependents: 1
Suggesters: 0
Security: 0
Stars: 5
Watchers: 3
Forks: 6
Open Issues: 0
Requires
- php: >=5.4
Requires (Dev)
- phpunit/phpunit: 4.5.*
This package is not auto-updated.
Last update: 2024-10-30 19:15:30 UTC
README
Simple PHP Db adapter that allows to communicate to HP Vertica databases. Implements Db communication via odbc_* functions. Pure ODBC solution is not that good and modern as PDO but we have to use it due to the known PDO bug (https://bugs.php.net/bug.php?id=63949) that makes it impossible to fetch data from Vertica tables with VARCHAR columns longer than 255.
Requires:
- php >= 5.4
- php_odbc extension
- Vertica drivers
Vertica Driver & ODBC layer installation (Linux systems)
Please make sure you have installed:
- php5-odbc
- odbcinst
- unixODBC
Make ODBC and Vertica drivers to work together:
- Download and extract Vertica drivers from official website https://my.vertica.com/vertica-client-drivers/ (it should match your Vertica Db version)
- Extract driver under /opt/vertica/
- create/edit file: /etc/odbc.ini (see example under vertica-php-adapter/examples/drivers/odbc.ini)
- create/edit file: /etc/odbcinst.ini (see example under vertica-php-adapter/examples/drivers/odbcinst.ini)
- create/edit file: /etc/vertica.ini (see example under vertica-php-adapter/examples/drivers/odbcinst.ini)