Just posted an update, fixing a… bug that was introduced the last time I had time to do some updates. The bug effectively stopped all IDN-domains lists on MediaCreeper from being listed, this due to a quirky UTF-8 encoding problem between PHP and MySQL.
MongoDB
After a nice talk with my friend P about MongoDB I’ve been contemplating a bit over switching over, I have no performance issues with MySQL at all but if MongoDB is faster, I’ll go with faster.
I’m going to read up on MongoDB, experiment and fiddle around with it for a while before deciding which way to go… I guess it would reduce CreeperDataLayer a bit in code size and speed up serving data.
Tweaks
Today I’ve done some tweaking of MediaCreeper, a few internal changes to the database structures, to simplify and ease JOINs between tables. This is to prepare for goodies to come.
Image (the small badge) serving code has been revised somewhat to serve the image directly in stead of redirecting (302′d it) to the image. A few header values changed to prevent it from being cached. Creds to Pawal! 
CreeperDataLayer-, CreeperImageServe-, CreeperUtils- and CreeperTemplateEngine-classes has been modified to reflect all the internal changes made. Should be a little bit faster.
CreeperTemplateEngine were a bit wonky, compression did not always hit browsers successfully, with errors as a result — required you to reload page. Disabled compression until I get the time to oversee the code.
Widget should be online soon, almost working.
API should also be online soon, heavily reworked.
When updating some classes on the production server, I accidentally broke some code that are to be activated later, leaving MediaCreeper dead in the water for a minute or two, a simple fix — a configuration value were missing in the configuration file on the production server.
A little fuckup, theme-wise
I updated the theme on this blog without thinking, it updated fine and broke all the small tweaks I had done on the previous version. Duh.
So, I got a new theme that doesn’t require tweaks to look like something that I like.
A short summary of MediaCreeper-work done on my vacation: a little to non. I have tweaked the cache-layer a bit since my first hours of vacation when the site stalled out due to overload of MySQL-connections along with short TTL of cache. Switched from connect to pconnect to reuse connections, which now allows higher loads/amounts of hits on banner and visitors on the site. Also added code to export and purge logs at 90 days, I think 90 days is quite a long time on the internet. Today I switched the top-banner (AdSense) on the MediaCreeper site, from 468×60 to 728×90, required a few tweaks on the style-sheet .. The site might look a little wonky for a few hours as the style-sheet has a future expiry time, nothing breaks completely though.