SQL Relay

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, Oracle, MySQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Firebird, SQLite and MS Access (minimally) with APIs for C, C++, ODBC, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, Java, TCL and Erlang, drop-in replacement libraries for MySQL and PostgreSQL clients, command line clients and extensive documentation. The APIs support advanced database operations such as bind variables, multi-row fetches, client-side result set caching and suspended transactions. It is ideal 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.

Introduction
SQL Relay FAQ
Introduction to Database Access from Web-Based Applications
Introduction to SQL Relay
Getting Started With Databases
Getting Started With Oracle
Getting Started With MySQL
Getting Started With PostgreSQL
Getting Started With Sybase
Getting Started With Microsoft SQL Server 2000 Desktop Engine
Getting Started With IBM DB2
Getting Started With Firebird
Getting Started With SQLite
Getting Started With Microsoft Access
Getting Started With Blackray
Getting Started With ODBC
Administering SQL Relay
Installing SQL Relay
Configuring SQL Relay
Running SQL Relay
Load Balancing and Failover
Routing and Filtering Queries with SQL Relay
Tuning SQL Relay
Using SQL Relay on Windows
Developing with SQL Relay
Programming with SQL Relay using the C++ API
Programming with SQL Relay using the C API
Programming with SQL Relay using the Perl API
Programming with SQL Relay using the Perl DBI API
Programming with SQL Relay using the PHP API
Programming with SQL Relay using the PHP Pear DB API
Programming with SQL Relay using the Python API
Programming with SQL Relay using the Python DB API
Programming with SQL Relay using the Ruby API
Programming with SQL Relay using the Ruby DBI API
Programming with SQL Relay using the Java API
Programming with SQL Relay using the TCL API
Programming with SQL Relay using the Erlang API
Programming with SQL Relay using Zope
Programming with SQL Relay using ODBC
Programming with SQL Relay using JDBC
Using SQL Relay Drop-In Replacement Libraries
MySQL
PostgreSQL
SQL Relay API References
C++ API Reference
C API Reference
Perl SQLRConnection API Reference
Perl SQLRCursor API Reference
Perl DBI API Reference
PHP API Reference
Python API Reference
Python DB API Reference
Ruby API Reference
Ruby DBI API Reference
TCL API Reference
Java API Reference