Now it's two and a half year since the last refactoring of
HeidiSQL's dialog for editing user accounts. The current dialog
was ok from a usability point of view, but it did not allow users
to assign routine privileges on newer servers. And it edited and
created users by updating the tables in the mysql db directly,
which is error prone, complex and not recommended by MySQL.
The new dialog now does all updates by GRANT, REVOKE, RENAME USER
and SET PASSWORD, as recommended by MySQL. The GUI has also
evolved:
- you can clone users now
- the entered password must be repeated
- privilege names are painted in different colors for read, write
and admin relevance
But see yourself:
To get it, just go to Help > Check for updates and
install the latest build.
There's an interview with Baron Schwartz (that's me) on WebPulp.tv. Topics include the history of Percona's software such as Percona Server (our version of the MySQL database server) and XtraBackup, what we do at Percona, what tools we use to do it, how to think logically about performance optimization, what ugly surprises happen when you set up mysqldump backups and forget about them for a couple of months, and lots of other things. If you have not watched past episodes, I encourage you to do that. They feature a lot of really smart people from companies such as New Relic and 37signals. Josh is a great host for the show. He's a web engineer himself, and he knows how to ask probing questions that bring out a lot of interesting details about various web applications.
Entry …
[Read more]We are pleased to announce the general availability of Zimbra Desktop 2.0! This is a major milestone for the Zimbra team and includes significant feature and performance upgrades. The difference between Desktop 1.0 and 2.0 is enormous thanks to the millions of downloads, thousands of forum posts, and hundreds of bugs posted by Zimbra customers and community members.
As most readers of this blog know, Zimbra Desktop is a completely unique client. It’s the only free, cross-platform tool allowing you to meld your worlds on or offline – storing and syncing your email, …
[Read more]
Looks like 2010 is the year of multiplication in HeidiSQL: Some
months ago I had implemented multiple query tabs. Then, each
query tab became capable of displaying multiple results in
subtabs. And now, we finally have multiple connections in the
database tree. Thanks to monkeilas for constructive
suggestions.
Recent Tips and News on Java EE 6 & GlassFish:
|
GlassFish
• An Eclipse / GlassFish / Java EE 6
Tutorial |
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.
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.