Real-time Database Monitoring with PHP
Marty and Aron Lurie have published an intriguing developerWorks article DB2/Informix and open source: Database defense against the dark political arts - Real-time monitoring of your database for career enhancement. It includes PHP code which uses ODBC to monitor system tables to provide real-time database information. I see they managed to include a reference to the quasi-mythical Informix race-car..
Ruby/Informix 0.5.0 released
Gerardo Santana's Ruby extension for IDS continues its rapid development with the release of version 0.5.0. Download it from http://rubyforge.org/projects/ruby-informix/
0.5.0 12/27/2006------------------New features: * Easier to install * BigDecimal accepted for input parameters * BigDecimal used for instantiating DECIMAL and MONEY values * Cursor, Statement, Slob and Database accept an optional block that automatically frees resources after execution. Based on ideas and pseudo-code by Edwin Fine
and me. * Database#slob shortcut for creating Slob objects. * Slob::Stat class implemented. Returned by Slob#stat, represents the SLOB status. Methods: atime, ctime, mtime, refcnt and size. Includes Comparable. * Slob new methods: <<, rewind, stat, pos, pos=, lock, unlock, estbytes, extsz, flags, maxbytes, sbspace, extsz=, flags=, atime, ctime, mtime, refcnt and size * Thread safe
Remarks: * DECIMAL and MONEY columns are no longer returned as Float. BigDecimal is used instead.
Bugs fixed: * If there was an error reading (ifx_lo_read) an SLOB, memory allocated for the read buffer was not freed. Noticed by Edwin Fine
* maxbytes option was ignored when creating an Slob object * Documentation for Slob mentioned an RDRW constant, but it actually is RDWR.
Ruby on Rails/AJAX developerWorks Article
Continuing the Ruby theme Jack Herrington has written a database generic developerWorks article entitled Build Ajax into your Web apps with Rails Practical examples of how to use Ajax with Ruby on Rails. Worth a look.
Informix Zone has a new Python corner which kicks off with a tutorial from Carsten Haese on using a number generator to create a Fibonacci sequence. Part 2 promises a how-to on incorporating number generators with InformixDB.
Happy New Year!