John David Duncan is talking about UDFs in MySQL 5 (or SQL as a Glue Language) at the MySQL Users Conference. I just realized that this is JD.

Why do we like MySQL? Because it's open source fast, reliable, and easy to use. This has been true since the early days of MySQL.

For many years MySQL did not have stored procedures which can make client/server apps more efficient. MySQL made up for this with lots of internal functions and UDFs.

In SQL standard (SQL92) there are 7 defined string functions. Oracle 8i had 11 string functions. MySQL 4 had 40+ string functions.

JD looks at PHP, Perl and MySQL and how they all are a part of a stack.

User-Defined Functions are fairly simple C programs loaded into the server at runtime. In MySQL you do CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so".

In MySQL 5 there are triggers, …

This is cool, although I haven't used it so it will have to be a theoretical coolness.

A few months back Anders Karlsson posted a UDF and accompanying application for debugging stored procedures on sourceforge. The idea is that you can insert statements into your stored procedure for debugging purposes. The statements use a UDF that sends UDP messages to a debug server (provided with the UDF) to allow you to discover information about what is happening as your stored procedure is executed.

I can relax now, My talk is done and I’ve been talkinq to people about more specific things. Several have congratulated me on it.

Looking forward to the BOF, although sleep would be nice.oh how I’m going to sleep on the plane

Why is this needed?
“world” database current sample is 3 tables, cities, countries and langs.
Not the Intellectual Property of MySQL, so it can’t be bundled with the software
No table type diversity, not a lot of data type diversity
No MySQL 5 features
Not a lot of data
Not really used in tutorials and articles because it’s not robust enough

Scenario
Basically, needed a sample database that was new, that allowed for many queries.
Used an idea from a Dell Sample DB
It’s 2 stores, in 2 different countries.

Designing the Database
Designed with MySQL Query Browser
Normalized
Community provided feedback and content
Trick was balance between simplicity and completeness
Learning db, so people need to understand it
After schema was approved, data was loaded
Stored …

MySQL Users Conference 2006, SANTA CLARA, Calif. - MySQL AB today announced plans for a certification program for the many powerful database storage engines being developed for its flagship MySQL database server by third-party partners and the open source developer community. Several industry-leading companies -- including Innobase OY (a subsidiary of Oracle Corporation) and Solid Information Technology -- are supporting the new program by joining MySQL AB in producing open source engines for the millions of MySQL database users worldwide.

Today, a few days later than originally planned and after 91 days in beta testing, the new version of XAMPP for Linux and Windows is ready for downloading. The major updates in this version are PHP 5.1.2 and 4.4.2, MySQL 5.0.20, eAccelerator 0.9.4 and phpMyAdmin 2.8.0.3.

Find more details on the specific XAMPP project page.

I am at the scale out panel where DBA gurus from Technorati, MySQL (Brian Aker), Google and Yahoo! are answering questions about scaling.

Some Windows based sites are storing up to 30-40 TB of data using MyISAM tables. That site is masochist.com (joke)

A question was asked whether the date in database should be stored as formatted or stored as time only and then formatted by application. The answer given was (the room was jam packed so I couldn't see the faces) that optimization like this should be done at the end. At first, you should try to add indexes where ever needed. Once all the indexes have been added, only then we should move with other smaller optimizations.

Power consumption having effect on business as you scale out?
There is power, power per watt etc. Power is huge concern for us (Technorati).

Some CPUs use a lot less power than others. At Yahoo! and Google, power is a …

In having a discussion with Paul McCullagh (the creator of PBXT transactional storage engine) and Taneli Otala MySQL AB CTO after the keynote presentation at the MySQL User Conference, Taneli made the following comment (paraphrased and reproduced with permission).

“I talk about PBXT in discussions shamelessly. The development of PBXT was excellent timing in the MySQL community landscape”.

It was an excellent commendation that MySQL AB management considered so highly the contributions from the community. As mentioned in the opening keynote, MySQL with the Storage Engine API with MySQL 5.1 has great potential to expand what options are available to user of MySQL.

Good work Paul. I like many others wish you the best in your continued development and contribution. …