Qore PostgreSQL Module is an open source module for the Qore programming language that provides a driver for the PostgreSQL database. It supports the following DBI capabilities: DBI_CAP_TIME_ZONE_SUPPORT, DBI_CAP_TRANSACTION_MANAGEMENT, DBI_CAP_CHARSET_SUPPORT, DBI_CAP_LOB_SUPPORT, DBI_CAP_STORED_PROCEDURES, DBI_CAP_BIND_BY_VALUE, DBI_CAP_HAS_EXECRAW, DBI_CAP_HAS_STATEMENT, DBI_CAP_HAS_SELECT_ROW, DBI_CAP_HAS_NUMBER_SUPPORT, DBI_CAP_HAS_OPTION_SUPPORT, DBI_CAP_SERVER_TIME_ZONE and DBI_CAP_AUTORECONNECT.
At the moment, the driver includes the following options: optimal-numbers, string-numbers, numeric-numbers and timezone. More documentation can be found here. The latest source code can be grabbed from SVN using the following command:
svn co svn://svn.code.sf.net/p/qore/code/module-pgsql/trunk qore-module-pgsql
Qore is a free, open source, yet powerful and easy-to-use weakly-typed scripting language that features TIBCO AE integration and runs on Linux, BSD, Solaris, HP-UX, and Mac OS X operating systems.
What is new in this release:
- Treat UNKNOWNOID as string; fixes cases such as selecting string constants (ie "select 'string'")
What is new in version 2.2:
- This version 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().
What is new in version 2.1:
- Implemented support for DBI_CAP_AUTORECONNECT; the driver will automatically and transparently reconnect to the DB server if the connection is lost while not in a transaction; if a transaction was in progress a reconnection will also be made, but an exception will also be thrown reflecting the loss of transaction state
- Fixed a crashing bug serializing the zero number value (0n) to PostgreSQL's binary decimal representation
Requirements:
- Qore Programming Language
- PostgreSQL
Comments not found