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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.