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

Announcing:SQL Relay 1.2.0

Solid as ever on Linux and Unix.

Now more reliable on Windows.

Significant ODBC Improvements.

Download SQL Relay 1.2.0 today.

Source and binary distributions available.

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");
}

Drop-in Replacement Libraries
allow many MySQL and PostgreSQL applications to use SQL Relay without modification.



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