Following my earlier post of MySQL Workbench 1.0.1 for Linux and logging a MySQL Bug, I’ve had the Bug verified, and the a further update of a compiler success. Details of compile from Bug #16880

Compiled with:

- glibmm-2.8.1
- gtk+-2.8.8
- libsigc++-2.0.11


I’ve got:


libsigc++-2.0.17
glib-2.6.6
glibmm-2.6.1
atk-1.9.0
pango-1.8.2
gtk+-2.6.9
gtkmm-2.6.5
lua-5.0.2


So starting with the obvious downgrading of libsigc++


$ su -
$ cd /src
$ wget http://ftp.gnome.org/pub/GNOME/sources/libsigc++/2.0/libsigc++-2.0.11.tar.gz
$ tar xvfz libsigc++-2.0.11.tar.gz
$ cd libsigc++-2.0.11
$ ./configure …

MySQL AB today announced the establishment and introduction of MySQL K.K., a wholly-owned Japanese subsidiary based in Tokyo. In 2005, there were over one million downloads of the MySQL database server by Japanese users. The new company will focus on leveraging this interest in its cost-effective enterprise database (RDBMS) by offering corporate customers and software vendors commercial licensing, production support and professional service options. A new Japanese Web site has been launched at http://www-jp.mysql.com

Ok folks, let’s call this a release candidate. As usual I appreciate all feedback. If this one seems to satisfy everyone we’ll call the schema good and populate the data for a proper release.

When providing feedback, please keep in mind that we are working on a sample schema to use in examples for tutorials and training. While we can optimize it for performance/warehousing/etc we want to balance complexity and suitability for purpose. Some things are better done as part of a tutorial using the sample db than incorporated into the sample db itself. Along the same line, it is true that this schema probably would not actually work as the backend to an actual system, but that is not the goal.

Download Here

Changes:

• Changed address.district to VARCHAR(20)
• Changed customer.first_name to VARCHAR(45)
…

I have been playing with Ruby on Rails for my next application and I must say that it does puts application development on steroids.

Ruby on Rails supports MySQL and Oracle among other databases, out of the box. In addition, its support for Web 2.0 applications is very impressive.

Here are two very powerful endorsements for Ruby on Rails (Courtesy RubyOnRails.org)
?Rails is the most well thought-out web development framework I?ve ever used. And that?s in a decade of doing web applications for a living. I?ve built my own frameworks, helped develop the Servlet API, and have created more than a few web servers from scratch. Nobody has done it like this before.?
-James Duncan Davidson, Creator of Tomcat and Ant ?Ruby on Rails is a breakthrough in lowering the barriers of entry to programming.Powerful web applications that formerly might have taken weeks …

I was just reading Ronald's post and really felt his frustration. Spamming hurts our productivity and spammers are getting more and more sophisticated in spamming our sites. Just the other day, I noticed 51 comments on one of my blog posts only to find out that most of them were spam and on top of that, one user had posted 20 of those messages (Ughhh).

I recommend following Matt Cutts' advice on using rel="nofollow" for all links in comments made by the users of your site. Using the CSS hack Matt mentions, you can view all the links entered by a user on not only your site but also on any other site.

I still recommend opening up your blog for comments but using comment moderation to filter spam before posting. Just an idea.

You do have great ideas on combating …

I talked with a prominent open source developer - Gianugo Rabellino of Apache/Cocoon fame - today, getting his feedback on the business models of Red Hat, Alfresco, MySQL, SugarCRM, JBoss, and others. He made it clear that the open source development community (if it, in fact, exists) strongly prefers pureplay open source projects, rather than "mudblood" open source companies.

No surprises there.

I then spoke to a group of architects (quite senior) from Fortune 500 companies at a recent OSDL advisory meeting. I asked them the same question: do you care if your software is open and, if so, how open is open? Almost universally, I was told that everything should be 100% open (and they …

Having used InnoDB table handler in MySQL to be on par with Firebird capabilities I'm going to add foreign keys, unique constraints and check constraints and indexes to the tables migrated in MySQL.
Here is a screenshot of Flamerobin showing constraints for table CUSTOMER.

First of all I'll add the foreign key constraints, here is MySQL's syntax:
ALTER TABLE `employee`.`customer` ADD CONSTRAINT `INTEG_127` FOREIGN KEY `INTEG_127` (`country`)
REFERENCES `country` (`country`) ON DELETE RESTRICT ON UPDATE RESTRICT;

A nice graphical representation is in this screenshot of MySQLQueryBrowser showing the same constraint.


Another nice thing, foreign keys referencing the same table are …

Arjen already mentioned this in December, but let me remind you anway: we would like to showcase some Open Source projects that use or support MySQL in the MySQL Community Pavilion at our MySQL User Conference 2006 in Santa Clara, California.

So if you are a member of a project that utilizes MySQL in a cool way, here is your chance to show off!

Repeating Arjen's words here: Primarily, we would like to hear from projects which are not backed/run by a company, because companies of course already have the opportunity to become a sponsor/exhibitor.

Also, note that the conference is in Santa Clara, California - while we can provide space, we are unable to …

Arjen already mentioned this in December, but let me remind you anway: we would like to showcase some Open Source projects that use or support MySQL in the MySQL Community Pavilion at our MySQL User Conference 2006 in Santa Clara, California.

So if you are a member of a project that utilizes MySQL in a cool way, here is your chance to show off!

Repeating Arjen's words here: Primarily, we would like to hear from projects which are not backed/run by a company, because companies of course already have the opportunity to become a sponsor/exhibitor.

Also, note that the conference is in Santa Clara, California - while we can provide space, we are …

Now the next trigger, it will be an AFTER INSERT trigger, so to fire after the previous one has inserted a row, obviously an after insert trigger can reference old and new data but can't modify them.
So, on with the code:

DELIMITER $
-- DROP TRIGGER new_salary $$

CREATE TRIGGER new_salary AFTER INSERT ON salary_history
FOR EACH ROW BEGIN
UPDATE salary_history SET new_salary = (new.old_salary + new.old_salary * new.percent_change / 100) WHERE emp_no = new.emp_no;
END $$


The other trigger "POST_NEW_ORDER" posts an event named 'new_order', events are used by Firebird (and Interbase) server to notify clients about changes in database states (more on events in this whitepaper) as this feature is not present in MySQL and it's closely related to the application layer I …