Qore PostgreSQL Module is a DBI driver module for the Qore programming language to communicate with PostgreSQL databases. The PostgreSQL driver transparently handles client and server character encodings, supports multi-threading, transaction management, stored procedure execution, and more.
|Operating Systems||POSIX Linux HP-UX Mac OS X Solaris Unix|
Release Notes: This release implements auto-reconnect if the connection to the server is lost. An exception is thrown if a transaction was in progress; otherwise, the reconnection is made transparently. A crashing bug was fixed by serializing Qore's new number type to PostgreSQL's binary decimal representation when binding number values by value.
Release Notes: This release adds major new features when built against Qore 0.8.6+, including support for the prepared statement API (the SQLStatement class) and the new DBI option API, support for the new arbitrary-numeric data type added in Qore 0.8.6, and the ability to set server-side timezone rules in the client to ensure proper date/time support when communicating with a DB server in a different timezone.
Release Notes: The module was updated to compile with only client header files; previously, server headers were needed as well. Furthermore, the module was updated to build for Windows and some build fixes were made for newer Linux distributions.
Release Notes: The pgsql module has been updated to use qore 0.8.0 APIs for binding and retrieving time zone information and to maintain microsecond resolution with date/time values. Additionally, the Datasource::execRaw() and DatasourcePool::execRaw() methods are now supported and a bug was fixed in the code that reports the module's version.
Release Notes: Support was added for overriding the connection port with the Datasource and DatasourcePool classes when compiled against qore 0.7.6 or greater. A bug was fixed interpreting NUMERIC data on MSB (big endian) machines, and another bug was fixed parsing query substitution format codes in SQL text.