SQL Relay 0.45

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.


Product's homepage

Here are some key features of "SQL Relay":

SQL Relay is ideal for:

· speeding up database-driven web-based applications
· enhancing the scalability of database-driven web-based applications
· distributing access to replicated databases
· throttling database access
· accessing databases from unsupported platforms
· migrating applications from one database to another

SQL Relay supports the following database backends:

· Oracle
· MySQL
· mSQL
· PostgreSQL
· Sybase
· MS SQL Server
· IBM DB2
· Interbase
· Sybase
· SQLite
· ODBC
· MS Access

The SQL Relay client API's support advanced database operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions. SQL Relay has native client API's for the following languages:

· C
· C++
· Perl
· Python
· PHP
· Ruby
· Java
· TCL
· Zope

SQL Relay provides drivers for the following database abstraction layers:

· Perl DBD
· Python DB
· Ruby DBD
· PHP Pear DB

An application coded using another database's native client API may be able to use SQL Relay without modification. SQL Relay provides drop-in replacement libraries for:

· MySQL
· PostgreSQL

SQL Relay also features:

· command line clients
· a GUI configuration tool
· extensive documentation

What's New in This Release: [ read full changelog ]

· This version introduces MySQL statement API support in the drop-in library, DB-agnostic API methods to return db, table, and column lists, to get and set the current schema/db and to get the last insert id.
· This release also features bind variable format translation, the ability to fake transaction blocks for db's that don't support them, and the ability to run a set of queries at the start and end of a client session.
· The sqlrsh command line client now supports bind variables.