SQL Relay is a persistent database connection pooling, proxying, and load balancing system. It supports many database systems and programming languages. There are drop-in replacement libraries for MySQL and PostgreSQL, command line clients, a GUI configuration tool, and extensive documentation. The APIs support advanced database operations such as binding variables, multi-row fetches, client-side result set caching, suspended transactions, query routing, and query filtering. It can be used for speeding up database-driven Web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases, and throttling database access.
Release Notes: This release features several improvements for using Microsoft SQL Server via FreeTDS. Parameters were added to reformat dates and times in result sets. Other minor bugs were fixed as well, including a few uninitialized variables and a memory leak.
Release Notes: sqlrserver-config returns the correct library now. A NULL dereference in custom_nw has been corrected.
Release Notes: Modular frameworks were added for logging and password encryption. The ODBC driver has been improved significantly. Various obscure bugs were fixed. Client API calls were added for getting the hostname and IP address of the database. The client-server protocol has been refactored to remove two round trips. The Windows build script now supports CLR and non-CLR builds.
Release Notes: Several contributed updates have been integrated. The stmtcachesize parameter now enables use of the Oracle Statement Cache. Most of the server-side code has been reorganized to be more modular, and several things have been reimplemented as plugins. Several performance improvements have been made. One eliminates an unnecessary client-server roundtrip and another eliminates an unnecessary re-prepare.
Release Notes: Support for using the Oracle Statement Cache has been integrated. Arguments for the command line clients have been standardized. sqlrsh now supports -command and -script options. Several bugs in sqlr-export have been fixed. The odbc and mdbtools connections now support getDatabase/Table/ColumnList. OpenJDK is now detected and supported. Begin, commit, and rollback commands now set error messages if they fail. Readline is now detected properly on Solaris.