0.0.5 • Published 11 years ago
rdbql v0.0.5
node-rdbql
(yet another) SQL syntax helper for node.js
This package isn't available via npm, the basics arent't all there yet. The idea is to get sqlite3 and mysql up and running for the following statements: create table, select, insert, update, delete.
sqlite3 works for all except delete; MySQL support has not been tested yet.
Why?
Applications using a RDBMS of some kind quickly get messy when building SQL "from scratch".
That's a fairly complicated piece of code, to do very little: no validation, supports AND-only filtering, parameter binding syntax is hardwired... Maintaining a DAL this way is not nice at all.
With node-rdbql, the previous example might be written like this: