Skoll is a Community-Based Testing project out of the University of Maryland. Their first testing framework comes for MySQL. Watch Sandro Fouché, graduate researcher on this project, take you through what Skoll is, how it's beneficial, and how you can use it with an actual demo. The Skoll testing client for MySQL can be downloaded here: http://www.cs.umd.edu/projects/skoll/contribute/

I know I've been away from the MySQL community for a bit....my hand injury is healing nicely, and I was able to concentrate time on things that required less typing and more mouse clicking. One such thing was the site overhaul of http://www.technocation.org to be easier to use on my side for things like embedding video and mp3 files. More user friendly for you, with regards to article names.

Thank you so much for your donation. It will help keep the all-volunteer Technocation, Inc. running smoothly.

I was pointed to an article about how the "one size fits all" database model doesn't work anymore -- how Oracle, DB2 and Ingres were written so long ago, they'd have to be rewritten to meet the needs of today's database users. Jacob Nikom pointed the article to me; apparently he contacted the author and started to explain how MySQL meets that criteria, but the author disagreed.

Read the article for yourself:
http://www.databasecolumn.com/2007/09/one-size-fits-all.html

Administrative note:

I had a bit of a mishap involving my hand and a glass door pane. The OurSQL podcast will be on hiatus for a few weeks as I recover. I injured my left hand, and I'm a lefty, so I'm typing one-handed these days. I apologize for the break in the show schedule, and hope you'll be able to hear new podcasts about MySQL very soon!

On Monday August 20th, 2007, the Google Summer of Code officially ended. I have had a great time this summer, although it has not always been sunshine and flowers! Because of the nature of the Summer of Code, setbacks due to lack of knowledge were not a problem. It's expected that the students don't know everything!

16:48 minutes (7.69 MB)

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

or use the Technocation forums:
http://www.technocation.org/forum

MySQLCamp is a free event available to the public, though geared towards the MySQL Community.  There is no fee for any participant, and workshops are presented by participants and chosen by the community. Last year, Google was kind enough to sponsor all of the logistics, from food to meeting space.  This year, Polytechnic University is providing the location -- and we're opening up sponsorship for the rest!

 Technocation, Inc. -- a US not-for-profit providing educational resources for IT professionals --  is sponsoring a donor campaign for MySQLCamp II, to take place from August 23-24, 2007 at Polytechnic University in Brooklyn, NY, USA.

What if last week's announcement by MySQL had been the following?

Some major MySQL distributors have brought some issues to our attention. These distributors have been legally distributing the Enterprise version of MySQL to folks that do not have a MySQL support contract, without their knowledge or consent.