Sample mariadb query with nodejs

testdb.js

var mariasql = require('mariasql');
var inspect = require('util').inspect;
var result = '';

var dbclient = new mariasql();

dbclient.connect({user: 'username',
    password: 'password',
    database: 'dlb',
    host: 'localhost'});

dbclient.query('SELECT * FROM dlb.SONGLIST LIMIT 5')
.on('result', function(res) {
    res.on('row', function(row) {
        console.log('Query result:', inspect(row));
        result += row.id + ',';
    })
    res.on('end', function(info) {
    	console.log('Query ended - ',result);
    	console.log('Info object:', inspect(info));
    })
    res.on('error', function(err) {
        console.log('Result error: ' + inspect(err));
        throw(err);
    })
});