July 30, 2011 | In: javascript, mongodb, node.js
On Tuesday I did a presentation for the Pittsburgh JavaScript Developers Meetup group about using Node.js with NoSQL - or document based - databases. I chose MongoDB because it's got great traction and there's a Node module for it named...
May 19, 2010 | In: coldfusion, oracle, paging
I learned something new today. Using ROWNUM in an Oracle query, while it does limit the resultset to the number specified, does not limit it to the top n results. It’s basically a random sample because it appears that ROWNUM is calculated...
February 25, 2010 | In: coldfusion, oracle
Figured this one out by sheer, dumb luck. driverManager = createObject("java","java.sql.DriverManager"); conn =...
An old client of mine recently contacted me with a problem. Their home page, several sub-pages, and the administrative section weren't displaying properly and functionality was broken. Turns out, they were a victim of the recent swarm of SQL injection...
I just discovered, about 4 days ago, that you can format Visio database diagrams in the IDEF1X format. While IDEF1X has many shortcomings, I have to say I find it much easier to understand the relationships and constraints at a quick view in this format...