Tuesday, August 9, 2022

SQL Relay 1.9.3 Re-Release Announcement

I just updated the release files for version 1.9.3 of SQL Relay. There was a problem that caused the master branch rather than the 1.9.3 branch to get packaged as 1.9.3, which led to all kinds of build errors. That's been fixed. The files that are out there now should contain source for the actual 1.9.3 release. If you had trouble building, then that's almost certainly why. Try re-downloading the SQL Relay source. It should work this time.

Friday, August 5, 2022

SQL Relay 1.9.3 Release Announcement

Version 1.9.3 of SQL Relay, the powerful connection pool, load balancer, query router, and database proxy, is now available.

This release has 2 main features:

  • Support for PHP 8.1
  • Support for Oracle 18 and 19

However, it does include some bug fixes as well:

  • It is now possible to bind NULLs when using the ODBC backend to talk to MS SQL. This, apparently, didn't work in previous versions.
  • Some SQLGetInfo()s were missing from the ODBC driver, which prevented it from working correcltly with specific apps, in conjunction with ODBC 3.8+, most notably the Oracle Heterogenous Agent. Those are now fixed.
  • I had inadvertantly enabled some experimental code in the PostgreSQL backend. That's disabled now, and works correctly.
  • The PostgreSQL front-end had bind-related trouble when used with a non-PostgreSQL backend due to various subtle bugs. Those are fixed now.
  • In certain circumstances, SQL Relay had trouble binding date values when used with MySQL. That's also fixed.

If any of that sounds familiar to you, or if you need support for PHP 8.1 or Oracle 18+, give this release a try!