​>I was looking at creating DB2 support for Waterline but it occurs to me
that would be a waste of time.

I agree MySQL can be used for stop-gap. I've done it once a number of
years ago.

Opinion: MySQL-to-DB2 should only be used as a stepping stone. I say this
because MySQL adds another point of failure and addtl maintenance. Our end
game should be to have Waterline support DB2 for i.​

Opinion 2: I would *assume* expounding on this DB2 LUW Waterline
adapter(n1) for DB2 for i support would be less work in the long run than
an intermediary MySQL instance. Have you looked at the DB2 LUW adapter for
Waterline to know where issues might be?

Further, Tony Cairns and I (n2) are working on a new project named
db2sock(n3) that may help this need (eventually).

n1 - https://github.com/IbuildingsItaly/sails-db2/blob/master/index.js
n2 - Tony is the brains, I give commentary. Though I hope to do some
coding on the project.
n3 - http://bit.ly/litmis-db2sock See this for project direction:

Hopefully you don't see my response as highjacking your thread. Just
hoping we can build something that many will use.

Aaron Bartell
litmis.com - Services for open source on IBM i

On Wed, Jan 13, 2016 at 5:23 AM, Kevin Turner <kevin.turner@xxxxxxxxxxxxxxx>

I think I am a bit late to the party with regard to MySql on the IBMi.

Does anyone have any experience of implementing and using it?

The reason I ask is that I am developing in Node on the IBMi, particularly
with a Node framework called Sails (an embellishment of Express and other
libraries). One of the things that Sails uses is an ORM called Waterline
that supports several different databases, but not (surprise surprise) DB2.

I was looking at creating DB2 support for Waterline but it occurs to me
that would be a waste of time. As I understand it, MySql supports a DB2
engine (as well as InnoDB and MyISAM etc) - so I should be able to use it
'out of the box'.


NOTICE: The information in this electronic mail transmission is intended
by CoralTree Systems Ltd for the use of the named individuals or entity to
which it is directed and may contain information that is privileged or
otherwise confidential. If you have received this electronic mail
transmission in error, please delete it from your system without copying or
forwarding it, and notify the sender of the error by reply email or by
telephone, so that the sender's address records can be corrected.


CoralTree Systems Limited
25 Barnes Wallis Road
Segensworth East, Fareham
PO15 5TT

Company Registration Number 5021022.
Registered Office:
12-14 Carlton Place
Southampton, UK
SO15 2EA
VAT Registration Number 834 1020 74.
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

This thread ...


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

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