When should I open/close a connection to the database ? (MariaDB / node.js)

Question

I am using https://github.com/mscdex/node-mariasql

I've got these stages in the process of running a query on the DB :

var Client = require('mariasql');
var client = new Client();
client.connect(...);
client.query(...);
client.end();

When should I run these ?

Run the whole thing (except the require of course) on every query ? Keep one instance of client and keep it open all the time, and just run .query for every query ?

Thanks

mscdex · Accepted Answer · 2014-04-25 14:13:45Z

1

You should just need to query() for every query. Although if you want/need query concurrency > 1 then you should use a generic pooling module (there are at least a few on npm) to create a pool of mariasql connections instead.

answered Apr 25, 2014 at 14:13

mscdex

107k15 gold badges201 silver badges159 bronze badges

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

Collectives™ on Stack Overflow

When should I open/close a connection to the database ? (MariaDB / node.js)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related