Just when we thought it couldn?t get any simpler for organizations than downloading a pre-packaged messaging and collaboration solution like Zimbra, Red Hat?s RHX program finds a way. The Zimbra team is excited to participate in Red Hat?s RHX program. Zimbra?s open source community members have often asked if they could download & evaluate, procure and get support for both the Red Hat infrastructure and Zimbra?s rich Ajax-based messaging and collaboration solution ? all online and from a single source. The RHX program fulfills the community?s wishes by providing a pre-integrated and Red Hat certified Zimbra solution for RHEL.

Zimbra is among the charter members of RHX along with other open source market leaders like …

Red Hat Exchange went live minutes ago. We at Zmanda are thrilled to be one of the RHX launch partners: Alfresco, CentricCRM, Compiere, EnterpriseDB, Groundwork, Jaspersoft, Jive, MySQL, Pentaho, Scalix, SugarCRM, Zenoss, Zimbra and Zmanda. Congratulations to Matt Mattox and rest of RHX team at Red Hat.

Just noticed YouTube is down. Anyone else experiencing this?

In many cases you don't want your the result from your SQL statement in just a plain listing, but organized in columns, or whith data grouped on status, period or whatever. This can often be accomplished with a combination of the IF function and SUM or another group function.

For example get your sales per customer grouped by period:
SELECT customer_no AS CUSTNO, cust_name AS CUSTNAME,
sum(if(period = '200701',amount,0) as Jan_Amount,
sum(if(period = '200702',amount,0) as Jan_Amount
FROM otd.salestrans_hist s
WHERE period IN ('200701','200702')
GROUP BY customer_no, cust_name

Or number of open and closed records in each class:
SELECT class, sum(if(status='Open',1,0)) as open,
sum(if(status='Closed',1,0)) as closed
FROM table_name
GROUP BY class

In the examples I have used the MySQL IF function. You could also use CASE, which is SQL …

I've learned how to write MySQL UDF's (User Defined Functions). The interface isn't terrible complicated, tho it's annoying and incomplete in many ways.

I'm going to use the UDF mechanism to shoehorn my AgentX SNMP subagent into 4.0, 4.1, and 5.0, since they don't have the daemon plugin interface that 5.1 has.

But now that I know how to write UDFs, what functions have you always wished you could call from SQL?

Last thursday I got ticked at some Ruby docs, so I tried my hand at C instead.

Just now:

$ wc -l toast.c
598 toast.c

$ git log --pretty=oneline | wc -l
24

$ cat build
#!/bin/bash

rm -f toast
gcc -g -Wall -Wextra -Wno-unused-parameter -O2 -o toast toast.c -levent -llua

("toast" is localhost:5500, mysqld is localhost:3306)


MySQL Client

$ mysql -u root -h 127.0.0.1 -P 5500
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.0.37 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (x86_64) using readline 5.1

Connection id:          62
Current database:       
Current user:           root@localhost
SSL:                    Not in …

I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.

Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.

The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!

Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/

Direct play this episode at:
http://tinyurl.com/2h2d7j

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
…

I'm really excited about MySQL Cluster. It has a lot of potential to be a good competitor to Oracle RAC, and not just in a copy-cat kind of way.

The thing that makes MySQL different and a good balance, when you're fortunate enough to have the choice, is the "Share nothing" concept. In RAC (and I'm no expert), you use shared storage, usually a Netapp Filer. While filers are seriously cool, they are also seriously expensive, and, no matter how much you gussy it up, it's still a single point of failure.

I was glad I sat in on the Intro to cluster talk at the Users conference, it helped me understand what cluster has to offer, and what it still needs. These needs probably …

MySQL AB today began offering its premium MySQL Enterprise subscriptions through the new Red Hat Exchange (RHX). Designed to simplify the lives of corporate database developers and DBAs, MySQL Enterprise is a comprehensive set of production-tested software, proactive monitoring tools, and support services.

I just saw the review on Slashdot about the Visibone cards:
http://books.slashdot.org/article.pl?sid=07/05/09/1331253&from=rss

At the MySQL User's Conference I gave a few of these out. They were of nice quality and were well laid out with information.

The only thing that surprised me about them, was that I had not realized that we had that much SQL syntax :)