New features:

1. Sql console: Sql console has now it's own toolbar including search field with 'Next' and 'Highlight all' buttons.
   Keyboard shortcuts: MyJgui has made a step towards better user interface with a new keyboard shortcut infrastructure. Future releases will introduce an interface to edit shortcuts according to your preferences. For now you can use these shortcuts:
   'Ctrl F' pressed at SQL Console will focus the search field.
   'Ctrl Shift T' places current table name in the SQL Console
   'Ctrl Shift D' places current database name in the SQL Console
   'Ctrl Shift S' places generic select on current table in the SQL Console
   'Ctrl Shift Q' places generic full query on current table in the SQL Console
   Shortcut actions are also accessible through a context right-click menu at SQL Console.
2. Logs formatting changes in content and title: Font family and size was decreased, and a new popup menu is available allowing you to save and clear the log tab. Logs have been tabbed some more. You can now see/copy/paste raw sql queries as well as logs with timestamp, query time and affected rows.
3. Table data tab: Auto-focus scroll after added a new line.
4. Main window: All window panes have now a collapse/expand buttons allowing you to hide every component.

Bugfixes:

1. Create table wizard was processing only first 9 columns - corrected.
2. Fixed bug with integer column types when inserting/editing rows in Tables data tab.

Details

Written by taka

Published: 13 January 2013

Hits: 1806

New stable version released.

New features:

• Optimize table, check table and repair table sql statements are now available via table right-click popup menu.
• Enhanced sqlmarks management and optional description attribute for each mark were added.
• Wizard for creating database, accessible via application menu or database tree.
• Since null attributes slow down MyIsam table operations, the create table wizard has now a not null default for each column.
• Reset action clearing all fields in wizards was added.
• Most menu items have their own keyboard shortcuts assigned.
• The column filter was redesigned to check visible columns instead of hidden ones. Shortcut icons for show/hide all and revert operations were added.
• Batch sql query execution! You can now select multiple lines separated by a semicolon (;). Each query gets logged and result set of the last query is returned.
• Support for explain query was added for the display grid. You can run explain on selected query line through the icon placed in the top toolbar.
• Enhanced handling of table data tab. Support for multiple row actions (insert/update/delete).

Fixed bugs:

• Multiple bugs were fixed in the create table wizard. Multiple column index constrains were handled improperly, preventing a user from creating a table. Unsigned column type was handled improperly. Fixed empty string in 'default' column value after editing the cell, preventing tables from being created.
• Multiple connection bug was fixed, which occurd if skipping between more mysql servers by clicking at opened tables.
• Datetime data type was handled improperly, causing the table data tab to be empty.

Details

Written by taka

Published: 13 January 2013

Hits: 1790

New bug fix released.

Fixed bugs:

• Fixed major bug causing application crash at start-up. This bug was due to incorrect look&feel skins implementation. The crash occurred with this message:
  Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: com/sun/java/swing/plaf/gtk/GTKLookAndFeel
  at myjgui.MyJguiMain$1.run(Unknown Source)
  at java.awt.event.InvocationEvent.dispatch(Unknown Source)
  at java.awt.EventQueue.dispatchEvent(Unknown Source)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  at java.awt.EventDispatchThread.run(Unknown Source)
  Caused by: java.lang.ClassNotFoundException: com.sun.java.swing.plaf.gtk.GTKLook AndFeel at java.net.URLClassLoader$1.run(Unknown Source)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.net.URLClassLoader.findClass(Unknown Source)
  at java.lang.ClassLoader.loadClass(Unknown Source)
  at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
  at java.lang.ClassLoader.loadClass(Unknown Source)
  at java.lang.ClassLoader.loadClassInternal(Unknown Source)
  ... 9 more
• Bug in export file format: fixing missing end of line character issue.

Details

Written by taka

Published: 13 January 2013

Hits: 1978

New stable version released.

A big performance and responsivity boost has been achieved by optimising data structures and removing redundant calls.
This by far the fastest performing MyJgui release.

Other minor application enhancements:

• Changing order of connections in db tree/Manage connections.
• Close buttons in Manage connections and Edit attributes dialogs.
• By saving layout myjgui saves also the position and size of whole application window.
• After creating table via wizard, dbtree scrolls to the new table and refreshes all bound tabs.
• The create table wizard allows to remove selected rows instead of last row.

Fixed bugs:

• Myjgui makes sure that the passwords get removed from memory after user disconnect.
• Showing password input dialog again after login failure.
• Password field gets focus when password dialog appears.
• Quick search condition building bug fixed.
• Fixed wrong tab focus after quick search was applied.

Details

Written by taka

Published: 13 January 2013

Hits: 1821