Proper architecture for Node.js modules and database connectivity?

Question

I'm writing a Node app that accepts TCP connections. I have a few separate Node modules (utilizing the exports functionality). Each needs a database connection to handle some of their functionality.

What's the best way to architect/handle database connections? Should each module create a separate connection or should my main JS file pass in a database connection handler to the modules when I require them?

The question is too hard to answer without more specific details, however feel free to visit the node.js chat room for more detailed discussion — Raynos
– Raynos, Commented Jul 4, 2011 at 20:33
I agree my question is very general, but this type of architecture is probably common in Node.js apps. Most will require() many installed and custom modules, I assume someone has tried either way before and has experience in the flexibility and robustness of each method. — Ryan Doherty
– Ryan Doherty, Commented Jul 5, 2011 at 19:30

Andrey Sidorov · Accepted Answer · 2012-07-24 05:54:51Z

6

imo best approach is to initialize connections pool and use it in modules passing as parameter. mysql-pool is quite generic and easily adaptable to any db client

upd: node-pool is a generic db-agnostic pool

edited Jul 24, 2012 at 5:54

user1547603

answered Jul 5, 2011 at 1:51

Andrey Sidorov

25.6k5 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

alessioalex Over a year ago

Actually I think using github.com/springmeyer/node-pool is better, since it's more general than just using a mysql pool (you can use it with all kind of dbs).

Ryan Doherty Over a year ago

I agree, I've started rewriting my code this way and it required very few changes. Allows for the modules to ignore database connection configuration, which IMO is a good thing.

James Cooper Over a year ago

springmeyer/node-pool seems to 404, but I wrote a node.js pool library that is available from NPM and has gotten a fair amount of use: github.com/coopernurse/node-pool

Collectives™ on Stack Overflow

Proper architecture for Node.js modules and database connectivity?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related