Exactly one month from today, OpenSQLCamp Boston 2010 will begin its technical content (we will have a social event on Friday evening, Oct. 15th, starting no earlier than 6 pm). Have you registered yet? It's 100% free! Make sure to get your flight before next week or the costs will go up, as it is generally more expensive to book a flight within 21 days of your trip. Also do not forget to book your hotel, we have a good rate of $149 per night for single or double occupancy....click here for details.

read more

Hi,

If you are coming to this year’s Oracle OpenWorld 2010, the largest gathering of database enthusiasts, please do visit us at booth #3729. We will be more than happy to answer your queries, demo new features and interact with you on our product road-map.

We are also giving away 50 Discover passes for the event. Contact us at oow2010@webyog.com to claim your pass now!

Cheers,
Team Webyog

Tweet

Issue #2134 reported that there are users which do not have the privilege to fire a LOAD DATA command, which rendered HeidiSQL's "import textfile" feature useless for them. So, I recently implemented a client-side parser for CSV files. The new parser does its best to detect the right values while avoiding any slow loop code. On huge files it's slightly slower than a LOAD DATA command processed on the server but I think that's very ok, especially if there is no alternative to a client-side parser.



Another new useful thing is the option "Input file contains local formatted numbers", which basically converts the local decimal and thousand separators to those chars MySQL expects. This allows fixing wrong numbers being inserted into your database, e.g. in cases of german numbers of let's say 12.345,6789 which is parsed by the …

Issue #2134 reported that there are users which do not have the privilege to fire a LOAD DATA command, which rendered HeidiSQL's "import textfile" feature useless for them. So, I recently implemented a client-side parser for CSV files. The new parser does its best to detect the right values while avoiding any slow loop code. On huge files it's slightly slower than a LOAD DATA command processed on the server but I think that's very ok, especially if there is no alternative to a client-side parser.



Another new useful thing is the option "Input file contains local formatted numbers", which basically converts the local decimal and thousand separators to those chars MySQL expects. This allows fixing wrong numbers being inserted into your database, e.g. in cases of german numbers of let's say 12.345,6789 which is parsed by the …

There are approximately 3 weeks left to submit your MySQL DBA-related presentations to Collaborate 2011, held in Orlando, FL April 10-14. Experience has shown that the best presentations are submitted well in advance of the deadline, so now is a great time to submit while you have plenty of time to create a good abstract.

Information and the link to submit abstracts are at http://collaborate11.ioug.org/. I posted a cheat sheet on how to fill out the Call for Presentations for MySQLers a while ago, and as always feel free to ask me any questions.

read more

I am very happy to announce that I have secured a great rate at a hotel for OpenSQLCamp (a free weekend conference for open source databases such as MySQL, Postgres, SQLite, and NoSQL databases). We have a room block at the Doubletree Club Hotel Boston Bayside at 24 Mt. Vernon Street in Boston at a rate of $149 per night, for single or double occupancy*, for both Friday night, October 15 and Saturday night, October 16. Wireless internet access, which is usually $9.95 per night, is included in the room fee, so there's no hidden extra there. There is also a free shuttle from Boston's Logan Airport to the hotel**. The subway is steps away from both the hotel and the venue (MIT Stata Center on the corner of Main and Vassar Streets in Cambridge). Subway fare is $2.00 each way, so if you stay at the hotel you'd have $8 extra in transportation fee.

You can reserve your room by …

Collaborate 2011 is a database operational conference to be held in Orlando, Florida April 10th - 14th 2011. Unfortunately, the O'Reilly MySQL Conference has been scheduled for the same week; however, I am working with the conference committee to make sure that speakers that want to attend both are scheduled appropriately (I intend on going to both!). The call for presentations is now open through the end of September, so you have just over a month to submit your proposals. Experience has shown that the best presentations are submitted well in advance of the deadline -- I guess when folks are time-crunched by the deadline they do not make such great abstracts....Speakers whose presentations are accepted receive free admission to the conference and a speaker thank-you gift.

read more

Users of the latest builds now have a GUI way to display a detailed query profile for the executed SQL in a query tab. Just check the Query profile tree node in the newly introduced "helpers" tree and run some query.



This is basically what SHOW PROFILE in MySQL 5.0.37 and later releases does. HeidiSQL just adds colored bars and a conveniant checkbox to accomplish that.

You may also have noticed that the tree replaces a tabbed list box, which was not able to hold a 5th tab for the profile stuff without overcrowding the GUI. Converting this to a tree makes the helpers more user friendly and look more like a standard GUI for developers.

Looks like Oracle is continuing to invest heavily in MySQL and the storage engine eco-system.  They've announced a full MySQL Sunday at the upcoming Oracle Open World Sunday September 19, in San Francisco.  Registration is only $75 which is a bargoon.  I expect this will be bigger than any MySQL conference held to date.  And there's also the JavaOne developer conference and the rest of the Oracle Open World show.

Ok, technically things actually start at noon, but knowing the MySQL crowd, I am sure there will be parties that go well past midnight.  Helan gar!

• Oracle Open World: …

This is for users who don't like HeidiSQL to store usernames and passwords somewhere:

Activating this new checkbox will ask you for username and password on demand, each time you connect to this session. Both previously stored username and password are taken as the default credentials when prompting.