skatrych/vertica-php-adapter

PHP Adapter for Vertica Database from HP. Uses php ODBC extension.

v0.1.2 2016-04-21 10:26 UTC

Requires

• php: >=5.4

Requires (Dev)

• phpunit/phpunit: 4.5.*

MIT

• Sergii Katrych

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)