Enable dev_log on your local development system to see every query run through CodeIgniter's ActiveRecord class. On every page load see all of your queries processing in real-time including information about the amount of time that it took each query to run. See a preview of the returned dataset.
A video demonstration is available on the dev_log homepage.
Put these files in the appropriate places in your application/ folder.
Install Firebug and FirePHP for Firefox in order to use FirePHP logging.
To use the test controller injest the big_name_toolkit.sql into your database. The test controller can be accessed by http://yourdomain/dev_log/dev_log_test.
If you want summary information then enable hooks in application/config/config.php.
For system logging verify that the log threshold is at 2 or higher in config.php.
To use FirePHP one must first install the FirePHP and FireBug extensions for Firefox. Then, when on the site make sure that Firebug is on and that the net panel has been activated. FirePHP won't work without the net panel enabled. Logging will occur on the 'console' tab in Firebug.
dev_log only works in CI version 2. I have no intention of making it backwards compatible.
dev_log only works for the MySQL driver.
If the config file doesn't load or if a config option isn't present it defaults to off. If dev_log isn't logging then it could be because the config file isn't loaded in modules/dev_log/config/autoload.php.
Some code was taken directly from the following blog post by Simon Emms. Some of the files were modified ever so slightly. http://www.simonemms.com/code/extending-the-codeigniter-database-class/
WireDesignz's CodeIgniter Modular Extension package was included to add module support. (Everyone should be using this). http://wiredesignz.co.nz/
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.