Percona Live MySQL User's Conference, San Francisco, April 10-12th, 2012 Book: "Pentaho Kettle Solutions", Matt Casters, Roland Bouman, & Jos van Dongen, Wiley 2010 Book: "Pentaho Solutions", Roland Bouman & Jos van Dongen, Wiley 2009

Sunday, June 03, 2007

Bugfixes to the Quick And Dirty Query Tool (Google Gears Database Service Demo)

Yesterday, when I published my blog entry on the Google Gears database service, I made the terrible mistake of not testing my Google Gears Query Tool in Internet Explorer.

I fixed a number of issues, and it from what I can tell, it now works for Firefox (tested: 2.0.0.4 in Windows XP and Ubuntu Linux Feisty Fawn) and Internet Explorer (tested: 6.0 on Windows XP)

For Internet Explorer, there is however one issue I cannot solve. I suspect it is a bug in the Google Gears extension. The bug may be reproduced by opening the Query Tool page and hitting the "Execute" button, leaving the textarea for the SQL text empty. You will get a popup that looks something like this:
gg-crash
And then the browser crashes.

I already reported it, so if you have any more information regarding this bu, please add to that thread to share your observations.

I also added a new feature. You can now view the query plan for your queries by hitting the "Explain" button. This will only work for SELECT statements, and you will see an error message otherwise. Explain is implemented simply by executing the current statement text in the textarea, prepended by the string "EXPLAIN ". The resultset of this is then rendered just like any normal resultset.

4 comments:

Andrew Dashin said...

Nice tool. Are you planning to extend it?

Roland Bouman said...

Hi Andrew!

Actually, I created a new version that includes a demonstration of the Google Gears worker pool:

http://www.xcdsql.org/GIQT/

There are still a few problems with this version but it currently works pretty well on firefox.

Andrew Dashin said...

Hi, Roland.

YUI is a good descision :) But what about your plans on future? Could it became something more than simple demo? ;)

Roland Bouman said...

Hi Andrew,

"But what about your plans on future? Could it became something more than simple demo? ;)"

Well, it could I suppose. But I don't have a real plan ;)