SQLEditor Release Notes

Table of Contents

Version History

Version History

  • 1.0
    • Changed keyboard shortcut for next/previous object to (command+Arrow Up), (Command+Arrow Down)
    • Improved Help
    • Minor changes to graphics
  • 1.0FC2
    • Altered the keyboard handling. Now next object (command+[) and previous object (command+]) functions added and inspect object command removed as redundant
  • 1.0FC1
    • Better keyboard support, you can use tab and shift-tab to move back and forward between fields and objects. Cursor keys to move objects (hold down shift for faster movement) and the t key to select types on fields from a menu
    • A number of internal improvements to improve speed and performance
    • Undo support has been improved in a number of ways and should be faster
    • Drag handles now appear on all sides of selected objects and disappear from deselected objects
    • Comments can now have selectable colors and can be set as a backdrop to other objects. HINT: use these objects to section the canvas into logical groups
    • Objects can be locked in position
    • Fit to window added
    • Fixed a bug where objects could appear outside the visible area
    • Changed the way that some lines are drawn to improve appearance
    • fixed a bug where the inspector wasn't updated correctly when objects where created
    • Altered Database import to better handle errors during import
    • Rewrote connector selection so it works better
    • Add a bring current to front option (command+1) to switch the focus back to the document window if the inspector is the focused window
    • Some minor bug fixes to other areas
  • 1.0b12
    • Inline editing - double click to edit the names of objects. (click on areas that aren't text to get previous behaviour
    • Context (popup) menus on most objects
    • Better support for different database connection strings
    • Better support for unicode characters in saved files
    • Altered dragging of fields. Fields now have a drag handle instead of having to hold down control to drag. Drag handles will not show on print outs or saved images.
    • Slightly altered drag and drop for fields
    • Fixed some parser bugs including IDENTITY support
    • Bug fix in types preference panel
    • Slightly altered drawing of cardinality symbols to improve appearance
    • Fixes for positioning of self-referential foreign keys in vertical display mode
    • Removed the circle from foreign keys (just click on the line instead)
    • SQL files now double clickable. You should now be able to double click exported SQL files and they will be automatically imported and loaded
    • You can now import structures from files with extensions:txt,text,SQL. Also files without extensions can also be imported
    • Minor improvements to exported SQL
  • 1.0b11a
    • This is a bug fix release that fixes a problem that can cause crashes when printing if no print header is set for a document
    • There are no other changes
  • 1.0b11
    • Drag and drop for fields now works correctly
    • Improved mysql export. Now automatically creates required indexes for foreign keys (mainly useful for earlier versions of mysql that don't automatically create these).
    • Improved automatic object naming algorithm, now uses underscore instead of hyphen so that the resulting objects will actually work in real databases.
    • Threaded import. When importing an existing structure from a file or a database the main part of the import is now threaded. This means that you can continue to edit other documents while an import is going on and the application will remain responsive. This may also speed up imports on multi-processor machines.
    • Auto size table option added. When set, tables will automatically be resized to account for changes (View->Auto Size Tables)
    • Types list now automatically adds and saves types that are used if they haven't been added before. This means that you shouldn't normally need to use the preferences screen at all to add types. Just start using them instead
    • New vertical connector style. This will connect tables at the top and bottom as well as the sides, but is otherwise identical to the diagonal style
    • Print style (fit to page, tile or crop) is now saved
    • Undo after arrange objects now works (although redoing it doesn't yet)
    • Better constraint when dragging groups of objects. They no longer go off the top left of the canvas
    • Connector improvements, easier selection (just click) and easier deleting (select and hit delete). Still can't move the connectors, that's coming in the next release (hopefully)
    • Improved sybase export a bit (Please continue to send in bug reports)
    • Document Information panel, sets printing headers and footers for a document.
    • Page numbers on print outs
    • Made field borders optional after a request. (Drawn by default)
    • Minor performance improvements in importing, object movement and object arrangment
    • Minor bug fixes in various things including the parser and inspectors
  • 1.0b10
    • Improved JDBC database import. Importing databases via the JDBC system is now more efficient. SQLEditor now imports the database structure by directly reading it from the JDBC driver as opposed to creating sql and then importing the sql. This is both faster and more reliable. It should also eliminate all of the "SQL error on line 71" style error reports

    • Export dialect support. It is somewhat simplistic at the moment, but the capability for SQL dialects is now supported. Dialects initally supplied are:

      • Generic - Standard ANSI SQL (or close to it)
      • MySQL - MySQL dialect
      • Postgres - Postgres dialect
      • Sybase - Sybase Dialect - experimental

      The mysql dialect is probably closest to the format that was previously exported. Documents should remember the export dialect that you select.

      Note that generic will be used when copying and pasting. An option may be added later to select this. Be cautious about expecting to be able to perfectly re-import files exported, certain dialects (now and in the future) may not work perfectly.

    • Connector selection. A new widget (circle) is now shown on foreign key connectors. If you click on the widget you can edit the connector or delete it.
    • Table names are now bold
    • Double click header to resize tables added
    • Pasting has been changed so that the objects pasted now appear in a slightly more useful location
    • Option dragging the canvas now scrolls the canvas
    • Bug fixes in the parser, editing system and some other areas
  • 1.0b9
    • Significant printing improvements, new features include tiling that actually works, printing to the whole page (maximum imageable area), lines on the canvas to show where the page boundaries are
    • Page setup information is now saved with each document
    • Saved file format slightly tweaked (strings are now PCDATA). This adds robustness and prevents problems if you use bits of XML in comments or object values. This does not affect importing data into older versions and files will be automatically updated to take advantage of this as they are loaded into the program.
    • Fixed a bug which prevented a document from being loaded if it had an empty title
    • Added a work around for a problem that occurred with primary keys when importing via JDBC using mysql drivers
    • Improved the scaling system a bit more. Documents now remember scale settings
    • Minor UI fixes for odd problems
    • Changed the canvas so it now increases in size as necessary to accomodate all the objects. This also happens when you drag objects over the edges of the current canvas
    • Changed comments so that they can now be used without the scrolling text area, just reduce the vertical size until only the title bar is visible, then use the title bar for the comment. Comments will be improved in a later release
    • Fixed a very specific problem that occurred when importing data from scripts exported from MySQL that used SET FOREIGN_KEY_LINKS
    • File saving is now handled more intelligently
  • 1.0b8
    • Import from database - use any JDBC driver and drop it into /Library/Java/Extensions
    • Improved inspector speed, the bug supposedly fixed in b7 now actually is fixed
    • Improved selection, dragging and editing including improved multiple selection
    • Fixed the foreign key bug that meant that some exports wouldn't work with real databases. Foreign keys are now added to the tables after they have all been created. This might get to be a preference in a future version.
    • Type saving might have been failing in b7 under some situations, this should now be fixed
    • SQLEditor is now more agressive in prevents duplicate tables and fields. You probably will not be able to create duplicates. SQLEditor will automatically rename them
    • Fixed some other bugs as they occurred
    • Free zooming is now available, see the view menu
    • Arrange object option to move the objects visible into a kind of square.
    • Diagonal connector as the default, the old orthogonal connectors are now an option - in response to a suggestion
    • Improved undo support (which was actually in beta 7, but didn't get a mention)
  • 1.0b7
    • Connectors can now show cardinality
    • A bug that prevents fields from being dragged from the palette has been fixed
    • Rewrote parts of the inspector to speed things up a bit when selecting fields
    • A bug that caused connectors to be badly drawn in some cases has been fixed
    • Added serial number and personalization support
    • Minor Bug Fixes
  • 1.0b6
    • Fields can now be dragged from one table to another.
    • The list of data types can now be edited and changed
    • Improved preferences options
    • Better printing, including scaling, tiling and fit to page.
    • New buttons to add a sibling field to a table or delete the currently inspected one
    • C-shaped connectors are back. (This is where a connector loops back on itself if it would otherwise overlap either the source or destination field)
    • You can now change the colors of objects. This is a global setting at the moment. Individual color changing is coming soon
    • A few minor bug fixes
    • Slightly altered the appearance of the table object view
    • First version of online help. As yet incomplete.
  • 1.0b5 - Second Public Beta of Cocoa Version
    • Much better parsing. The parser now shows errors and reports status
    • Some work on coloring of fields to indicate relationships (experimental)
    • Automated internet version checking (you can turn it off via a preference)
    • Speed improvements
    • Bug Fixes
  • 1.0b4 - First Public Beta of Cocoa Version
    • First public cocoa beta version
    • Cocoa user interface
    • Improvements to core functionality for better stability