Re: MySQL, DB2 and ORM (Node)

Thanks Aaron - will have a read through

-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: 13 January 2016 13:38
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] MySQL, DB2 and ORM (Node)

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

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


___________________________________________
This email has been scanned by iomartcloud.
http://www.iomartcloud.com/


________________________________

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.