I am sometimes asked about my naming convention for MySQL. A clear naming convention has been essential for me for years because it is sometimes years that pass before I have to revisit some database that I wrote or modified for a client.
So here it is...
Last Updated on Monday, 07 February 2011 16:54
Using tar for full and incremental backups
There is a lot of confusion about tar when it is used for incremental backups. There are plenty of utilities that attempt to automate backup and restoration but often, in their attempts to make it simpler they make life harder.
Last Updated on Tuesday, 26 October 2010 17:54
Password protecting a website folder
Sometimes you just need to do this directly. There are lots of utilities in server administration programs such as cpanel, plesk or virtualmin that will do this for you but if you have shell access here is the quick way.
The Solution To Global Warming
Today we see governments planning to spend hundreds of billions of dollars on schemes that might delay global warming by a scant few years at best. To put these schemes in perspective, look at the population increase which is a little over 200,000 people every day. That is a brand new good sized city every fortnight.
The only practical way to address the human factors involved in global warming is to reduce the human population on the planet.
Everyone can see that there are plenty of resources to support us and our descendants virtually forever. Just look up.
Last Updated on Thursday, 09 September 2010 10:52
Adding Image rotator PHP code to Magento
If you want to display something relating to products or files that is not covered by an existing Magento block, you may need to write some PHP to do it. In my case I needed an image rotator to cycle through some images. There are plenty of examples of rotators on the web and a few hints on doing it with Magento but I wanted control and I wanted to understand it so...
Last Updated on Friday, 06 July 2012 14:58
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.