February 23rd, 2013
· This version features several improvements for using Microsoft SQL Server via FreeTDS. Parameters were added to reformat dates and times in result sets.
· Other minor bugs were fixed as well, including a few uninitialized variables and a memory leak.
January 29th, 2013
· sqlrserver-config returns the correct library now.
· A NULL dereference in custom_nw has been corrected.
January 3rd, 2013
· Modular frameworks were added for logging and password encryption.
· The ODBC driver has been improved significantly.
· Various obscure bugs were fixed.
· Client API calls were added for getting the hostname and IP address of the database.
· The client-server protocol has been refactored to remove two round trips.
· The Windows build script now supports CLR and non-CLR builds.
December 10th, 2012
· Several contributed updates have been integrated.
· The stmtcachesize parameter now enables use of the Oracle Statement Cache.
· Most of the server-side code has been reorganized to be more modular, and several things have been reimplemented as plugins.
· Several performance improvements have been made.
· One eliminates an unnecessary client-server roundtrip and another eliminates an unnecessary re-prepare.
November 5th, 2012
· This release mainly features the ability to use Oracle's Statement Cache feature. Code for this was contributed by Neowiz.
To enable the statement cache, simply add:
· (Or some size other than 20)
· ...to the connect string for your instance of SQL Relay that talks to Oracle in your sqlrelay.conf file. Note also that there are a few quirks when using the statement cache which appear to be either bugs in OCI or issues with the way SQL Relay uses OCI. They may be resolved in a future release of OCI or SQL Relay. See Configuring SQL Relay for more information.
· Note also that I haven't finished integrating all of the contributed code yet, so if something doesn't work as expected, that could be why.
· Also in this release, I updated the SQL Relay command line clients to have a consistent command-line parameter interface and renamed a few of them.
All command line programs now have the following parameters:
So, for example, to connect to localhost, port 9000 using user test with password test, you now use:
· sqlrsh -host localhost -port 9000 -user test -password test
Whereas in the past, you would have used:
· sqlrsh localhost 9000 "" test test
· In addition, sqlrsh now has -script and -command arguments to run scripts or commands non-interactively.
· I also renamed the query and fields commands sqlr-query and sqlr-fields.
In addition to those updates and changes, the following new features and bug fixes have also been implemented:
· fixed bug that caused sqlr-export to output negative xml-entity values
· fixed single-quote-escaping in sqlr-export
· forced handoff="reconnect" for Cygwin and Linux
January 19th, 2012
· This version introduces MySQL statement API support in the drop-in library, DB-agnostic API methods to return db, table, and column lists, to get and set the current schema/db and to get the last insert id.
· This release also features bind variable format translation, the ability to fake transaction blocks for db's that don't support them, and the ability to run a set of queries at the start and end of a client session.
· The sqlrsh command line client now supports bind variables.
August 17th, 2011
· Detection of various languages and databases in the configure script was improved.
· Many compatibility tweaks for Ruby, Tcl, db2, and OS X were made.
· Many direct calls to POSIX functions were replaced with rudiments process-class calls.
· Connect-string parameters to define the character set were added for most databases.
· There's a new "getting started with ODBC" document, and the FAQ was updated with information about stored procedures that return result sets.