Katharine Osborne

Author Bio:
Katharine Osborne is a web developer and writer in Honolulu. Katharine is the author of Data and Text Processing for Business Intelligence, available on Amazon. She teaches MySQL and database design at eclasses.org.

Tutorials written by Katharine Osborne:

Using MySQL Functions for More Efficient Web Applications
There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database. However, keeping the calculation in SQL means that the functionality is portable, and often means that less data needs to be retrieved from the database. Why not give yourself a choice and add MySQL functions and calculations to your coding arsenal? Here are five ways to get more power out of your MySQL SELECT statements.
Tuesday, 11th August 2009