Re: Why would you use MySQL with PHP instead of the native DB2 with PHP on iSeries

If it is new application development where you can define the schema then I think it is a push. You know the i database so I would lean toward native files. The PHP folks on the list with more experience in using the DB2 for i5/OS native interface in PHP can probably weigh in on the completeness of the support but I am guessing there isn't anything you can't do in DB2 for i5/OS that you can do in MySQL. Especially if you are at V6R1M0 (IBM i 6.1)

If you plan to use existing open source applications, then MySQL will be the easiest route since converting apps written for MySQL to another DB can be a challenge.

If the storage DB2 storage engine for MySQL were available, then you might want to lean back to MySQL for portability, but that would be about it.

Pete


Shannon ODonnell wrote:

The subject line of the email sums up the question:


Assume you are using Zend's port of PHP on iSeries with its os/400 - like
native database APIs.


Why would you choose to use MySQL database instead of the native DB2
databases with PHP when you're running PHP on the iSeries?


Is there something inherently easier in using MySQL with PHP as opposed to
using, say, a physical file?

I am at a crossroads where I could choose to do it either way. My
inclination is to use the native DB2 but I'm open to suggestions as to why
it might be better to use a MySQL database instead.


Thanks,


Shannon O'Donnell