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.
|Licenses||LGPL MIT License|
|Operating Systems||POSIX Linux HP-UX Mac OS X Solaris Unix|
Release Notes: This release adds support for UNKNOWNOID, allowing the direct retrieval of string constants in SQL queries. The module is now released under an MIT source license as well as the LGPL 2.1.
Release Notes: This release fixes a bug which occurred when the driver was used with the SQLStatement class and bind arguments were not bound on subsequent calls to SQLStatement::exec() or SQLStatement::execArgs().
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.