OpenSQLCamp Video: How SQL Database Engines Work

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.


Moving Application Logic Into the Database by Bruce Momjian

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at

How to Stop Hating MySQL

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

View the video online at (or watch it at the bottom of this page).

Here are some notes and links I referred to:

Technocation, Inc containing free videos, a MySQL podcast (currently on hiatus) and blog posts about MySQL.

The State of Open Source Databases: OpenSQL Camp Keynote Featuring Brian Aker

Brian Aker delivers the keynote speech at OpenSQL Camp: State of the Open Source Databases.

The presentation begins with:
"There is no way I'm going to tell you exactly where the future of databases go. We have way too many egos in the room to ever even begin a discussion..."

and ends with Aker saying,
"What the hell does that mean?"

My summary: open source databases are already ubiquitous, we need to make them better/faster/consume fewer resources.

Brian's summary: What part of my keynote surprised people? How ubiquitous bot nets are, and how they act as a big decentralized data store.

MySQL Views Presentation at the September 2008 Boston MySQL User Group

This Monday, September 8th, the Boston MySQL User Group broke our 2-month summer hiatus with a presentation on MySQL Views.

The slides can be downloaded from -- 89 kB, .pdf format.

The 199 Mb .flv file can be downloaded at or played directly in your browser at

The presentation covers:

Load Testing Using Perl

Homer Hummel of the Computer Sciences Corporation gives a presentation on Load Testing Using Perl. A must-view!

Stream directly online at or download the 247 Mb .wmv file at

OSCon 2008 Video: Does Open Source Need to Be Organic?

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there’s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

OSCon 2008 Video: Open Voices (Legal Panel)

"Open Voices" was a legal panel consisting of Jim Zemlin of The Linux Foundation, Keith Bergelt of the Open Invention Network, Karen Sandler of the Software Freedom Law Center and Phil Robb of Hewlett Packard (FOSS Bazaar project).

OSCon 2008 Video: Perl Lightning Talks

The video starts after the presentation started. According to the schedule at, pgtap is discussed first so there's not much missing on the video (the video starts with talking about pgtap).

Stream directly online at or download the 257 Mb .wmv file at

OSCon 2008 Video: history.forward()

Sam Ramji, Senior Director of Platform Strategy at Microsoft presents a keynote entitled "history.forward()". From the official conference description:

Over the past ten years, open source has fundamentally changed the way developers learn, communicate and code together. Over the past three years, Microsoft has made significant strides towards more fully participating in open source communities. This talk will discuss community participation and new ways in which Microsoft is architecting to contribute over the next ten years of open source development.