Apr 09
5
Clay Framework Status Update
I’ve been grinding away at the ClayDB abstraction layer, but it’s mostly been experimenting. I do have some solid methods going and have began adding the new calls here in there for testing though. So far you can do anything basic with a single line of code. For instance:
$profiles = $db->get(‘fname, lname, jdate FROM profiles WHERE userid = ?’, array($userid), ’0,1′);
will give you one row as:
$profiles['fname']
$profiles['lname']
$profiles['jdate']
delete(), update(), and add() are available as well. I hope to be able to implement something similar for transactions, more than likely splitting the queries with arrays. I have other plans as well, but those are the ones I’m worried about for now.
I kept bouncing back and forth on whether or not to go forward with ClayDB, even replacing Creole with dbFacile and then undoing it. Needless to say, I’ve prolonged the inevitable and ended up only wasting time. Fortunately, ClayDB is the fastest I’ve used so far (for development and performance), I guess time has to be made up some how.
I’ll try to start posting a little more regularly… no promises though.