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 1.9.2

Featuring support for...

TLS in the MySQL and PostgreSQL protocol modules
UTF-16 in SQL Server nchar/nvarchars
PHP 8 and NodeJS 14+

SQL Relay is more than just a database proxy.

It's a database connection management solution.

Persistent Connection Pooling
makes database-driven web-based applications faster and more efficient.

Without SQL Relay:

With SQL Relay:

Load Balancing
distributes traffic over replicated or clustered databases for improved scalability.

Query Routing
can be used with master/slave replication.

Proxying
provides database access to unsupported platforms.

Access Oracle, SAP/Sybase, IBM DB2, and MS SQL Server from platforms like ARM Linux, FreeBSD, NetBSD, OpenBSD, and others.

Back-End and Front-End Compatiblity
are two of SQL Relay's strong suits.

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

A Clean and Powerful Native API
can also be used to develop new applications.

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.