× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Interesting - glad to see it is still alive. Not of any help to me though. There's not likely to be a binary for IBM i and I'm not interested in compiling it myself. It was Oracle dropping IBM i support that forced Zend to come up with the ZendDb (their binary of MySQL) and subsequently to switch to MariaDB.

I'll stick with Db2, the older MySQL and MariaDB.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 4, 2018, at 2:16 PM, Steve Richter <stephenrichter@xxxxxxxxx> wrote:

excellent article on mySQL
https://modern-sql.com/blog/2018-04/mysql-8.0

author says the just released mySQL 8.0 is a solid database.


On Fri, May 4, 2018 at 2:04 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Until Oracle bought it, MySQL was, while not bleeding edge, a very capable
database. In fact for web apps it had features such as result set offset
capability that only just came to DB2. But for Oracle if it was further
enhanced it was just a threat to their main product. Hardly surprising that
it now lags in features. Maria, once it got up and running from the ashes,
has started to move it forward again but it will take time.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 4, 2018, at 1:50 PM, Steve Richter <stephenrichter@xxxxxxxxx>
wrote:

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

----------------------------------------------------------------------

message: 1
date: Fri, 4 May 2018 10:57:18 -0400
from: Steve Richter <stephenrichter@xxxxxxxxx>
subject: [WEB400] mysql does not have table functions?

is that true, mySQL does not support functions that return tables? Was
expecting mySQL to have more features than DB2, not less.



--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.


--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2024 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.