The CakePHP team has included the ibm_db2 driver that I submitted in the latest 1.2 development branch.
I’ve sent out a call for alpha testers to put it through its paces.
You can get up and running quickly by:
- Extracting the sample application (thanks Nate) which provides a skeleton for working with CRUD operations and table associations (hasOne, hasMany, belongsTo, hasAndBelongsToMany) to your “app” directory.
- Creating a database.
db2 => CREATE DATABASE CAKE USING CODESET UTF–8 TERRITORY US
- Creating the database tables from the DDL.
[email@example.com]$ db2 connect to cake
[firstname.lastname@example.org]$ db2 -tf db_test_db2.sql
- Updating your database.php configuration.
var $default = array(
‘driver’ => ‘db2’,
‘connect’ => ‘db2_connect’,
‘host’ => ‘localhost’,
‘login’ => ‘db2inst1’,
‘password’ => ‘password’,
‘database’ => ‘cake’,
‘prefix’ => ”,
‘encoding’ => ‘UTF-8’
- Retarting your Web server.
Please try it out and submit your bug reports to Trac with “DB2” in the title. Information on the particular database product, platform and version you are using would be helpful as well.
I’ve just completed the initial version of the IBM DB2 interface that I’ve written for the CakePHP framework.
There are some wrinkles to iron out, so stay tuned. We’ll be sending out a call for alpha testers shortly.
I believe that makes it a clean sweep:
[Insert snarky comment here about lack of AHE hosting options or WSG documents for PHP applications.]