I would think if you're mainly using SQL in your PHP business object layer it would be relatively easy to port to a hosted provider as long as your SQL is using methods supported by DB2 or MySql, Postgres, SQL Server etc.
The difference will always be with stored procedures. If you're using Sprocs all bets are off regardless of platform. There will be some re-work guaranteed.
You could always write the app to use MySql over DB2 on IBMi and then it would be very easy to port I would think if you stick with MySql/MariaDb.
If you're going for multiplatform you might consider MySql/MariaDb or Postgres as the DB options of choice unless you'll be hosting on Windows servers. Then SQL Server could make sense. Although SQL Server does now have a new Linux version as well.
SQLite is cool too if you have a low-volume app because it doesn't require a backend DB server running. This could work nicely on one of the low cost hosted environments like Linode or Amazon EC2/Lightsail or Azure.
Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
-----Original Message-----
message: 2
date: Fri, 4 May 2018 13:50:02 -0400
from: Steve Richter <stephenrichter@xxxxxxxxx>
subject: Re: [WEB400] mysql does not have table functions?
hi Richard,
the use case is that since I am writing all my IBM i apps now with SQL and PHP on the server side and javascript in the browser, what is the feasibility of porting that server code to a web hosting site that runs PHP and mySQL.
but watch this video
https://www.youtube.com/watch?time_continue=2003&v=nFfS1HmiWCM
mySQL does not support much at all.
On Fri, May 4, 2018 at 1:03 PM, Richard Schoen < Richard.Schoen@xxxxxxxxxxxxxxx> wrote:
Out of curiosity can you describe your use case ?
Normally I run SQL or SProcs and they return a data set which my app
can consume.
Are you wanting to output to a new table in the DB or something else ?
Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
midrange.com
