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.
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.
Sometimes I have text files containing simple one line records that are used on more than one computer so they may get out of sync. For example, password files maintained on more than one machine, user records or the like.
"Free and Open Source Software" (FOSS) is behind the Internet revolution. Without FOSS, if it existed at all, the Internet would be very different and much smaller. It started with the protocols and basic applications but FOSS is no longer niche or the domain of geeks. Apache serves up most of the worlds web sites. MySQL provides the database to power many of the worlds websites and increasingly Firefox is being used by everyone to browse web sites.