This last month I’ve been up to the neck writing various CMS related things. First and foremost I’ve been focusing on my companys intranet basically rewriting it from the ground up. The last time I wrote it I had to put it together in a relatively short time frame, so it didn’t turn out that well. It didn’t scale properly and if you wanted to add a feature it meant quite extensive re-writing of the entire system. So that has been dealt with and a module system has been implemented.
In working on the intranet the question arose if we perhaps could use the eminent Drupal system. Since we need to use SQLite at work and there is no such support for that in Drupal I had to look into the possibility of writing a database schema for Drupal to use SQLite. Now SQLite is not ANSI SQL compatible, and so some things had to be done in the terms of parsing every sql query before sending it and, if needed, edit it so SQLite could understand. That was not the biggest problem, it turned out someone had already done that for me :). What made me turn back to my own solution was the simple fact that I didn’t have the energy to convert the file that contains the defenitions for creating the tables in MySQL.
I have also fiddled around some with Mambo, WordPress and Karlstadunix’s homepage. So to sum it all up, the PHP and SQL code that is currently pertruding my inner cortex is enough to put a sweet purple haze on the environment :).