For detailed information about this and other Node.js database bindings visit the Node.js DB 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.