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 …

Now that the move to Google Code is nearly 2 years ago, all SourceForge related stuff for HeidiSQL was removed today. That includes three mailing lists on which you probably were subscribed:
* heidisql-devel
* heidisql-issues
* heidisql-commits
The first one was only used internally. The second and third one can be easily replaced by the update RSS feed at Google Code.

Hoping everyone is alright with this removal. This step should also help to decrease the large amount of emails we get every day.

* First bug report came in on April 19, 2006
* We have a total of 1,753 issue reports (1,110 bugs, 639 enhancements)
* 259 out of these are duplicates to other issues
* 1,038 issues were fixed (726 bugs, 312 enhancements)
* 392 invalid issues, marked as upstream, needinfo, wontfix or invalid

Both grids in "Data" and "Query" tabs now support a variable row height. Very useful if you like to see more than the first line of text in table cells at once. Just increase the option "Lines of text in grid rows" in "Tools" > "Preferences" > "Data" to a higher value.



Above the data grid, you will notice two new buttons for "Next" and "Show all". The grid loads table data in chunks of 1,000 rows. So, "Next" loads the next chunk of 1,000 rows, and "Show all" loads the entire table, up to a maximum of 100,000 rows. Both values are customizable via "Tools" > "Preferences" > "Data".

The good thing is: normally you won't need to click any of these two buttons, because:
A) "Next" is automatically executed when you have the last row focused and the press the PageDown key. So, if you hold down the PgDn key, you will see Heidi loads data on demand in a larger table.
B) Both buttons …

Shortly after I posted my last summary of MySQL releases, our son Mats was born and I went on a 2.5-week vacation. Our developers did not rest in the meanwhile and I'd like to give you a quick update of what's new since then:

MySQL Connector/Net 6.3.0

• Visual Studio 2010 RC support
• Nested transaction scope support

MySQL Workbench 5.2.16 Beta 6

• Fixed 67 bugs
• Saving your profile/connection passwords in OSX keychain, gnome-keyring or in an encrypted password-vault-file.
• New rapid development features for generating complete SQL …