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

[Pete Helgren <Pete@xxxxxxxxxx>]

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
>
>  
>
>  
>
>