Re: MySQL, DB2 and ORM (Node)

So yes, you can download ZendDBi (MySQL 5.1) from the Zend Website for no charge without downloading Zend Server. https://ww2.zend.com/en/products/dbi/downloads

Yes, I know that is an older version of MySQL but like I said earlier, WATCH THIS SPACE for news.

:-)

Mike


-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Wednesday, January 13, 2016 12:29 PM
To: Web400@Midrange. Web400 <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] MySQL, DB2 and ORM (Node)

The only current binary for MySQL on IBM i is the ZendDb supplied with ZendServer. Not sure if you can download just the ZendDb component - I’ve never needed to.

The DB2 engine works well but only use it for those specific tables where you need to be able to access the data with native I/O methods. It does present an additional point of failure as both the DB2 and MySQL components of must remain “intact” for it to work. I once made the mistake of thinking “What the heck is that?” and deleting an apparently spurious table - forgetting that it was the DB2 storage component for a MySQL table - fortunately it was only a playground so no damage done.

On Jan 13, 2016, at 6: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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

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