Over-the-Top Tales from the Trenches. Motto: Bringing order to the chaos of every day DBA life. Dear Diary, Are we there yet? How much farther? Ever heard this during a recovery of a downed database? The poor thing has either a minor scratch, requires immediate attention, or is dead on arrival (DOA). You could cut the tension in the air with [...]

MySQL Connector/Net 1.0.9 has been released. MySQL Connector/Net is an all-managed ADO.Net provider for MySQL. This release is suitable for use in production environments and with any version of MySQL.

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/1.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

This release includes many bug fixes along with the following enhancements/changes:

* Implemented a stored procedure cache. By default, the connector caches the metadata for the last 25 procedures that are seen. You can change the number of procedures that are cached by using the 'procedure …

Today we have released MySQL Tools for Microsoft Visual Studio 1.1.2 -- a downloadable plug-in for Visual Studio 2005 that allows Windows developers to quickly build MySQL data-driven applications with Visual Studio. With this plug-in, developers will be able to create, modify and manage MySQL database objects with an easy-to-use interface from within the Visual Studio IDE. This product is delivered as a package compatible with Visual Studio 2005.

This release is identical to 1.1.0 in functionality. We identified and corrected some problems with the installers for 1.1.0 and the unreleased 1.1.1.

The 1.1 series plugin adds support for using the DataSource wizard and the DataSet designer in Visual Studio 2005. The Data Source wizard can be found by choosing Data|Add Data Source from the Visual Studio menu. It provides a way to connect the generic data-handling capabilities of Visual Studio to our provider. Once a data source is …

Ok, I thought this Windows Vista Upgrade Decision Flowchart was kind of funny.  (Click on the link below and then open up the PDF.) The weird thing is everyone's been talking about LongHorn Vista for so friggin' long, I didn't even realize it was launching this week.  It was five years in the making, so I'm sure it's an improvement over XP, but does it really matter any more? For a slightly more serious perspective, check out John Stewart's interview with …

I always enjoy trying to do my work creating web applications using the fewest number of database queries possible. It's kind of a pride thing, I guess. That and I suppose it makes to improve an app's performance and reduce the load on a server. If you're into that kind of thing. ;)A technique I use subtitutes the temptation of using queries whose results call queries and instead uses only two. ...

Welcome to the thirtieth edition of Log Buffer, the weekly review of database blogs. We start with an item on O’Reilly Radar by Tim O’Reilly: Data is the Intel Inside. Tim shows some evidence in favour of the the notion that, in the post-Web-2.0 world (”Web 2.0″ being a coinage of his own), where data and [...]

I have written a long, long blog entry How fast is mysqlnd-5.0.0-alpha?.I do not want to spam the Planets with all of it. It’s aimed at PHP and MySQL users that want to hear in detail what we know about the performance of the first alpha release of the MySQL native driver for PHP.

The following table demonstrates pretty well where we are with mysqlnd. For a first alpha it shows an acceptable performance.

As an example of a realistic benchmark, we have followed the decision of the german computer magazine c’t and choosen the Dell DVD Store. Last year a MySQL team had won ( …

I have written a long, long blog entry How fast is mysqlnd-5.0.0-alpha?.I do not want to spam the Planets with all of it. It’s aimed at PHP and MySQL users that want to hear in detail what we know about the performance of the first alpha release of the MySQL native driver for PHP.

The following table demonstrates pretty well where we are with mysqlnd. For a first alpha it shows an acceptable performance.

As an example of a realistic benchmark, we have followed the decision of the german computer magazine c’t and choosen the Dell DVD Store. Last year a MySQL team had won ( …

Every time I walk into the MySQL office here in Machester by the Sea
I find myself eyeing the WRT54G and thinking to myself "Hmmmm I have
the latest image of DD-WRT on my laptop, and this router is a version
3,... it is such a shame its running that lousy firmware."

Thanks to age, and the wish to not become IT staff, I never flash it.

But is is tempting.

At Antioch I taught a class in operating system design when 386BSD
had just been out for a year or so. Learning "UNIX" was hot then and
there was a demand for the class. At the time 386BSD, which
eventually became FreeBSD, was the only route to go for a PC that got
you an un-crippled version of a UNIX like OS.

It came on 54 floppies. My students would download it, and run off to
find PC's to play with. Since Antioch had almost know Intel machines
at the time, almost …

I have to deal with it now and a lot of other people too, judging by the utf8/unicode/encoding topics on the django mailing list. I have found this one thread quite interesting and looks like the problem solver, but may be I also just need to learn a bit more about the bits and pieces that make this whole thing work. This message obviously tells how to make mysql completely aware and well-handling utf8.
Next thing on the list the django setting parameter DEFAULT_CHARSET.