We just noticed that the libmysql.dll shipped with the 4.0 and 5.0 beta releases does not work as expected with the above mentioned SSL keys. So, if you run into some access violation in such cases, you will need a fresh one, can by copied from a MySQL/Win32 server installation, located in the "bin" directory.

However, I will release a second Beta as soon as possible so you can forget my above notice soon.

If you update to the latest build now, you will find a bunch of new SSL fields, used to select certificates and keys needed to connect to a SSL featured MySQL server. Thanks to SuperNiFF for posting most relevant code.



Second thing is, you can specifiy a startup script now. This is a simple way to execute one or more customized queries automatically when you connect to a server. Just select a SQL file here and HeidiSQL runs that as soon you have a connection established.

As usual, Michael Skok of North Bridge ventures will be presenting the results of the annual Future of Open Source survey at this year's OSBC conference, March 17-18 in San Francisco.  This is a great opportunity to weigh in and provide your perspective on some important business questions. Here are the 2009 Results as reported by Ostatic.

• Survey: …

This morning I checked planet.mysql.com and to my surprise I found that a topic from our (Webyog) Forums (http://www.webyog.com/forums/index.php?showtopic=5066) was syndicated to planet.mysql.com.  I am not able to understand how that could happen. To my best knowledge I never asked for it. However I do not mind personally if somebody else found a way to syndicate this particular post. It may be useful for somebody. But who owns the right to syndicate that Forums topic really? The user that originally posted in our Forums? Me? Or Santa Claus maybe? I would not do myself without the accept from the poster of the topic.

In our Blog (http://www.webyog.com/blog) we have an option to set a ‘mysql’ category for a post.  What posts appear marked with that category get syndicated. Until now …

Two minor news today about nice new stuff in HeidiSQL:

1. Rewritten search + replace dialog. Previously HeidiSQL used a default dialog provided by the Windows API, supporting only a small feature set, and including some nasty focussing bugs. Anyway, the new dialog can be used to find or replace stuff in your query editors and supports Perl compatible regular expressions, as implemented in SynEdit:



Shortcuts: Ctrl+F to find, Ctrl+R to replace, F3 to find/replace repeatedly

2. Customize log messages: In the preferences dialog you will find some new checkboxes, allowing you to decide which type of messages you want to see in your log panel. In fact I added a new tab just for "Logging" as the first page "Miscellaneous" got a bit crowded.

If the MySQL site (including documentation) isn't working for you, try a mirror site.

"But," you ask, "how do I know what the mirror sites are if I can't access the site?"

Great question! Technocation has a mirror site (updated daily) at http://technocation.org/mirror/mysql/.

Also, we have purchased www.mysqlmirrors.com which points to the official list of mirrors at http://technocation.org/mirror/mysql/downloads/mirrors.html.

read more

I met Scott McNealy several times over the last year in customer meetings and to talk about Sun's open source strategy.  He's a class act all the way.  He sent out his final email to Sun employees and partners earlier today. 

Here's an excerpt:    

    While it was never the primary vision to be acquired by Oracle, it was always an interesting option. And this huge event is upon us now. Let’s all embrace it with all of the enthusiasm and class and talent that we have to offer.

    This combination has the potential to put Sun, its people, and its technology at the center of yet another industry and game changing inflection point. The opportunity is well documented and articulated by Larry and the …

Readers following the performance schema saga will be happy to know that the man who designed and wrote the code, Marc Alff, has a blog. His first posting about it is at http://marcalff.blogspot.com/2010/01/performance-schema-overview.html.

Times are a-changing, and the past couple of months have witnessed a flurry of activity on the cloud computing front; namely, SQL Azure and Amazon RDS. Touted as the harbingers of a new era — the era of Relational DBMS-as-a-Service (DBaaS) — these latest offerings pointedly reassert the fact that databases are now part of the utility model of cloud computing.

For those planning on an early adoption, even with just two significant products (no one seems to have noticed Joyent’s Accelerator for MySQL), it could get really difficult to choose. Here’s a list of 5 things that will help you make the right choice.

1. Targeted Customers: Microsoft’s target for SQL Azure (based on extensive research, I’m sure) is business applications running in the enterprise using databases of 5GB or less. Amazon RDS, …

We've all been there: Getting some totally unreadable portion of SQL queries from someone else's code, and you are hard working to find the logic in order to understand it. Now, HeidiSQL can reformat such SQL, so it gets readable again. Just press the relevant button on the main toolbar:


Example code, before reformatting:

select * # select
from bla join bla on b=1 left
join blub on /* big comment select */ b.ud = udfu
where biuaosdi=1 and concat( a , 'das' ) like date_sub(now(), interval 1 day)
order ' concat () ' # select
by rand() group by askdhja limit 10, 199

... and after reformatting:

SELECT * # select
FROM bla
JOIN bla ON b=1
LEFT JOIN blub ON /* big comment select */ b.ud = udfu
WHERE biuaosdi=1 AND CONCAT(a, 'das') LIKE DATE_SUB(NOW(), INTERVAL 1 DAY)
ORDER ' concat () ' # …