For detailed information about this and other Node.js database bindings visit the [Node.js DB homepage] homepage.
Before proceeding with installation, you need to have the Drizzle libraries and include files. In order for the installation script to locate them properly, you'll need to set the DRIZZLE_INCLUDE_DIR and DRIZZLE_LIB_DIR environment variables. For example:
$ export DRIZZLE_INCLUDE_DIR=/usr/include/libdrizzle
$ export DRIZZLE_LIB_DIR=/usr/lib
Once the environment variables are set, install with npm:
$ npm install db-drizzle
var drizzle = require('db-drizzle');
new drizzle.Database({
hostname: 'localhost',
user: 'root',
password: 'password',
database: 'node'
}).connect(function(error) {
if (error) {
return console.log("CONNECTION ERROR: " + error);
}
this.query().select('*').from('users').execute(function(error, rows) {
if (error) {
return console.log('ERROR: ' + error);
}
console.log(rows.length + ' ROWS');
});
});
This module is released under the [MIT License] license.