ADOdb Lite is a lightweight software that aims to replace ADODB. With its reduced memory usage and higher speed up to 300%, it is an effective tool for quick data access.
The best part about ADOdb Lite is its versatility. It supports Frontbase, MaxDB, MiniSql, MSSQL, MySQL, PostgreSQL, SQLite, and Sybase. In this release, ADOdb Lite has added several new features and fixed a few bugs.
New features include the SQLdate function in the date module, the loadObjectList function in the object module, and the ADOdb Performance Module for the MySql, Mysqli, and Mysqlt drivers.
Several bugs have been fixed in this release. One notable fix is the if statement in the do_query() function that is now changed to if (@pg_numfields( $resultId ) forcenewconnection) in the _makeconnection() function to if(!$this->forcenewconnection) in all Postgres drivers.
Another fix involves the removal of the else statement in the adodb_mktime function in the adodb-time.inc.php program to fix a month calculation error. In the generic object module, var _obj; is now changed to var $_obj; and var _names; is now var $_names;.
The ADOdb Lite team has also made some changes to improve performance testing, such as adding query tracking and three new database array variables: $db->query_list, $db->query_list_time, and $db->query_list_errors. These variables will allow easy tracking of every query on any page and the amount of time it took to execute each query.
All in all, ADOdb Lite is a reliable and efficient solution for those looking for a fast and memory-efficient replacement for ADODB. Its compatibility with popular databases and new features make it worth considering for any software developer.
Version 1.42: N/A