skatrych/vertica-php-adapter

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

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

This package is not auto-updated.

Last update: 2024-03-20 16:32:18 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)