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

NewIntroducingSQL Relay Enterprise Modules-MySQL Front-End Modules

SQL Relay Enterprise Modules add advanced features to the standard SQL Relay distribution.

MySQL Front-End Modules enable SQL Relay to speak the MySQL client-server protocol.


Free Trial Available

(more SQL Relay Enterprise Modules coming soon...)

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 2014 - David Muse - Contact