The MySQL GROUP_CONCAT function isn’t a well-known feature, but it is one of the most useful functions that exists in MySQL. I call it the “loop-killer”. Here are a few ways to put it to use on your site.
Fun with SQL Injection
There are dozens of different ways to be a victim of an SQL injection attack. This article offers a more example-driven approach to learning about SQL Injection and how to avoid it.
Using Lazy Definition to load JavaScript libraries on demand
With the number of amazing JavaScript libraries out there, it’s tempting to overload our pages with http connections that load these scripts and immediately execute them. We can spare our user’s bandwidth and page load time by combining two popular techniques.
The back button cache – taming it with HTML 5
The browser back button has been a thorn in every web developers side since the early days of the web. HTML 5 storage offers us a unique way to avoid using AJAX to updated certain page elements in the event that the back button is pressed.
Hand some validation over to your database
Performing validation at the database level not only protects the integrity of our data, but also presents a performance enhancement while simplifying our application code.
HTML Frames – they still have some life in them
Frames were omitted in the HTML 5 spec, but browsers still support them. I’m not ready to give up the very specific capabilities provided by frames to specific types of applications.
Storing UI preferences on the client side
AJAX has been a blessing, but with the vast majority of browsers now support HTML 5 storage, we have an opportunity to enhance web user interfaces in a more efficient way.
Prefer conditional loading of social network scripts
Are you loading social network button scripts on your site unnecessarily, and increasing your page load time in the process?
Persisting form field data between page loads
Maintaining the values in form fields between browser sessions has never been easier with HTML 5 Storage. It can go a long way towards enhancing the usability of your forms.
Top 10 Things to Check Before Launching a New Website
After almost 15 years of web development, these are the 10 things that I consider most important or most often forgotten when preparing a website for a launch.