Craig announced jMaki on Rails. Here I provide detailed steps to read data from a MySQL database and display it in a jMaki-wrapped Yahoo DataTable widget.

1. Download NetBeans 6.0 M9 (Full version) and configured to install only "Base IDE", "Java IDE", "Web and Java EE" and "Ruby" modules. A cutting-edge build can be obtained from the hudson build.
2. Download and install jMaki …

As always, the digital world is evolving. Quickly. Yet, the way we store our data was envisioned decades(!) ago. To accommodate today's needs, wild solutions are tacked onto old systems. This practice is commonly known as hacking. While these solutions work great for a number of people, they share a fundamental flaw: They are hacks who pervert the original idea of the system's design and implementation.

CouchDb is designed to fulfil data storage requirements in modern times. It doesn't come with legacy to support and without hacks to make it work on current and future systems. If you are looking for ways to save, see, secure and share your data as in The four pillars of data management, CouchDb supports all of them:

• Save - Robust, ACID compliant storage engine.
• See - View engine to efficiently filter, format and organize …

This post is slightly off-topic, but I thought I'd share some information.  I've been suffering from carpal tunnels syndrome recently, and it's only gotten worse.  Apparently I'm not the only bloggers to suffer from this. And what's apparently made it worse is in my Internet/e-mail/blogging addiction, I've queued up a bunch of posts to take place over the next couple of weeks while I'm traveling.  (I may also have aggravated this by trying to play a lot of rock guitar.  Recently when I'm completely ill-equipped to do so.)

At any rate, I'm trying not to type so much.  And some of you may have already guessed that this posting is being written using voice recognition software from Dragon systems.  (Naturally speaking, version …

As you probably know MySQL is Running AdSense Ads on PlanetMySQL.org for last few months. When the project was just started it was Ad free. I’m curious If MySQL Really ask syndicated Blog owners if they would allow that or if they just hope if someone does not like it he would speak up ?

I recently found an blog post on the same matter which make me to think on this once again.

So what is my take on this ? We currently run no Ads on MySQLPerformanceBlog and I would not like to see someone making money from something I have chosen to be free.

Would I like to be removed from PlanetMySQL aggregation ? No because many MySQL users are subscribed to PlanetMySQL rather than tens of individual MySQL blogs they would like to read, and I do not want to cut my RSS feed for the same reason.

I learned an extremely valuable lesson today on a client site. It’s important that users of MySQL read the right version of the manual for the product they are using. It’s very easy to just goto http://dev.mysql.com/doc/ which is what I type in directly and browser the manual. While the MySQL Manual has separate sections for 4.x, 5.0, 5.1 etc, the 5.0 Manual for example reflects the most current version of MySQL 5.0. You may not be running the most current version, infact most production systems rarely run the current version.

My specific case was with Connector/J (JDBC) Reference of 5.0.4. The manual pages reflects the new 5.0.5 or todays’ 5.0.6 release and a particular default is now a different value. With …

I just want to raise a warning flag for DBAs using RMAN and flash recovery area in Oracle 10g. An RMAN script is usually something like: backup database plus archivelog

However, the behavior of plus archivelog depends on whether optimization is enabled or disabled in RMAN. The RMAN reference document says that when the plus archivelog [...]

This release of MySQL Table Sync adds the ability to sync only part of a table, adds minor new functionality, and fixes a bug that could crash the tool. I will be focusing some effort on this tool soon. If you would like to see particular features, please consider sponsoring them.

By Mike Hendrickson

In this fourth post [one, two and three are found here] on the State of the Computer Book Market, I will look at programming languages and drill in a little on each language area.

A Treemap view of the Programming Languages

Overall the Q1 '07 market for programming languages was down (9.10%) when compared with Q1 '06. There were 482,079 units sold in Q1 '06 versus 441,850 units sold in Q1 '07.

In the treemap view below, you will notice a couple of bright green areas -- namely Ruby and Transact SQL. JavaScript and Python, which are also green [not bright green] show a nice growth when compared to the Q1 '06 …

I came up with this analogy today comparing MySQL and Oracle and it seemed to fit. Only real Unix geeks will get this, but here goes:

MySQL is to Oracle as Vi is to Emacs

Maybe this has been said before, but think about it.

Here's what they all have in common:

• 
  
• All are cool technologies and worthy of respect in their own right
  
• All have zealots vigorously defend their technology to the death
  
• Each set (Oracle/Emacs and MySQL/Vi) represents a different way of looking at and solving a problem
  

For the Oracle/Emacs world things work like this:

The technology is the be-all/end-all, make it do everything we want.

In many ways this is a huge advantage, things are tightly integrated, you don't need to worry so much about system conventions and …

MySQL Table Checksum 1.1.5 adds a some useful features and fixes a couple of bugs. Now you can checksum tables in chunks, and there is an option to pause between chunks as well. This has already helped me recover a very large table that got out of sync on the slaves, and many of you have also requested this feature.