Connector/Net's MySqlDataAdapter class has a method named FillSchema.  This method is intended to populate the metadata for a given query without actually returning any of the data from the query.  The only syntax that MySQL has to help with this is SQL_SELECT_LIMIT which limits the number of rows that are returned for a given select.  Indeed this is what we are using to prevent the transfer of data across the wire when we only want the metadata.

However, there is a problem.  SQL_SELECT_LIMIT does not work in stored procedures and also does not affect inserts, updates, or deletes.  So, the upshot of this is that calling FillSchema on a stored procedure will, in fact, execute the stored procedure and return all of the data to the client.  This is a waste of bandwidth but it's worse than that.  It will also execute all other DML statements in the procedure.

This is different than what happens with …

Yesterday I blogged about the release of our latest Connector/Net product.  Version 5.1, this release includes the addition of a new namespace MySql.Web.  This namespace includes implementations of a Membership and Role provider.  These providers work together with the membership and role systems in ASP.Net 2.0 to provide a simple mechanism for web developers to add authentication and role support to their web properties.

As we were unable to include proper documentation for these new providers before release, I thought it proper to write down a few thoughts on how these work and how to use them.

1. Provide a connection string

The Connector/Net installer will register the providers in the proper sections of the machine.config file.  When registered, they reference a connection string that is non-existent.  To use the providers, you must provide a connection string that points …

It's starting to feel like conference season is in full tilt.  Last week we had the MySQL Conference with over 1,500 people and later this week is the SugarCRM developer conference.  Next week is the Red Hat Summit in San Diego.  I've been to this conference in the past, and it's a great technical event.  Lots of in-depth technical sessions with the gurus from Red Hat, their partners and the community.  The keynotes are also high quality (not commercial pitches) and the parties are great.  The conference is a good deal and includes 3 nights hotels and conference meals.  I hope to be at the conference for some announcements we're making. …

I'm sure I have a lot of cleanup to do... but....


mysql> show create table t1;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL
) ENGINE=FEDERATED_ODBC DEFAULT CHARSET=latin1 CONNECTION='obdc://Driver=myodbc3;Server=localhost;Database=federated_odbc;Port=5555;socket=/tmp/mysql-5555.sock;Option=3;UID=root:t1' |
…

Alrighty, I'm flying down in the morning and will spend Thursday at the OpenCeBIT conference and exhibition.

While in Sydney, I'll be scouting for potential MySQL support engineers in the APAC region, and signing up more sponsors for the OSDC conference. Just catch me on the ground at OpenCeBIT if you want to chat with me about either (or anything else), I'll be wearing a blue MySQL shirt.

Thursday evening (6.30pm) we're having the OSIA AGM so if you're an OSIA member this is a reminder to be there!

Baron Schwartz was nice enough to make recordings of about a dozen talks at the recent MySQL conference. The original uploaded files were in ogg format and wouldn't work on an ipod and weren't very portable.

With his help, I uploaded the original MP3 files and made a podcast which contains all the links to the sessions and should work fine with iTunes and an ipod.

Here's the link to the podcast. Just add it to iTunes or your favorite podcasting software and off you go.

Everyone likes to scale - Peter Van Dijck has got some top 10 presentations listed - Twitter, Flickr, LiveJournal, Six Apart (Vox), Last.fm, SlideShare, etc. Guess what these sites are all generally backed by? You guessed right - go MySQL. I however didn’t know that Bloglines was backed by Sleepycat.

If you’re interested in viewing some rather swanky MySQL-related presentations, check out the mysql tag on SlideShare, as well.

I especially like Brad Fitzpatrick’s …

MySQL AB today announced that the EUROPAGES international business directory has chosen MySQL Enterprise to power its critical online applications.

Dtrace is one of the coolest things in Solaris 10, adding great observability to applications. A Dtrace provider for PHP that adds probes to function entry and exit points has long been available. I finally got around to integrating this with the php in Cool Stack. 

Bryan Cantrill has some excellent examples of how to use dtrace to trace through your php code, down to the system libraries and kernel (if you want to go that far !) .

Instructions for installing the php dtrace extension

1. Download the shared library for the extension :

    dtrace.so.x86.bz2

…

Baron Schwartz was nice enough to make recordings of about a dozen talks at the recent MySQL conference. The original uploaded files were in ogg format and wouldn’t work on an ipod and weren’t very portable.

With his help, I uploaded the original MP3 files and made a podcast which contains all the links to the sessions and should work fine with iTunes and an ipod.

Here’s the link to the podcast. Just add it to iTunes or your favorite podcasting software and off you go.