Release Notes: The select() method took arguments in a different order than specified in the documentation; note that this update made the select() method backward incompatible, and that you will have to change the order of the arguments for this to work. Some bugs with the update() and insert_update() methods have been fixed. A bug that most likely appeared since 2.7 with the "seek" method (and any method relying on it, like all the “fetch” methods) has been fixed. A bug where NULL could not be used in the "replacements" array of a query has been fixed.
Release Notes: This release adds support for caching query results using memcache, fixes a bug which caused the script to crash if the object was instantiated more than once and the language method was called for each of the instances, completely rewrites the dlookup method, which was not working correctly if anything other than a comma-separated list of column names was used (like an expression, for example), and lets the "connect" method take an additional argument instructing it to connect to the database right away rather than using a "lazy" connection.
Release Notes: The name of the "get_columns" method was changed to "get_table_columns", as it returned the number of columns in a given table. A new "get_columns" method was added, which takes as argument a resource and returns the number of columns in the given resource. Some clarifications in the documentation were also made.
Release Notes: This released added a "get_link" method, which returns the MySQL link identifier associated with the current connection to the MySQL server. This is necessary because the library uses "lazy connection", so there is no link identifier available when calling the connect method. The insert and insert_bulk methods have a new argument for creating INSERT IGNORE queries which will skip records that would cause a duplicate entry for a primary key. The default value of the "debug" property was set to FALSE.
Release Notes: A bug was fixed in the insert_bulk method. A new method was added, called table_exists, which checks to see if a table with the name given as argument exists in the database. The select method now also accepts limit and order arguments; due to this change, this method is not compatible with previous versions. Some documentation refinements were made.
Release Notes: A bug was fixed where the script would generate a warning if the update method was called with invalid arguments, and this release changes how the insert_bulk method needs to receive arguments, making it easier to use.
Release Notes: A bug was fixed where the "select" method was returning a boolean value rather than a resource. The class now uses "lazy connection", meaning that it will not actually connect to the database until the first query is run. The debug console now also shows session variables. The "show_debug_console" method can now be instructed to return output rather than print it to the screen. The highlighter now highlights more keywords. The documentation for the "connect" method was improved.
Release Notes: The entire code was improved and some of the properties as well as method names were changed and, therefore, this version breaks compatibility with earlier versions. The debug console shows more information and in a much better and more organized way. The XTemplate templating engine was dropped in order to improve speed; every aspect of the debug console can still be changed from the CSS file. Lots of bugs were fixed. New methods were added.
Release Notes: A full backtrace was added for each query. This is a full list of the file, line, and method that lead to the execution of each specific query. The highlighter is now a bit smarter and it does not highlight keywords in strings. More accurate reporting of queries being run multiple times. Error reporting was improved for cases of not being able to connect to the MySQL server or select a database. An issue with the style sheet file that caused the debug window to position according to the host application's style sheet was fixed. Some new methods were added. optimize() automatically optimizes tables that have overhead. A few minor bugs were fixed.