All other little handy tips that can’t really fit in any specific category


Photography technique, tutorials and equipment review.


Tips, tutorials and solutions for Windows, Macs, Linux, Servers and Media Centers. Get the very most out of your computer. Resources for all levels from newbies and techies.

Web Design and Development

Tools, tech tips and tutorials for web design and development. Including wordpress plugins and tweaks.

Tools and Productivity

Software, web applications, scripts and tools to make your computing, design, development or networking experience more easier, enjoyable and productive.

Home » Archive by Author

Articles by Edwin Kwan

Edwin Kwan is the founder and editor of Little Handy Tips and Wollongong Fitness. He is also the developer for the Google Custom Search WordPress plugin and Custom About Author WordPress plugin. He also has a keen interest in Photography . Find out more about him here.

SQL: Difference between DELETE and TRUNCATE

One of the questions I got asked today is what the difference is between the SQL commands DELETE and TRUNCATE. So here we’re looking at the differences between DELETE and TRUNCATE.

Postgres/MySQL – How to Show A Specific Range of Rows


In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows. This is done using LIMIT and OFFSET. The examples in this article demonstrate how they work.

How to set date and time on Solaris

Here are examples on how to set the date and time on Solaris

The Future of Email Etiquette

courteous-email is a new service which allows you to tell your friends what level your email load is in real time. It allows your friends to know when is best to email you. The future of email etiquette perhaps.

Google Adsense: Optimisation Tip for the Month

This month’s Google Adsense newsletter talk about how to enhance your website’s user experience by using custom search engine. If you are using wordpress for your website, the easiest way to do this is by using the Google Custom Search Wordpress Plugin.