[Sqlrelay-discussion] SQL Relay 0.44 is out

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

Hello all,

SQL Relay 0.44 is out.

This release introduces a host of new features.

* The MySQL Drop-In Replacement Library has been greatly improved and 
updated to support MySQL 5.2 and the MySQL statement API.
* The SQL Relay client API's support new methods to get databases, 
tables and columns, returning lists similar to those returned by "show 
databases", "show tables" and "describe table" queries.
* Bind Variable Translation is now supported.  If your queries have ?'s 
in them but you want to aim them at a database that uses colon-delimited 
queries, or vice-versa, SQL Relay can remap the variables automatically.
* SQL Relay can now fake transaction blocks.  If you are migrating from 
a DB that is in autocommit mode by default and requires "begin" or 
"start" queries to begin a transaction to a database that is always in a 
transaction, SQL Relay can fake the behavior of the first database and 
make the new database appear to support transaction blocks.
* The sqlrsh command line client now supports bind variables.
* selectDatabase()/getCurrentDatabase() methods have been added to all 
API's, providing a database agnostic method for switching schemas/db's.
* The fakebinds connect string option has been replaced by a parameter 
at the instance level and all databases support faking of input binds now.
* getLastInsertId() has been added to all API's.  If the database 
supports it natively then the native function is used.  If the database 
doesn't support it then a stored procedure can be specified to fake it.
* A set of queries can be run at the beginning and end of each client 
session now.

This is all in addition to the standard number of bug fixes and 
optimizations.

Give it a try, report any bugs that you find!

David Muse
dav...@fi...



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com