As applications are getting more complex and manipulating data in more complex ways it’s becoming more important to optimise our database queries to be as efficient as possible. This article shows how more explicit queries can reduce execution time and take some of the strain off system resources.

Django is a fantastic Python framework with numerous methods to render forms. In this short article I will be showing you how to determine if a form field is “required” or not.

A small function to produce Twitter like dates from various date formats. Just feed it a date, it converts it to a time (a unix timestamp), works out the difference and returns a “nice” formatted date i.e. About 1 week ago. Hope this helps.

In this article I will cover how to convert a date from such things as a database like MySQL, RSS feed or other formats into a UNIX timestamp.

A short guide on how to enable CakePHP auto completion within the Aptana Studio or Eclipse PDT IDE for Models within controllers and helpers. This actually works!

A quick guide to one of the most useful MySQL functions. The replace function is a great way to find and replace bulk text matches in one easy step.

WP Post To Twitter: A nice simple Twitter Wordpress plugin for your blog. Allows you to Tweet from your blog and automatically updates Twitter when you create a new blog post.

Have you ever heard of an SQL injection attack? Ever wondered how it’s actually done? Well take a look at the video in this post to see one in action!

At the start of the year I wrote an article over on another site detailing the different methods you could use to select elements using the powerful jQuery attribute selectors. Because I no longer work for that company any more and the article is no longer being maintained, I’ve decided to create a second version of the article so I can update it and extend it’s usefulness.