Another day - nothing done
Another day without real writing or coding accomplished - that’s the trouble with kids and real life.
Today I continued working on a baby blanket I started knitting with my second son (it was pink) - and I stopped after I found out it was a boy. I started it up again with the third baby, until I knew he was a boy. I didn’t even start the thing this time until I was sure it was a girl 
So now I’m finally finishing the darn thing. I already finished a half-started baby dress I was knitting - also started (and stopped) with the second baby.
I’m one of those people with a dozen or so projects laying here, there and everywhere, so I suppose it’s a good thing I’m getting some projects finished. However I need more hours in a day to get everything accomplished.
I watched “dancing with the stars” tonight and laughed my head off - although Jerry Rice was much better than I thought he would be..it made me a little angry that master P didn’t even try…
Anyway - I found an interesting post http://www.xaprb.com/blog/2005/09/28/simulating-the-group-concat-function/ - since mysql 3.23+ allows these user variables I may have found a way to fake group_concat - I’m still trying to add support for mysql < 4.1 for the mysql and pdo drivers. I’m not putting it into the mysqli driver, but I am adding the emulation to the mysql driver. For pdo it just means finding a way to fake group_concat and dealing with subqueries (I have that working well, just need a better way to handle subqueries + prepared statements…ewww), it might actually be easier with mysql since I’ll have to emulate prepared statements completely so I have more control.
Right now my list of planned db drivers includes mysql, mysqli, pdo_mysql, pgsql, pdo_pgsql, sqlite, pdo_sqlite, mssql, odbc_mssql, pdo_mssql, pdo_odbc_mssql (annoying), oci, pdo_oci, sybase, pdo_sybase, firebird, pdo_firebird - I might add some more later as drivers are requested, but these happen to be dbs I can install and test on windows fairly easily. I’m not quite sure what versions I’ll support yet, although I’d like to make it a fairly wide span I’ll probably have to limit things a bit. I had quite a bit of an abstraction layer written, however since I redid the system to make use of driver/statement/manager classes quite a bit of the old stuff will have to be rewritten. However I almost enjoy writing this stuff. My biggest quest for each set of db classes is to support identical api and hide the backend emulation - while keeping both the feature set and the code down to a small size.
There are several db abstraction classes out there (mdb2, adodb, pear::db) but none are 5.1, and none run along the pdo api, and all of them are HUGE in both size and features. Which is why I’m stuck writing my own stuff. So far the pdo drivers have gone together FAST - the sqlite stuff was easy as well, I could just write php functions to emulate anything I needed. The only big problem with sqlite has been handling foreign keys with triggers - something I’m working into the manager class (since you really can’t do a generic trigger - it needs to be written for each table) - that might get heavy but it’s the best solution I’ve come up with so far.
And if I see one more commercial for AOL I’m gonna puke - they charge way too much money for what you get, and the thing that makes me angry is they’re preying on the computer idiot. I feel really sorry for those without that family geek (I think that was something my in-laws really appreciated - someone to answer questions and fix problems)
