The pgsql module for Qore provides a database driver for PostgreSQL databases.
Requires qore 0.7.0 and postgresql headers and libraries to build. When built with Qore 0.8.0+, the module supports microsecond resolution time zone information in date/time values.
Module documentation: http://qore.org/manual/modules/pgsql-module-doc.html
The driver supports the following features:
- all builtin PostgreSQL data types are supported
- multi-dimensional arrays are supported for binding and retrieving
- is thread-safe
- stored procedure execution is supported
- transaction management is supported
- transparent character encoding conversion is supported if necessary
The driver's name is "pgsql" and the Datasource type constant is SQL::DSPGSQL
ex (for Qore 0.8.0+):
my Datasource $db(DSPGSQL, $user, $pass, $db);
my DatasourcePool $pool(parseDatasource("pgsql:user/pass@db"));
The Qore pgsql driver uses native binary communication with PostgreSQL servers for retrieving values and binding and reading placeholder buffers. It automatically sets per-connection variables on server settings (i.e. it automatically determines if the server is using floats or 64-bit integers for time values, etc).
This module is stable and has been extensively tested.
The latest source code can be checked out from svn with the following command:
svn co https://svn.qore.sf.net/svnroot/qore/module-pgsql/trunk qore-module-pgsql
RPMs for Linux can be found at the opensuse build service here: http://download.opensuse.org/repositories/devel:/languages:/misc/
Mac OS/X users can install this module by using macports by issuing the following command
sudo port selfupdate
sudo port -vu install qore-pgsql-module
