Besides the small security increase by using limit (destructive queries can only affect x rows), there are some performance benefits as well. Consider the following queries: select field1, field2 from Product where ProductID = 1; update User set Firstname = ‘jim’ where UserID = 3; MySQL will update the row that matches the ID, but [...]
I have been writing a special web application framework around the n-tier pattern, and in the database layer I ran into a problem with MySQL. Within a stored procedure you can order by a variable but not limit by a variable, which puts a small damper on pagination. There are many threads on the Internet [...]
I spoke to a friend recently who had a nightmare story in osCommerce, where when a new customer signs up, another customers details appeared in their address book. What had happened was the store was copied from another live store, and had the database erased, however entries in the address book table were left. As [...]
I haven’t blogged for so long, I’ve been slacker than Scott! To break the drought, I should blog about something worthwhile: Google Wave. http://wave.google.com/ I applied for it today and wrote them a heiku. Google wave sounds good Maybe I can try it out I would be thankful!
The hard economic times that we are coming into, that may be called “The Greater Depression” by some, will affect many industries, but I thought I would comment on my thoughts regarding IT in such an environment. Already the steel industry world wide has cut production by 1/3, and a secondary / tertiary industry such [...]
There are many caveats and pitfalls with websites that people need to be aware of. Having been in IT for over eight years, here are a five main things to watch out for that I have found. Used Terms Domain: is the name for the site you type into the address bar, such as http://thewebsiteguy.com.au. [...]
I had an EXTREMELY annoying error today on my laptop. I have a number of partitions to seperate Windows, data etc so that I don’t have to backup any data to reinstall Windows (which I frequently do for many reasons) and to help reduce fragmentation etc. Picture: Vista’s disk manager. Note that Vista home means [...]
There’s a new open source eCommerce product out called “Magento”. Website Link http://www.magentocommerce.com I will install a version this weekend if I can to see what it is like.
I installed OpenSuSE 11 today to replace Windows Server 2008 Enterprise. All up it only took about 2 hours to install and configure including Subversion, Samba, Web and MySQL. It feels to good to have it back. I’ll note the specs of this machine: Athlon 2800+ Asus A7n8x Deluxe 2gb RAM GeForce 7600GT 120Gb WD [...]
I got fed up with Windows Server 2008 for the last time yesterday, and I will start the migration back to OpenSuSE Linux on my home dev server. It’s up to version 11 now, so I will install that, even though it’s a pain to export subversion, files and databases. What tipped me over the [...]