Jonathan Lynch

To enable the Notejam application to use MySQL in dev while still using SQLite in test, I wrote a mini conversion driver that made the same object compatible with either database. This reduced code duplication (and was also fun).

var settings = require('./settings');
if(settings.env == "dev") {
var db = require('mysql').createConnection(settings.dsn);
// mini sqlite -> mysql conversion driver
db.run = function (sql, params, cb) {
sql = sql.replace("AUTOINCREMENT", "AUTO_INCREMENT");
sql = sql.replace(/default current_timestamp/g, "timestamp default current_timestamp");
references = /,([a-z_]+) ([A-Z ]+) REFERENCES ([a-z(]+\))/g;
foreignkeys = [];
while(match = references.exec(sql)) {
foreignkeys.push("FOREIGN KEY (" + match[1] + ") REFERENCES " + match[3]);
}
if(foreignkeys.length > 0) {
sql = sql.replace(/REFERENCES [a-z(]+\)/g, "");
sql = sql.replace(");", "," + foreignkeys.join(',') + ");");
}
this.query(sql, params, cb);
};
db.close = function (err) {
this.end(err);
};
}
else
var db = new sqlite3.Database(settings.db);

An old script I put together to help centralized logging. Some applications don't play nice with syslogd, so I wrote a Python program that can "syslog-ify" any application. The first thing I pointed it at was an oracle database, which likes to spit out a separate trace file for every event.