a firstworks project
SQL Relay
About Documentation Success Stories Download Licensing Support News


SQL Relay 1.9.3

Featuring...

Support for PHP 8.1
Support for Oracle 18 and 19
Improvements for ODBC and PostgreSQL

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.

Copyright 2017 - David Muse - Contact