All SQL Relay components should build and run on relatively modern versions of Linux, Unix, or Unix-like systems including Solaris, FreeBSD, NetBSD, OpenBSD, Minix, SCO OpenServer, SCO UnixWare, GNU Hurd, Haiku and Syllable. Other Unix or Unix-like systems may also be supported.
x86 and x86_64 platforms are supported, as are non-x86 architectures such as ARM, Sparc, Mips, PPC, and others.
uClib/Linux-based systems are also supported.
All SQL Relay components should build and run on relatively modern versions of x86 or x64 Windows as well.
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.
You also need to install the Rudiments library. You can download the most current Source Distribution of Rudiments from rudiments.sourceforge.net. Instructions for building and installing it are available at Installing Rudiments.
To build the non-C/C++ API's, you need to install one or more of Perl, PHP, Python, Ruby, TCL, Java, Erlang, or node.js. To build the C# API on Linux/Unix, you need to install Mono as well.
(Note: the Erlang API is not currently supported on Windows)
To build the database connection modules, you need to install one or more of Oracle, SAP/Sybase. DB2, Informix, MySQL, PostgreSQL, Firebird, or SQLite,
(Note: the SQLite connection module is not currently supported on Windows)
On Linux/Unix, you can also install unixODBC or iODBC to access databases using ODBC, and FreeTDS to access MS SQL Server (or SAP/Sybase).
On Windows, no additional software needs to be installed to access ODBC databases, and MS SQL Server is accessible via ODBC.
See Installing SQL Relay Prerequisites for detailed information on installing prerequisite software.
You can download the most current Source Distribution of SQL Relay from sqlrelay.sourceforge.net.
For Linux or Unix installations, download the tar.gz file.
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.
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
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
You can download the most current source distribution of SQL Relay from sqlrelay.sourceforge.net.
For a Windows installation, download the .zip file.
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.
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.
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 uninstallTo run the programs and scripts that use SQL Relay, it is helpful to add C:\Program Files\Firstworks\bin to your PATH.