Database Application Interfaces
You may want to develop your own client applications that interface to LightDB-A Database. PostgreSQL provides a number of database drivers for the most commonly used database application programming interfaces (APIs), which can also be used with LightDB-A Database. These drivers are available as a separate download. Each driver (except libpq, which comes with PostgreSQL) is an independent PostgreSQL development project and must be downloaded, installed and configured to connect to LightDB-A Database. The following drivers are available:
| API | PostgreSQL Driver | Download Link |
|---|---|---|
| ODBC | LightDB-A DataDirect ODBC Driver | https://network.pivotal.io/products/pivotal-gpdb. |
| ODBC | psqlODBC | https://odbc.postgresql.org/ |
| JDBC | LightDB-A DataDirect JDBC Driver | https://network.pivotal.io/products/pivotal-gpdb |
| JDBC | pgjdbc | https://jdbc.postgresql.org/ |
| Perl DBI | pgperl | https://metacpan.org/release/DBD-Pg |
| Python DBI | pygresql | http://www.pygresql.org/ |
| libpq C Library | libpq | https://www.postgresql.org/docs/12/libpq.html |
General instructions for accessing a LightDB-A Database with an API are:
- Download your programming language platform and respective API from the appropriate source. For example, you can get the Java Development Kit (JDK) and JDBC API from Oracle.
- Write your client application according to the API specifications. When programming your application, be aware of the SQL support in LightDB-A Database so you do not include any unsupported SQL syntax.
Download the appropriate driver and configure connectivity to your LightDB-A Database coordinator instance.
Parent topic: Accessing the Database