Version 1.0a10 of my PostgreSQL extension for Frontier and Radio is ready for download:
Summary of changes since 1.0a5, the last public release:
- Implemented an easier-to-use high-level interface for executing queries and retrieving query results, loosely based on the Python Database API Specification 2.0. Query parameters and result sets are converted transparently between UserTalk and PostgreSQL data types and vice versa. All new verbs are documented in DocServer format.
- Implemented connection pooling: The extension optionally manages a pool of connections to the database backend for you. When you need a connection, you can just grab an idle connection from the pool instead of opening a new one, thereby eliminating the overhead associated with opening the TCP/IP connection, authenticating, and starting up a new backend process on the server.
- Upgraded PostgreSQL front-end library code from 7.1.2 to 7.2.
- Cleaned up the extensions.postgreSQL table by moving all verbs making up the old libpq interface out of the way into the postgreSQL.PQ sub-table.
If you give this version a try, please let me know how it goes. I’m especially interested in feedback about the design and usability of the new high-level interface.