Oh, I didn't mean to dis node in general at all, I'm a big fan of it 😊 and for developing front end stuff it's great. It's really just the lack of vendor support for database drivers and the lack of a consistent interface to them which is frustrating if you come from JavaEE where JDBC drivers are consistent and well supported, but they've had years to get it right - Node is still a baby by comparison. As I say, given the chance, I'd migrate my framework to Node, I much prefer to work in Typescript than Java and I wouldn't need a Java EE host, but I would be migrating from a very stable environment with cross platform support and right now I don't feel it's worth the investment.

From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
Sent: 16 March 2018 17:31
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] What forum is best for a Tope and Node question?

I see.

Your original statement that Node is still " somewhat experimental" is probably not far off. Your description of the Node ecosystem makes it sound like the wild west. Like Kelly said, Profound is pushing it, but things are probably different in their vendor-supported bubble.

-----Original Message-----
From: Tim Fathers [mailto:X700-IX2J@xxxxxxxxxxx]
Sent: Friday, March 16, 2018 10:46 AM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] What forum is best for a Tope and Node question?

Well, let's say you want to target DB2 (not just on the i) then there are a number of DB2 drivers, none of which appear to be officially supported, the most popular one seems to be "ibm_db", however, this doesn't support the retrieval of metadata from a stored procedure call, which is necessary if you wish to communicate back to the webservice caller the types and sizes of the parameters and result set columns. IBM do have a native driver I think, which I suspect does allow metadata retrieval, but this then means you have to run your NodeJs server on the IBM i and can't develop it locally and get all the benefits you get on the PC, like a reloading development server when the code changes and a nice debugger (I've not tried using a remote debugger on IBM Node, which might make debugging a bit less painful). In Java EE, I can develop on my PC in the IDE, run a Tomcat instance locally and use a local copy of DB2, MySQL or whatever, or even point to my IBM i just by providing th
e right JDBC driver and connection options - my code stays exactly the same. This also means that simply by providing different DB connection resources in TomEE the same webservice can execute SPs on completely different databases seamlessly.

Coming back to Node, if you look up drivers for SQL Server, for example, there don't seem to be any officially supported ones. Furthermore, the APIs for each driver are often completely different so you have to write specific code for each database, or worse still, driver that you wish to use. Also, TomEE has a build in database connection pooling facility, in Node on the other hand, some drivers have it, some not, then you have to find your own pooling solution.

If anyone knows better or I've missed something obvious I'd love to know, as I said, I'd prefer to rewrite my framework in Typescript and run it under Node then I have all the code under one roof as it were, but it just doesn't seem that straightforward.

From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
Sent: 16 March 2018 15:45
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] What forum is best for a Tope and Node question?

" unfortunately and relational database support in Node is a little bit poor in general"

Can you elaborate? I have a proof-of-concept Node app running natively that accesses Db2 & SQL Server. It seemed to work OK for me.

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://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7Cfff7f74bae6747284f2c08d58b5b69bd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636568147081151763&sdata=yRrtUrBQ0vNAtAxtDMK2l8spC1HhqxmGaL5k2163ULM%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7Cfff7f74bae6747284f2c08d58b5b69bd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636568147081151763&sdata=MQCXlNARsSPvyNGo8KWXlFfqeo2T6eIJJ5kug3f4Zgg%3D&reserved=0.

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