Viewing posts by Paul Whipp

There are no such things as gremlins

My best development PC has been plagued by rare data corruption problems that occur most often when updating or handling large files. They were so rare (half a dozen times a year) that I lived with them - until some substantial overnight file processing started hitting issues almost every time I tried it.

Sorting Magento Categories Alphabetically with MySQL

Magento (1.4.01) uses an EAV model which makes its database potentially confusing. EAV is very efficient for sparse matrix applications but is probably a case of the Magento developers being too smart for their own good when it comes to an ecommerce solution. Magento's EAV solution is also somewhat of a half way house, probably because not all of their developers saw things the same way. This can make things doubly confusing.

Business automation

Automate your business processes online

I can help you save time and improve your business.

Securing passwords

I have around 100 passwords for various websites and the like. Keeping track of them used to be a pain but it is now quick and convenient. I'm going to describe how I solved this problem with a simple secure solution you can implement for yourself with a 28 line bash script.

Using copies of Joomla sites to safely make and test content changes

When we need to make significant interdependent changes to content on a live Joomla site, working on a copy is the only safe option. If you do not use a copy then the work in progress or any mistakes could break the live site.

Australia: 07 3103 2894

International: +61 410 545 357