my five mysql wishes

jay pipes started with his five mysql wishes, and others have chimed in. i guess i may as well take a whack at it.

connect by. yeah, yeah. it’s not standard. i don’t care.
expose character-set conversions in the client library. all the code to convert between all of the character sets understood by the server is there, there’s just no public interface to it.
online backup. it’s in progress, but this will make things so much better in so many ways. we could actually have reliable backups of bugs.mysql.com. and it’s going to make starting up new slaves so much easier in replication.
re-learn how to ship software. the long release cycles of 5.0 and 5.1 have been pretty ridiculous, and i’m sure we can find a better way to add features without having to slog through months of bug-fixing to get a release to production quality. it is frustrating to ask for new features and have the fear that there won’t be a production release that includes them for another couple of years.
fix planet mysql to handle utf-8. seriously, guys, it’s not that hard.

» Saturday, June 23, 2007 @ 8:50pm » code, mysql, wishlist » 4 comments, add yours

« and so the puppyblogging begins • trained puppy (sort of) »

Comments

I agree about "connect by", it's non standard in a good way, look at how complicated is the standard synthax, see the implementation in Firebird 2.1 as an example.

» pabloj » Sunday, June 24, 2007 @ 2:36am

If they're running the actual Planet code, they've probably not upgraded for a very long time. Tell them to upgrade to Planet 2.0 or Sam Ruby's Venus branch. It's very simple.

» Jeff Waugh (link) » Sunday, June 24, 2007 @ 11:00am

it’s not the actual planet code, it’s a homebrew solution.

» jim (link) » Sunday, June 24, 2007 @ 11:07am

I think online backup in the server is actually not that useful. MySQL's current backups as well as everything I've heard about the online backup plans are all superceded by LVM snapshots. LVM for the win.

» Jeremy Cole (link) » Monday, June 25, 2007 @ 4:15pm