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

Administering SQL Relay

Guides and references for SQL Relay administration:

Building and Installing SQL Relay From Source
Installing SQL Relay From Packages
SQL Relay Configuration Guide
SQL Relay Configuration Reference
SQL Relay Command Line Programs
Tuning SQL Relay
Current Benchmarks

Database How-To's

Getting-started guides for various databases supported by SQL Relay:

Oracle
SAP/Sybase
IBM DB2
MySQL
PostgreSQL
Firebird
SQLite
ODBC (on non-MS platforms)

Database Abstraction Layers

SQL Relay provides drivers for several popular database abstraction layers.

Guides:
ADO.NET
Perl DBI
Python DB-API
PHP PDO
ODBC
JDBC

References:
ADO.NET
Perl DBI
Python DB-API

Native APIs

The native SQL Relay client APIs provide advanced features like substitution and bind variables, multi-row fetches, client-side result set caching, and suspended sessions, transactions, and result sets.

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

References:
C++
C
C#
Perl
PHP
Python
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");
}