[Sqlrelay-discussion] SQL Relay - 0.49 is out

[David M. <dav...@fi...>]

Hello all,

SQL Relay 0.49 is now available.

This release features the addition of extension modules for password 
encryption and logging. Logging was actually added in the previous 
release but it has been expanded and documented in this release.

The build process has been improved as well.

Lots of code was reorganized to be easier to maintain and to compile 
faster. For many years the configure script would erroneously include 
"-pthread" in the compile commands on platforms that don't support it. 
That has been fixed.

-Werror has been added to default build for most components as well and 
various issues revealed by it have been fixed.

The windows make.bat script has been refactored too and now supports 
both regular and CLR builds.

The client-server protocol has been refactored to improve performance. 
Two client-server round trips have been removed. One after 
authentication and another after the listener-connection handoff. All 
client-server commands can run in a single round trip now.

The handoff="reconnect" parameter has been replaced with 
handoff="proxy". In the past, if handoff="reconnect" then the client was 
told to disconnect from the listener and reconnect to an available 
connection daemon. Now, if handoff="pass" is unsupported, the listener 
just proxies the client, ferrying data back and forth between it and the 
server. This causes the listener/connection relationship to be 
completely transparent to the client and removes a client-server round-trip.

An very primitive ODBC driver has long been included in the source tree. 
It has been improved significantly in this release and can now be used 
with the isql program included with unixODBC and iODBC and with the 
henplus JDBC client using the JDBC-ODBC bridge. The driver still lacks 
many features, hasn't been tested much beyond those clients, and doesn't 
work on Windows without manually adding registry entries, but it is 
usable and should eventually make it possible to use SQL Relay with a 
much wider range of applications.

A few bugs were fixed as well including a bug that could cause problems 
when fetching from an output bind cursor under a very specific set of 
circumstances and a bug that could cause a hang if the database login 
failed.

Client API methods for getting the database's host name and IP address 
have been added as well.

Give it a try and report and bugs you find.

David Muse
dav...@fi...