The Zend Developer Zone has a new article called Migrating applications from PHP 4 to Zend Core 2.5 with support for IBM Informix on Linux Platform. The article, by Antonio Musarra, describes how to build the Informix module with PHP 5.2.5, which is the version that comes with Zend Core 2.5.
As Ambrish Bhargava points out in the comments section of the article, there is a PHP PDO extension for Informix available on the PECL website: http://pecl.php.net/package/pdo_informix.[Read More]
Administrating and Developing with Informix
Matching: php X
The Unofficial Oninit blog has an article with an English introduction on how to make IDSAdmin work with non-English locales: IDSAdmin with non-English DB ?
It's good to see people customizing IDSAdmin. The PHP code is there for anyone to modify for their own purposes. The problem the blog mentions "The current open beta version of IDSAdmin does not use Locale variables when it establishes connection to the database server" has now been logged and will be fixed by GA.
New Informix PDO Driver Version
An Informix PDO Driver for windows compiled against the latest versions of the driver and also PHP (version 5.2 and 6) has been released and is downloadable at the PECL4WIN site here: http://pecl4win.php.net/ext.php/php_pdo_informix.dll.
This means you should now be able to use the latest versions of XAMPP. I have not tested this yet but my colleague tried copying the latest XAMPP over his existing installation, with the new PDO driver, and reports that it is working.[Read More]
Today's Chat with the Labs - Improving IDS Administration Free Zone presented by John Miller III - went through the feature enhancements in IDS 11.10 to assist with administration such as the Scheduler, the Sysadmin database, SQL statement history and other new statistics, the new Admin UDRs task() and admin(), non-blocking checkpoints and more. In case you missed it the slides are here. The Informix Zone summary is here.
Thanks to the wonders of jet lag I'm in the office bright and early and catching up with some of the Informix content over the last two weeks...
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
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![Read More]
Trouble with Locales follow-up
Nobody likes it when they upgrade and their application stops working, which is probably why the Trouble with locales post from May generated more feedback than any other. Removing support for implicit locale conversion when DB_LOCALE settings were mismatched, thus introducing a potential backward incompatibility, was a regrettably unavoidable step to prevent the possibility of data corruption. A recent IIUG Forums mail highlighted the fact that some of the documentation covering Code-Set conversion is no longer correct (at the time of writing), like this example from the JDBC Programmer's Guide: Unicode to Database Code Set...
Gerardo Santana's Ruby driver for Informix has been updated to version 0.2.1. The new update is to fix some problems with free() calls which were causing crashes on Windows XP SP1. See the freshmeat page for details.
On the subject of Ruby, Informix Zone has added an article Talking with Perl, PHP, Python, Ruby to IDS showing Informix Dynamic Server programming examples for each of these free programming languages, including an overview of the "database abstraction layer" architecture they use.[Read More]
The 2nd annual Zend/PHP Conference is currently taking place in San Jose. Yesterday saw the official announcement of support for IDS and DB2 V9 in the latest Zend Core for IBM. Other new features include pureXMLTM support and an optional connection pooling feature.
The Zend announcement can be found here: Zend and IBM Combine Performance, Scalability and Rich Content Support in New Version of Zend Core for IBM. Or view the eWeek story: Zend Moves to Boost PHP Usage.[Read More]
The latest DB2 magazine has a PHP and IDS tutorial that makes a great introduction to using PHP with Informix. Compare this with the earlier developerWorks articles: A step-by-step how-to guide to install, configure, and test a Linux, Apache, Informix, and PHP server and A step-by-step how-to guide to install, configure, and test a Windows, Apache, Informix, and PHP server.
On the subject of new IDS articles developerWorks recently added a guide to making use of the powerful Archecker utility: Perform point-in-time table-level restore in Informix Dynamic Server.[Read More]
There have been a few new Informix developworks and support articles in the last month or three. Here are my favourites:
RSS feeds provide a convenient way to display up to date information directly in your Firefox browser toolbar. I for one spend more time perusing the BBC News and Slashdot feeds than I should.
Implementing an RSS feed that displays database information is very simple, hence the 5 minute Informix RSS feeds..
These two examples, for JSP and PHP, display a summary of the last 20 orders from the IDS stores_demo database. They both use the following IDS 10.0 SQL query:
Five Minute JSP Informix RSS Feed
If you have a working Tomcat installation setting it up to work with Informix JDBC drivers is as simple as copying the JDBC jar files into $CATALINA_HOME/common/lib and restarting.
Customize the machine, Informix Server and links in this code and create a new Tomcat webapp. The resulting URL can be added to the Firefox toolbar as a Live Bookmark.
Five Minute PHP Informix RSS Feed
Here's the equivalent code in PHP. This example uses the Informix PDO Driver.
This should result in the same output as the JSP example.
The look of the XML output when viewed from a browser can be improved by using an XSL stylesheet, and various parameters such as refresh interval (TTL) can be tweaked. There are some good RSS tutorials and books available, or it can be fun to reverse engineer the stylesheet of your favourite news feed to see what they do.[Read More]