Richard Thomas has posted another Solar short with a quick tip on using the framework to cache data correctly (and under different prefixes) automatically even for multi-tenant sites.

This gets even more problematic if you support third party developers/modules as they have to follow the same rules as well. Head problems off at the pass by using the Solar_Cache prefix config. This bit of code would be placed as soon you "identify" the site in question and get some sort of unique id for that site.

All it takes is creating a Solar_Cache object (set into the Solar_Registry object) with the prefix for any and all scripts to pull out and use. This can even be used with the Solar models to cache data pulled from the database automatically.

Justin had written up a previous article with a few quick ways to secure your WordPress blog and he's come back with a few more helpful hints on how to keep you and your blog safe.

The following is a list of some additional changes that you can make to improve the security of your wordpress installation (Backup wp-config.php and your db tables before trying the following).

Here's his new list of recommendations:

• Change the default table prefix
• Install WP-Scanner
• Change permissions on the WordPress to only be writable by you and root

On the SaniSoft blog, Tarique Sani talks briefly about some of the prefix "automagic" that's already built in to the CakePHP framework's routing.

There are times when you need more than just admin routing, how about something like http://blah.com/user/profiles/edit and http://blah.com/user/profiles/changepassword ? If this could be routed to an action like user_add and user_changepassword wouldn't it be great!! (eg: think ownership ACL checks)

Good thing the CakePHP developers already planned for something like this - they included the connect() method for Router objects that maps the URL request to a method with that same prefix in the controller.

On DevShed today there's a new tutorial showing a method for preventing SQL injection attacks on your site - a MySQL table prefix changer.

Changing these [table] prefixes can be a tedious job if you had to do it manually. Even tools like phpMyAdmin don't provide a clean, quick method of doing this. But with a little help from PHP, we are able to create our own tool very quickly.

The tutorial follows the construction of the tool, making the modifications to the current database tables and pushing all of the changes back into the database.