a firstworks project
SQL Relay
About Documentation Download Licensing Support News


SQL Relay 2.0.0

Featuring...

Updated platform, language, and database support
Automatic deadlock resolution, split-multi-insert, and upsert modules
Simplified authentication

SQL Relay - the database connection management solution.


Persistent Database Connection Pooling
Improve performance and responsiveness of database-driven web-based applications.

Without SQL Relay:

With SQL Relay:

High Availability
Distribute database traffic over clustered or replicated databases for failover and scalability.


Query Routing
Route DML to masters and distribute selects over slaves.

Proxying
Access databases from unsupported platforms.


Back-End and Front-End Compatiblity

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

Native APIs
Develop new applications with a clean and powerful native APIs.

  • 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