Tuesday, January 17, 2012
An updated version of Rudiments is now available. This release features some minor bug fixes and a few new methods. Nothing all that significant. However, the new features are required by SQL Relay 0.44 so if you're upgrading SQL Relay, upgrade Rudiments as well.
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.