Recently I rewrote the whole internal grid editing stuff to have bidirectional record sets. Means, editing grid data is no longer restricted to the Data tab. Any Query tab now allows you to edit your row data - at least if it's a simple query without joins and if it contains sufficient key columns. This was one of the most wanted features by users, described in issue #723.

As a side effect, query results are client-sortable now. When you click a column header, the grid itself is just sorted. This is surely not a replacement for having an ORDER BY clause in your query, but helps a lot to work quicker with simple grid results. Note that the Data tab works different here - the SELECT query is reposted with an adjusted ORDER BY clause. Only for the query tabs this is not possible as the query is totally user edited, no internal …

Tweet

I read in his blog Jonathan Schwartz is leaving Sun/Oracle.  Jonathan was the CEO, Sun Microsystems, Inc.

Jonathan has been the force at Sun driving open source.  His voice will not be heard at Oracle so I’m wondering if this will make a change in the way projects like MySQL, Open Solaris and Open Office will be managed.

It’s a busy time of year for Pythian. With many of our team tied up on client engagements, away at MySQL conference this week, and Collaborate 2010 next week, I’m pinch hitting as volunteer editor in helping to pull together this week’s edition of Log Buffer. Enjoy!

MySQL Conference 2010

Big news this week from MySQL Conference as Oracle’s Edward Screven elaborates on Oracle’s plans for MySQL in his opening keynote. Pythian’s Paul Vallee was interviewed by Network World’s John Brodkin, before the conference in anticipation of the session.

Ronald Bradford responds, writing about his …

Finally, HeidiSQL has an editor for scheduled events, available since MySQL 5.1 . First ideas were implemented and committed yesterday. Thanks to all user comments and votes on issue #1527. This is a great feature for all users which normally think of creating a cron job to clean up some tables. See it in action by updating to the latest build (see "Help" > "Check for updates"). This is how it looks like:

For situations where you need an overview on a larger set of databases, now you have a detailed view in the new "Databases" tab, left besides the "Variables", "Status" etc. The new tab displays database names, number of items in them, their collation, and the summed size of all items in them. Together with a colored bar and sorting options this should somehow be helpful in HeidiSQL's mission to make a developer's life easier:

r3229 implements SSH tunneling via plink.exe on the session manager:



Thanks to all which voted for this issue.

Very helpful when you need some quick export of a small set of tables and/or data in tables: export SQL dump directly to clipboard, so you can paste it either in a query tab or elsewhere. Implemented in r3206.



Thanks to akrueger for this suggestion!

There hasn’t been a blog post for some time now but that does not mean that the MySQL Workbench Team has been lazy – the contrary.

All I can say at this point is that everybody should check out the upcoming Beta release of MySQL Workbench 5.2 and be prepared for something big.

Hint: Please take a look at the screenshots below. Post your speculations as comments to this blog post.

Screen 1:

Screen 2:

As soon as you update to the latest build (Help > Check for updates), you will get a new menu item "More values" in the "Quick filter" menu. This new submenu displays the 30 first distinct values of the selected column, plus their frequency in the selected table:



Thanks to Daniel for suggesting this feature!

Piper Jaffray has published a 300+ page study on the cloud computing industry based on a recent survey undertaken of 100 CIOs. Bottom line, cloud computing is expected to grow significantly over the next five years. 

    Survey respondents expect the mix of cloud computing to escalate strongly to 13.5% in five years. This equates to a five-year CAGR of 19.2%, or 23.9% when we also incorporate IDC’s forecast that total software budgets will grow 4.7% annually. In other words, software spending will grow gradually in the next five years, but the mix of spend allocated to cloud-based applications will likely surge rapidly. Another way to think about the data is that the Cloud Computing market is expected to grow five times as fast as the broader software market: 23.9% vs. 4.7%.

If anything, I think the prediction is conservative and the impact could be much larger in magnitude when mainstream …