BadVista.org: FSF launches campaign against Microsoft Windows Vista, Free Software Foundation (Press Release)

Open Source Technology At The Application Layer A Key Focus At LinuxWorld OpenSolutions Summit, IDG World Expo (Press Release)

SpikeSource Appoints Three New Vice Presidents, SpikeSource (Press Release)

Free Competitor to Microsoft Office Releases New Version, OpenOffice.org (Press Release)

MontaVista and Atheros Deliver High Performance SDIO Stack to Open Source Community, MontaVista Software (Press Release)

…

Version 1.1.3 of Zmanda Recovery Manager (ZRM) for MySQL, an enterprise solution for backup and recovery of MySQL databases is available for download at Zmanda downloads page.

Changes since 1.1.2 release:
* Supports Ubuntu Edgy (6.10) release
* Works with MySQL enterprise 5.0
* User configuration for custom plugins
* Bug fixes

Documentation is available in ZRM for MySQL wiki. Please use forums to provide feedback on the release.

Thanks to all users for providing valuable feedback as well as finding bugs in earlier
releases

I sometimes see advice to do SQL date operations with the + and – operators on platforms where they are overloaded for date types. I try to avoid that, because it can give unexpected results. I prefer to explicitly use the built-in date/time functions. I’ll show you an example where the operators cause problems, but the functions do the right thing. My example is in MySQL, but it applies to some other systems too.

What is this - how you say - database transaction?

Remember back in college when we were taught that all "real" databases had transactions and foreign keys.

Remember when all those Postgress fanboys would make fun of anyone using MySQL because it was inferior since it lacked foreign keys?

Turns out they were all wrong.

Running without databases transactions can even be really fun. It's a bit like driving 120 Mph down the highway on a motorcycle without a helmet. Just don't crash and you'll be fine! This is how I stopped worrying and learned to love the auto commit.

With the recent Scaling eBay PDF I think we can put the final …

Useless Utilities #1

[Update 12/30/2006: Added Macworld Info and a Donation Button.]

[Update 12/20/2006: Added a small FaQ based on feedback.]

I created Keyboard Cleaner. It comes in handy when you want to clean your keyboard, but you are afraid you might trigger a command or change or delete some of your current work beyond repair and undo. Of course you could save and close everything. Sometimes however, it is just not what you want.

Enter Keyboard Cleaner. It shields your desktop and intercepts every keystroke you might accidentally make — except for Command-Q.

Needless to say that this was an educational project for me. While trying to create something like …

The MySQL Symposium will be organised from 5-7 March next year in Amsterdam

Next to me relating on my experiences with Cluster , there will be a lot of interresting speakers such as David Axmark , Ann Harrison , Mike Kruckenberg , Peter Zaitsev , Lenz Grimmer , and others

This is the European MySQL event not to miss next year !

mysql podcast

This week’s feature talks about ACID compliance, what it is, and how MySQL achieves it.

If folks have ideas or suggestions for content, please let me know by e-mailing podcast@sheeri.com or by leaving a comment.

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Direct play this edition at:
http://tinyurl.com/yy7pgz

News
Download MySQL Turbo Manager Free Edition at: http://www.mentattech.com/themes/mentat/download.html

Wireless …

I’m involved in the authoring of two books at the moment - both using different tools, neither of which would be my choice if it was up to me. One is using DocBook, writing raw incredibly verbose XML… which honestly, isn’t that much fun. The other is in Microsoft Word (well, OpenOffice.org Writer for me). The last time I really used Microsoft Word really seriously was probably around 1998/1999 with Office 98 on the Mac. It was a pretty awesome suite of software actually. Especially after the update that fixed a few crashing bugs :)

One thing I do notice though is the collaboration tools in OOo Writer are nowhere near good enough. The notes are small yellow rectangles where you either have to hold the mouse cursor over them to read them (ick, slow) or double click them and scroll right forever to read the whole or in conjunction with the last way, use the object browser.

Also, track changes doesn’t really …

“How can you manage your cross-cultural teams at MySQL, with people from over 25 different countries, with a variety of nationalities, native languages, religions, political beliefs, and value systems? And how can you get anything done when four out of five MySQLers work out of their home office, not meeting regularly face to face?”

I would lie to you if I said that the above issues are easy. They aren’t. And that is why people frequently ask me those questions. Yet, the main challenge is not cultural diversity or virtual offices. The main challenge is timezones.

My direct reports work in my own timezone (Central Europe), but also on the US East Coast, on the US West Coast, and in Australia. This covers most of the timezones I actively work with, with the exception that I also have frequent calls with my colleagues in Finland (on Eastern European time), and sometimes with the …

One exercise in our MySQL 5.0 for Developers asks for the list of country names where people speak French but not English. Of course, the world sample database is required for this.

The typical solution which we also provide in ouur training material goes like this. SELECT Country.Name FROM Country JOIN CountryLanguage ON Country.Code=CountryLanguage.CountryCode WHERE CountryLanguage.Language='French' AND CountryLanguage.CountryCode NOT IN (SELECT CountryCode FROM CountryLanguage WHERE Language='English');

You can also use subselects only. SELECT Name FROM Country WHERE Code IN (SELECT CountryCode FROM CountryLanguage WHERE Language = 'French' AND CountryCode NOT IN (SELECT CountryCode FROM CountryLanguage WHERE Language = 'English'));

This weeks class came up with a simple solution not using any subselect at all.