Recently I've been working on a large-ish project where all of the UI is written in Javascript. That, in itself, is great. The environments (the browsers) are crappy crappy for development though. Sure, there are Firefox extensions etc etc to help, but it's Just Not Great. Javascript = Great. Ajax = Yay. Browsers = Bah.

Over the weekend I spent all sorts of time getting a simple Rails application running with Apache and mod_fcgid. When I gave up and tried making it work with lighttpd I got server error galore. Yay. What was wrong? My fastcgi? The fcgi Ruby extension? My ruby installation is in /pkg/packages/ruby-1.8.4 or some such and the gem tool couldn't find its own libraries after being installed there. Maybe something similar for something else? I have no idea, I got no error messages anywhere. Ruby = Great. Rails = Very nice[1]. Ruby Gems = It sure is no CPAN.pm. FastCGI/lighttpd/etc = Loosely coupled? No mister, you have some way to …

Well, this entry is actually just to check if my new blog gets included in Planet MySQL, but I of course will provide you with something interesting :-)

How do you like this? I find it confusing and filed a bug report about it.

mysql> CREATE FUNCTION now () RETURNS CHAR(10) RETURN("Now");
mysql> SELECT NOW(), NOW (); +---------------------+--------+ | NOW() | NOW () | +---------------------+--------+ | 2006-03-22 11:45:27 | Now | +---------------------+--------+

So we have two functions with the same name, but the space after the name makes a difference.

zak_greant posted a photo:

After many trials and tribulations (mostly on the part of the poor publisher), the MySQL Phrasebook has finally been published.

Truth in advertising: I'm easily swayed by Monica Kumar. Monica is director of Oracle's Open Source Program Office, is very smart, and actually fun to talk with.

(This last thing should not be underestimated. I remain of the mind that people prefer to do business with nice people, not jerks. On that score, I also have to admit mea culpa for casting Oracle with a broad "jerk" brush. The funny thing is, everyone I know there now, I like. So, maybe Oracle isn't a mean, bullying company after all.... :-)

Anyway, I bumped into Monica at Novell's BrainShare conference this week in Utah. She gave me a few CDs for the Oracle Database 10g Express Edition and suggested I actually try it out, instead of …

Today I was musing about how great \c is, and how it seems that many people are not aware of it, even though it’s in the banner of MySQL, and has been for a while.

So I decided to see what else I could find. I typed \h and found that a simple \W will show all warnings automatically after a query. That is great for the commandline interface! Now I just have to figure out if it’s possible to automatically do a \W (or “warnings”) whenever I log in with the commandline client.

The answer is ... my PHP & MySQL Certificates.

     

The PHP Certificate has been hanging right over my bed for a bit longer, while my MySQL Professional Certificate had its place in my document case. But a place where I hardly see it cannot be a good place, so from now on, it has an honourable place on the wall, too ;-).

Two recent articles, Commercial open source, a misnomer? and Free Code For Sale, may be the beginnings of a backlash against the "commercial open source" model. One challenges whether commerce and open source mix at all, while the other asks whether other models of open source development may be better for users.

It's inevitable that any major change would have its detractors. First open source was out to destroy capitalism. Now is commercial open source out to destroy open source? Is this capitalism's revenge, a case of the empire striking back? Let's look at some of the common arguments.

Commercial open source is not open source.

"Open source software" means software which is available under a certain license, as defined by the …

I spent a bit of time today organizing myself for a bunch of trips next month.

Contrary to my blog posting earlier, I will be at the MySQL Users Conference 2006, which is on the 24th-27th April. But I’m getting into San Francisco in the week before, so if you’re up to meeting me, don’t hesitate to drop me a line. I have a feeling that I’ll actually be staying in Santa Clara as opposed to San Francisco proper, but there should be public transport, right?

I should also be with my colleague, Arjen, who’s speaking at the Free OSS Forum Day, organized by Open Source Tasmania. He tells me that Pia should also be there, which should rock. So Hobart, here I come on …

Is PrimeBase XT (PBXT) just another transactional engine for MySQL? I think (hope) not! But, even if it was, it would still be justified considering the current lack of an independent (i.e. not owned by a monopolist) transactional engine. But I started developing PBXT at the beginning of last year for a much more basic reason, after all I had no idea what Oracle was about to do.

I started programming PBXT simply because it was there!

But wait, you say, "we climb mountains because they are there, we don't program software because it is there", because it isn't (before we start). Well I think many programmers can relate to that statement anyway. Programming is much like climbing a mountain. You start out with great enthusiasm, wanting to do things better and quicker than before. But as you get higher, the air gets thinner. You struggle on and as you approach the top it gets tougher and tougher (we …