What's the best practice with using Connections and connections pools in RDBMS databases in nodejs? Do we release the connection after the use or do we keep it?
I've used Knex.js. Tried Objection.js ORM. I just want to know how ORMs internally manage the db connection objects.
Founder of Big Machine and Tekpub. Author of The Imposter’s Handbook, creator of This Developer's Life, method speaker and Azure Developer[0] at @microsoft
Going to tackle this in the next post - but usually it's pool management at the driver level, which is hard stuff to get right. PG-Promise does this for you and you can tweak the pool size as you need... but best practice is to let the driver do it :).
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
What's the best practice with using Connections and connections pools in RDBMS databases in nodejs? Do we release the connection after the use or do we keep it?
I've used Knex.js. Tried Objection.js ORM. I just want to know how ORMs internally manage the db connection objects.
Going to tackle this in the next post - but usually it's pool management at the driver level, which is hard stuff to get right. PG-Promise does this for you and you can tweak the pool size as you need... but best practice is to let the driver do it :).