Supported Platforms

Prerequisites

Before you can compile SQL Relay, you must install some prerequisites.

The first thing that you need is a compiler toolchain and make utility.

GNU and clang/LLVM toolchains are supported on Linux/Unix systems. The native compiler toolchain for SCO UnixWare is also supported. Native compiler toolchains for other Unix platforms may work as well. GNU make is also required on Linux/Unix platforms.

Microsoft Visual Studio and Microsoft Visual Studio Express toolchains are supported on Windows. Versions 2005 and greater should work. The nmake utility is also required, but it's provided by Visual Studio.

Installation on Linux, Unix or Unix-like Platforms

Downloading SQL Relay

Extracting SQL Relay

To extract the source distribution, move the file to a location on your machine that you have read/write access and execute the following commands:

gunzip sqlrelay-X.XX.tar.gz
tar xf sqlrelay-X.XX.tar

(Where X.XX is replaced with the version of SQL Relay that you downloaded.)

This will create a sqlrelay-X.XX directory.

Building SQL Relay

To build SQL Relay, navigate to the directory that was created by the extraction, and run:

configure
make

The configure script takes several command line options, most of which tell it where to find prerequisite software in case any of it is installed in non-standard locations.

The configure script also takes the --prefix option in case you want to install it somewhere other than /usr/local/firstworks. For example:

configure --prefix=/usr/local

This invocation would cause the libraries to be installed in /usr/local/lib, the header files in /usr/local/include, the binaries and scripts to be installed in /usr/local/bin, etc.

To configure a build where only the client components are compiled, you can use the following option to disable the server components:

configure --disable-server

To configure a build where only the client command line programs are compiled, you can use the following options to disable the server components and client API's:

configure --disable-server --disable-perl --disable-python --disable-php --disable-ruby --disable-tcl --disable-erlang --disable-mono --disable-java --disable-nodejs --disable-odbc-driver --disable-mysql-drop-in --disable-postgresql-drop-in

To configure a build where only the server components are compiled, you can use the following options to disable everything but the server components:

configure --disable-server --disable-perl --disable-python --disable-php --disable-ruby --disable-tcl --disable-erlang --disable-mono --disable-java --disable-nodejs --disable-odbc-driver --disable-mysql-drop-in --disable-postgresql-drop-in --disable-cmdline

There are also options for using cross-compilers and enabling debug and profiling. To see the full list of available options, run:

configure --help

Installing SQL Relay

By default, on Unix or Linux, everything is installed under /usr/local/firstworks by default. You should either create that directory and give yourself full access permissions or install as root.

To install SQL Relay run:

make install

Libraries are installed in /usr/local/firstworks/lib. Include files are installed in /usr/local/firstworks/include. Binaries and scripts are installed in /usr/local/firstworks/bin. Java libraries are installed in /usr/local/firstworks/java. Files for other programming languages are installed in the appropriate language-specific directories.

If you install SQL Relay as root, init scripts and files will be installed in the appropriate places under /etc for your system. If you install SQL Relay as a non-root user, the init scripts and files will be installed in similar places under /usr/local/firstworks/etc.

To uninstall SQL Relay run:

make uninstall

Installation on Windows

Downloading SQL Relay

Extracting SQL Relay

To extract the source distribution, move the file to your desktop or a location on your machine that you have read/write access, right-click on the file and select "Extract All".

This will create a sqlrelay-X.XX directory.

Building SQL Relay

To build SQL Relay on Windows, open the Visual Studio Command Prompt.

To build a 32-bit version of SQL Relay, open the Visual Studio Command Prompt for x86. To build a 64-bit version of SQL Relay, open the Visual Studio Command Prompt for x64.

Navigate to the directory that was created when SQL Relay was extracted, and execute the following commands:

cscript /nologo configure.vbs nmake

The configure.vbs script takes several command line options, most of which tell it where to find prerequisite software in case any of it is installed in non-standard locations.

To configure a build where only the client components are compiled, you can use the following option to disable the server components:

cscript /nologo configure.vbs --disable-server

To configure a build where only the client command line programs are compiled, you can use the following options to disable the server components and client API's:

cscript /nologo configure.vbs --disable-server --disable-perl --disable-python --disable-php --disable-ruby --disable-tcl --disable-erlang --disable-cs --disable-java --disable-nodejs --disable-odbc-driver --disable-mysql-drop-in --disable-postgresql-drop-in

To configure a build where only the server components are compiled, you can use the following options to disable everything but the server components:

cscript /nologo configure.vbs --disable-server --disable-perl --disable-python --disable-php --disable-ruby --disable-tcl --disable-erlang --disable-cs --disable-java --disable-nodejs --disable-odbc-driver --disable-mysql-drop-in --disable-postgresql-drop-in --disable-cmdline

Though inconvenient, the config.mk file can also be modified manually prior to running nmake to alter paths or exclude support for certain languages or databases.

Installing SQL Relay

By default, on Windows, most components are installed under C:\Program Files\Firstworks. You should either create the appropriate directory and give yourself full access permissions or install as Administrator.

nmake install

Libraries are installed in C:\Program Files\Firstworks\lib. Include files are installed in C:\Program Files\Firstworks\include. Binaries and scripts are installed in C:\Program Files\Firstworks\bin. Java libraries are installed in C:\Program Files\Firstworks\java. Files for other programming languages are installed in the appropriate language-specific directories.

To uninstall SQL Relay run:

nmake uninstall

To run the programs and scripts that use SQL Relay, it is helpful to add C:\Program Files\Firstworks\bin to your PATH.