skatrych/vertica-php-adapter

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

Maintainers

Details

github.com/skatrych/vertica-php-adapter

Homepage

Source

Issues

Installs: 8 199

Dependents: 1

Suggesters: 0

Security: 0

Stars: 5

Watchers: 3

Forks: 6

Open Issues: 0

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

Requires

  • php: >=5.4

Requires (Dev)

MIT d4d0ac5e4bd63ec01062b598da15725d29380042

  • Sergii Katrych <sergii.katrych.woop@gmail.com>

This package is not auto-updated.

Last update: 2024-11-13 19:30:21 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)