larvitdb

larvitdb

DB pool wrapper for node.js This module is used to share a mysql/mariadb pool of connections between modules, classes, files etc.

It also logs with winston if there is a database error, so you do not need to fetch the database error manually each time.

Installation

npm i larvitdb

Usage

The module must first be required and then configured. Make this in your main application file:

var db = require('larvitdb');

db.setup(
	{
		"connectionLimit":   10,
		"socketPath":        "/var/run/mysqld/mysqld.sock",
		"user":              "foo",
		"password":          "bar",
		"charset":           "utf8_general_ci",
		"supportBigNumbers": true,
		"database":          "my_database_name"
	}
);

See a full list of possible options here. Then you can just require the module in your other files for usage, like this:

A direct query

var db = require('larvitdb');

db.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
	console.log('dbmodel: The solution is: ', rows[0].solution);
});

Or, if a connection is needed:

var db = require('larvitdb');

db.getConnection(function(err, dbCon) {
	var sql = 'SELECT * FROM users WHERE username LIKE ' +
	    	dbCon.escape(postData);

	dbCon.query(sql, function(err, rows) {
		dbCon.release(); // Always release your connection when the query is done

		if (err)
			throw err;

You dont need to get a connection to escape though. You can do like this:

var db = require('larvitdb');

db.query('SELECT * FROM users WHERE id = ?', [userId], function(err, results) {
  // ...
});