Our web team informed me that we received a few comments from users about MySQL AB supposedly shutting down the development of the MySQLFront utility. I?d just like to clarify that this was not the case at all ? we merely asked the developers to stop violating our trade mark as outlined in our Trade Mark Policy. As I wrote some time ago, our trade marks are a very important asset to us as a company and we need to take action, if our marks are being violated.

We did not ask or force them to stop the development or to remove the program from the market completely ? this was their very own decision. In fact, we actually encouraged them from the beginning of our discussion to continue the development of the product under a …

Our web team informed me that we received a few comments from users about MySQL AB supposedly shutting down the development of the MySQLFront utility. I?d just like to clarify that this was not the case at all ? we merely asked the developers to stop violating our trade mark as outlined in our Trade Mark Policy. As I wrote some time ago, our trade marks are a very important asset to us as a company and we need to take action, if our marks are being violated.

We did not ask or force them to stop the development or to remove the program from the market completely ? this was their very own decision. In fact, we actually encouraged them from the beginning of our discussion to continue the development of the product under a …

The T-SQL to MySQL procedure converter is of course developed based on what I needed when I made it. I have made it as a window's executable because we run the system on windows (guess that is common with SQL Server installations...). There is no fancy user interface (in fact no user interface at all) because I didn't need it etc.

T-SQL constructs not handled:

• String concatenation: since + is used in T-SQL both for concatenation strings and for addition you need to know the datatype of the arguments to know if it should be converted. The tool does no attempt to do this, even if some cases (text constants, declared variables or parameters) would be quite easy.
• GOTO's and labels: The code I converted contains a lot of GOTO's. A very common construction is: SELECT /UPDATE/DELETE/INSERT
  ....
  SELECT @p_err_num = @@ERROR
  IF (@p_err_num 0) GOTO OnError
  COMMIT TRANSACTION …

Despite Strong Demand, Survey Uncovers Significant Barriers to Adoption of Open Source Databases, Solid (Press Release)

Teradata Delivers Linux for Enterprise-Class Data Warehouses, Teradata (Press Release)

CollabNet Announces Enterprise Commercial Support, Training and Services for Subversion 1.4, CollabNet (Press Release)

Linux lab: GPL clarification needed ASAP, News.com, Stephen Shankland (Article)

…

I’ve bought plane tickets to the upcoming MySQL Camp in November. This is looking like a very fun time, with lots of community members, MySQL employees, and Google developers attending. It’s an “un-conference,” which means there is no set schedule, and it’s up to us to make out of the event whatever we wish it to be. If you’ve been reading my articles or using my tools, is there anything you’d like me to present on?

This key should give you a guide how to best tune you MySQL database systematically... It should also work similar for other RDBMS.

Maybe not breaking news, but I think it’s interesting enough of a point, and I didn’t really find anything about the topic when I googled it. If you do any addition, subtraction, multiplication, or division (and probably a lot more mathematical functions for that matter) and NULL is one of your values, the entire expression will evaluate to NULL.

For example, this statement returns NULL:

select 4 + NULL;

+———-+
| 4 + NULL |
+———-+
| NULL |
+———-+

Normally you wouldn’t do the above in such a simple way, for instance, you might do some addition in a subquery. For example,

select 4 + (select val from table1 WHERE id < 3 LIMIT 1);

+---------------------------------------------------+
| 4 + (select val from table1 WHERE id < 3 LIMIT 1) |
+---------------------------------------------------+
| NULL |
…

Dana Blankenhorn of ZDNet has an interesting interview with Darryl Dewan of VA Software. In the course of the interview, Dana queries Darryl as to whether open source businesses can deliver serious financial heft. The answer?:

Maybe the good old days really are gone for good. But is open source to blame for that? No more, I think, than the end of the gold rush can be blamed on mine automation.

There are still fortunes to be made, Dewan said. Look at the money the founders of MySpace made, or those of YouTube will make, and all the gazillion Google-aires.

"You can create things online and do things online and you don't need to program," Dewan concluded. This is not a bad thing. Unless you want to become a millionaire through programming.

I disagree (with all due respect to Dana, to whom much respect is due). Marten Mickos …

Red Hat this week announced their application stack which includes JBoss, Hibernate and support for MySQL and Postgres open source databases.  Given Red Hat's recent acquisition of JBoss, the announcement was not a surprise, but it's still good to see that they are making progress moving up the stack and providing greater ease-of-use and integration. 

Red Hat remains the number one vendor of Linux and this move shows that Red Hat could be the "market maker" for open source stacks.  They are definitely raising the bar on competitors and that's good news for customers.  Red Hat will now be distributing certified binaries for MySQL as part of this stack and is also providing front line support backed up by our own support organization for complex issues.  Red Hat is offering multiple levels of subscription support for the stack, starting at …