A quick tourThere are many new features in the Forge:

In Quiz #5, we looked at the following CREATE TABLE and INSERT:

CREATE TABLE test (
  id varchar(1) NOT NULL,
  PRIMARY KEY  (id)
);
INSERT INTO test VALUES ('0'), ('1'), ('2'), ('a'), ('b');

The INSERT succeeds, and the table contains 5 rows.
The multi-row INSERT … VALUES (…), (…), … syntax is completely legal in MySQL. But…

1. is it portable to other Relational Database Management Systems such as Oracle, MS-SQL, DB2, Firebird, Postgresql, …?
2. is this standard SQL syntax?

(more…)

I read this article recently about how BI users just really love and are used to their Excel sheets for almost anything they do. My first reaction was "duh". My second reaction was that even I used Excel recently to help me data cleanse some contact information.
Its easy to use, the functions are clear, I can develop my own functions in VBA, I can use colors to see problems with values, etc...
I mean I can bet you that "even" if you use MySQL and you want to play around with the data to see if you can find anything, you would use Excel.

But as the article says, there are some drawbacks in terms of time spent fixing errors and if you use Excel sheets that connect to other Excel sheet and then you go and insert a column or something.


Anyway, the …

Like I said my last post, the new MySQL Forge commenting system is pretty slick. It gives commenters a lot of freedom in how they wish to display their comments, including syntax-highlighted code sections, while at the same time being security-conscious about XSS attacks and such. The HTMLPurifier and GeSHi PHP libraries are used in tandem to give flexibility and security at the same time.

The code to enable this is fairly short. For you PHP devs out there, here is the code that does everything for cleaning and "codifying" the comments:

1. /**
2.   * Highlights the text as code in the supplied language
3.   *
4.   * @return string The marked up code
5.   * @param subject The text to markup
6.   * @param …

As anyone close to me can attest, my life over the past six months or so has revolved consistently around planning for the 2008 MySQL Conference and Expo. However, in my abundant free time not reviewing proposals, working with sponsors, and organizing the conference events, I've also been working on a new version of the MySQL Forge platform. In fact, the new code base is almost a complete rewrite from the original one. I'm pretty pleased with the new platform, and Giuseppe and I have been doing a bunch of testing to get things to where they are now. And we'd like your help in the final testing of Forge 2.0 before it hits the mean streets of the Internet.

So, what exactly is new about Forge 2.0? Well, lots of things actually. …

In summary: Who: you, me, MySQL/Sun What: MySQL User Group with free swag, food, and a short workshop to boot. When: 7-9 pm, Monday March 10th Where: MIT Building E-51, room 372 Why: why the heck not! Because Sun just bought MySQL, and because there’s a user group each month. How: RSVP optional but requested [...]

I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to various stuff related to Sun and MySQL and among other things - These Benchmarks

This may be great piece of Benchmarks for Sales and Marketing needs as they show sun stuff is so much cooler but they are so unusable if you really want to take informed decision and pick best of the component level.

As you can see Everything - Hardware, Virtualization, OS, Database Server, Web Server are all different.
This pretty much means you have no clue on what is the best on the component level. May be Sun would stack would get even better results on these Xeons ? or is it "Leading Virtualization Software" used with Windows is a crap ? …

• The University of Tokyo and Sun start Research on HPC and Web-based Languages
• Sun and Chinese …

A second (after Open eHealth) Open Source industry announcement today.

Geert pinged me to let us know he pinpointed a date for the next MySQL user group.
Next month Tuesday, March 18, 2008 around 1900ish Cafe Sport Leuven

Ack here

He promised to provide free Sun workstations to all women who were at all the previous editions if they show up again.