firstworks: SQL Relay - sqlrelay persistent database connection pool pooling proxy load balance balancing odbc oracle mysql msql postgresql sybase db2 interbase sqlite access c++ perl DBD DBI python php zope ruby tcl java jni unix linux persistant

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
Sybase
MS SQL Server
IBM DB2

MySQL
PostgreSQL
Firebird
SQLite

ODBC
MS Access
Blackray

SQL Relay has native client API's for:

C
C++
Perl
Python
PHP

Ruby
Java
TCL
Erlang
Zope

These API's support advanced operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions.

SQL Relay provides database abstraction layer drivers for:

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