The SQLB (SQL Load Balancer) project is used to improve SQL requests to a database. It provides programs that have permanent connections to a DB, a program that checks the integrity of transactions, and a library to link with programs that need to make SQL queries. SQLB supports Oracle8i, MySQL, and PostgreSQL.
|Operating Systems||POSIX Linux|
|Implementation||C PHP Perl|
Release Notes: The database detection was improved with more options in configure script. A problem which occurred when using --prefix to install sqlb elsewhere than in the default /usr/local was fixed.
Release Notes: The query log now displays the correct execution time. When an SQL query returns an error, the error message is now displayed in the error log. The "sqlb start" command is now more reliable and always runs sqlb as the "sqlb" user, even when launched by root. An init script has been added to the package. The configure script now correctly detects MySQL and readline. Now you can define the number of database connection you want per connection pool. The licencing policy have been clarified. The code was updated to support latest version of libsqlora.
Release Notes: Fixed the bug in the client library that caused weird behavior in the Perl module.
Release Notes: MySQL insert queries now return auto_increment values when used. A timeout problem in Oracle caused by a problem with bound variables was fixed.
Release Notes: Fixed a bug that sent bad results for queries with resultset size greater than 93Ko. Added a shell script that allows you to refresh all the db connection of sqlbqueries manually, called sqlb_reconnect_all.sh. Some other bug fixes made.