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 PDO ruby tcl java jni unix linux persistant

SQL Relay 2.0.0

Featuring...

Updated platform, language, and database support
Automatic deadlock resolution, split-multi-insert, and upsert modules
Simplified authentication

SQL Relay - the database connection management solution.

Persistent Database Connection Pooling
Improve performance and responsiveness of database-driven web-based applications.

Without SQL Relay:

With SQL Relay:

High Availability
Distribute database traffic over clustered or replicated databases for failover and scalability.

Query Routing
Route DML to masters and distribute selects over slaves.

Proxying
Access databases from unsupported platforms.

Back-End and Front-End Compatiblity

Connect to...

Oracle
SAP/Sybase
MS SQL Server
IBM DB2
MySQL
PostgreSQL
Firebird
SQLite
ODBC
MS Access

With...

PHP PDO
Perl DBI
Python DB
ODBC
JDBC

Native APIs
Develop new applications with a clean and powerful native APIs.

C
C++
C#
Perl
Python
PHP
Ruby
Java
TCL
Erlang
node.js

#!/usr/bin/perl

use SQLRelay::Connection;
use SQLRelay::Cursor;

$sqlrcon=SQLRelay::Connection->new("examplehost",9000,
                                        "/tmp/example.socket",
                                        "exampleuser",
                                        "examplepassword",0,1);
$sqlrcur=SQLRelay::Cursor->new($sqlrcon);

$sqlrcur->sendQuery("select * from exampletable");
for ($row=0; $row<$sqlrcur->rowCount(); $row++) {
        for ($col=0; $col<$sqlrcur->colCount(); $col++) {
                print($sqlrcur->getField($row,$col).",");
        }
        print("\n");
}

But that's just an overview. See the official documentation for much more information, including comprehensive howto's, guides and references.