Re: Question about Node.JS and XMLSERVICE

But "stateful" DB interfaces require some way of pairing multiple

​ ​
concurrent users with persistent DB connections. Do you write your own
​ ​
"connection" manager, or rely on a pre-built framework?

Are you talking about optimistic vs. pessimistic locking(n1)? There is
tooling for that in Rails(n2). I haven't looked into it for Node.js other
than just before sending this response, and I mostly found people asking
for the feature but not a lot of solutions.

n1:
http://stackoverflow.com/questions/129329/optimistic-vs-pessimistic-locking
​n2:
http://api.rubyonrails.org/classes/ActiveRecord/Locking/Pessimistic.html​​;


Aaron Bartell
litmis.com - Open Source and IBM i. No Limits.


On Thu, Aug 27, 2015 at 5:21 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Thanks for the reply, Aaron. But the question isn't about the syntax of SQL
paging. It's about how you manage DB state in a multi-user environment.

A number of IBM i Node.js examples follow a pattern something like:

var db = require('/QOpenSys/QIBM/ProdData/Node/os400/db2i/lib/db2');

db.init(...);
db.conn(...);
db.exec(...);
db.close(...);

But "stateful" DB interfaces require some way of pairing multiple
concurrent users with persistent DB connections. Do you write your own
"connection" manager, or rely on a pre-built framework?