I’m still working on it I’ve cleaned out a lot of test code and transitioned entirely to ClayDB. Currently ClayDB only has an inteface for queries through the PDO_MySQL driver, but it should support SQLite soon as well. I decided to start out with PDO, instead of the native drivers, but I plan to eventually add support for mysql and mysqli. PDO has quickly become my favorite though.

I’ve been toying with the DataDictionary, but real life work has hampered my efforts in getting a lot finished on Clay lately. One of the features I’ve experimented with is type casting DB fields. Basically, if you need a primary key column you just specify ‘id’ as the field type and the class fills in the rest when the table is created. Same goes for when the needed field type is ‘string’, ‘numeric’, ‘integer’, or ‘boolean’. One of the ideas for later on is to map types so when you create a table the data types are always validated for queries.

I’ve done a few other things here and there, but those are the most significant. Until next time…

Tags: Clay, ClayDB, DataDictionary, PDO

This entry was posted on April 15, 2009 at 11:20 pm. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in Blog by David Dyess II No Comments Yet