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
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.
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 …
[Read more]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.
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!
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.
Dear MySQL Users,
We’re pleased to announce the release of MySQL Workbench 5.2.25 This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.
Special thanks go to all the great MySQL Beta Testers that provided valuable ideas, insights, and bug reports to the Workbench Team. Your beta feedback truly helped us improve the product.
MySQL Workbench 5.2 GA provides:
• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)
Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
To get started quickly, please take a look at …
[Read more]