SQL Relay

SQL Relay is powerful database-access middleware consisting of server-based connection pool and client API's for using it.

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 access to clustered or replicated databases, route queries and migrate applications from one database to another.


Server Features

Persistent database connection pooling - makes database-driven web-based applications faster and more efficient
Proxying - access databases from unsupported platforms
Throttling - prevents databases from becoming overloaded
Load Balancing - distributes access over replicated or clustered databases
Query Routing and Filtering - conditionally sends queries to one database or another
Database Support - a wide variety commercial and open-source databases are supported


Client API Features

Substitution and bind variables - makes frequently run queries faster and more efficient
Multi-row fetches - reduces the number of network round-trips
Client-side result set caching - makes paging faster and easier
Suspended transactions - allows a single transaction to span multiple web pages
Language Support - a wide variety of programming languages are supported
Abstraction Layer Support - many database abstraction layers are supported
Drop-In Replacement Libraries - aims an existing MySQL or PostgreSQL app at SQL Relay without modification


Getting Started With Databases

SQL Relay supports many different databases. However, setting up a database before even trying to use SQL Relay with it can be a challenge. These documents include step-by-step instructions for setting up databases on various platforms.

Getting Started With Oracle
Getting Started With MySQL
Getting Started With PostgreSQL
Getting Started With Sybase
Getting Started With Microsoft SQL Server 2000 Desktop Engine
Getting Started With IBM DB2
Getting Started With Firebird
Getting Started With SQLite
Getting Started With Microsoft Access
Getting Started With Blackray
Getting Started With ODBC


Administering SQL Relay

Installing SQL Relay
Configuring SQL Relay
Running SQL Relay
Load Balancing and Failover
Query Routing and Filtering
Tuning SQL Relay


Drop-In Replacement Libraries

If you have an existing application that uses the native database API for MySQL or PostgreSQL, and are running into some of the problems that SQL Relay was designed to solve. You may be able to use SQL Relay without modifying your existing code.

MySQL
PostgreSQL


Developing with SQL Relay

SQL Relay provides native client API's for many different programming languages.

Guides:
C++
C
C#
Perl
PHP
Python
Ruby
Java
TCL
Erlang

References:
C++
C
C#
Perl
PHP
Python
Ruby
Java
TCL

SQL Relay also provides drivers for many database abstraction layers.

Guides:
ADO.NET
Perl DBI
Python DB
Ruby DBI
PHP PDO
ODBC
JDBC

References:
ADO.NET
Perl DBI
Python DB
Ruby DBI


SQL Relay Extension Modules

SQL Relay can be extended via modules. Use existing modules or develop your own.

Password Encryption
Logger


Frequently Asked Questions

FAQ