I need to do 'select for update' in postgres database from node.js, i.e obtain a cursor, iterate on it and updating values if needed.
I don't know if it is even possible in node.js and how.
I have found https://github.com/brianc/node-pg-cursor which seems good for reading cursor, but nothing for updating it.
Is there a module or pattern that can achieve this ?
Many thanks
As of today, there is no implementation for this within Node JS platform, so your only viable option is to implement it within a Postgres function and then just call it from Node JS.