firstworks Technologies Services Examples
Documentation Success Stories Download Support Keep in Touch
SQL Relay

SQL Relay is powerful database-access middleware consisting of a 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.


Developing with SQL Relay

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


SQL Relay also provides drivers for many database abstraction layers.

If you're developing or deploying SQL Relay client software in a Windows environment, you might want to check out libfirstworks too.

SQL Relay Extension Modules

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

Password Encryption

Frequently Asked Questions


Copyright 2011 - David Muse - Contact