SQL Relay

SQL Relay is a powerful database connection management solution.




With SQL Relay, you can speed up and enhance the scalability of database-driven web-based applications, access databases from unsupported platforms, throttle database access, distribute load over clustered or replicated databases, route queries and migrate applications from one database to another.


Advantages

Persistent Database Connection Pooling - makes database-driven web-based applications faster and more efficient
Proxying - provides access to databases from unsupported platforms
Throttling - prevents databases from becoming overloaded
High Availability - provides load balancing and failover with replicated or clustered databases
Query Routing - conditionally sends queries to one database or another
Query Filtering - prevents queries that match certain patterns from being run at all
Connection Schedules - constrain database access to specified times
Database Support - a wide variety of commercial and open-source databases are supported
Abstraction Layer Support - drivers for most popular database abstraction layers are provided
Drop-In Replacement Libraries - allow many native MySQL or PostgreSQL applications to use SQL Relay without modification
Native API - the powerful native SQL Relay client API supports a wide variety of programming languages
Substitution and Bind Variables - make frequently run queries faster and more efficient
Multi-Row Fetches - reduce the number of network round-trips
Client-Side Result Set Caching - makes paging faster and easier
Suspended Transactions - allow a single transaction to span multiple web pages

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

MySQL Front-End Modules - allow MySQL applications to use SQL Relay without modification and without a drop-in replacement library
(more Enterprise Modules coming soon...)



Administering SQL Relay

Guides and references for SQL Relay administration.

Building and Installing SQL Relay From Source
SQL Relay Configuration Guide
SQL Relay Configuration Reference
SQL Relay Command Line Programs
Tuning SQL Relay

Database How-To's

Getting-started guides for various databases supported by SQL Relay.

Oracle
SAP/Sybase
IBM DB2
MySQL
PostgreSQL
Firebird
SQLite
MS Access (on non-MS platforms)
ODBC (non-MS platforms)

New Administering SQL Relay Enterprise Modules

Installing the SQL Relay Enterprise Modules
Licensing the MySQL Front-End Modules
Configuring the MySQL Front-End Modules



Connectors

SQL Relay provides drivers for most popular database abstraction layers.

Guides:
ADO.NET
Perl DBI
Python DB-API
PHP PDO
ODBC
JDBC
References:
ADO.NET
Perl DBI
Python DB-API

Native APIs

The native SQL Relay client APIs provide advanced features like suspended sessions, result set caching and tuning options.

Guides:
C++
C
C#
Perl
PHP
Python
Ruby
Java
TCL
Erlang
node.js
References:
C++
C
C#
Perl
PHP
Python
Ruby
Java
TCL
node.js

Drop-In Replacement Libraries

Drop-In Replacement Libraries allow many native MySQL or PostgreSQL applications to use SQL Relay without modification.

MySQL
PostgreSQL

Frequently Asked Questions

FAQ