You may want to develop your own client applications that interface to HAWQ. PostgreSQL provides a number of database drivers for the most commonly used database application programming interfaces (APIs), which can also be used with HAWQ. These drivers are available as a separate download. Each driver is an independent PostgreSQL development project and must be downloaded, installed and configured to connect to HAWQ. The following drivers are available:
API | PostgreSQL Driver | Download Link |
---|---|---|
ODBC | pgodbc | Available on Pivotal Network. |
JDBC | pgjdbc | Available on Pivotal Network. |
Perl DBI | pgperl | http://search.cpan.org/dist/DBD-Pg/ |
Python DBI | pygresql | http://www.pygresql.org/ |
General instructions for accessing a HAWQ with an API are: