Re: MySQL, DB2 and ORM (Node)

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

​>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:
http://bit.ly/litmis-db2sock-design-discussion

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

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