It may not sound like much of an accomplishment to those people out there with database experience, but I’m well on my way to hooking up the web frontend, Python heavy-lifting and application server (WebKit), and the sweet MySQL database backend. I’ve got all the pieces working and talking to each other, playing nicely, etc. Now the only things left to do are to create the production tables, populate them with current data, and re-write some of the Python data manipulation code that’s pulled from WebKit.
And this is just one of the many reasons that Python rules: query the LDAP server, get all contacts, write tab-delimited line for each in a huge text file, then call the “load data local infile” through the MySQLdb module… all in one handy-dandy little method. It’s fuckin’ brilliant.
On the down side, I couldn’t get Webware’s “MiddleKit” component to work properly. But, that’s probably for the best; I really should learn the ins and outs of SQL. Also, no mail client integration with the MySQL contacts database, which is blindingly fast compared to the shoddy OpenLDAP installation we’ve currently got running. That mail client thing is sure to be a sticking point… I may have to learn how to construct schema and install/upgrade the goddamned LDAP server after all.
People at work can be so whiny sometimes.