1 Version History

• 1.3
  • Functional identical to 1.3b10
  • Release Version - will not expire
• 1.3b10
  • Fix for index importing sometimes duplicating fields
  • Fix for a bug which caused some parts of database presets not to be saved under some circumstances
  • Fix for indexes sometimes wrapping to a new line when printing
  • Altered display code on indexes when the table width is too short
  • Fixes for a few internal bugs that shouldn’t normally appear during use
  • Fix for a bug that caused connections between fields to be lost when using a file created in a version before 1.3b9 AND where the tables were schemas
  • Added a new and more reliable way of SQLEditor storing links between fields (using unique id numbers). Fully backwards compatible, files now contain both old and new style links with new style links used if available.
• 1.3b9
  • Fix for progress bars sometimes not disappearing
  • Fix for some display preferences (including snap to grid) not being saved
  • Added default settings for display preferences
  • Fix for bug with indexes where index type combo was not always set correctly
  • Added new keyboard short cuts for many file related actions (including import and export)
  • Fix for a MySQL export bug that would add additional indices when export foreign key relations
  • Fix for a bug that affected adding a JDBC driver from the JDBC Import or JDBC Export window
  • Better support for importing full text indices in mysql
  • Handles tables with schemas better (including Find panel)
  • Now detects if a database can support add / drop tables and displays an error if necessary
  • Fix for user interface when importing (didn’t show progress bar correctly)
  • Fixes for some internal bugs (mainly edge cases that weren’t handled correctly)
  • Saving very large files would sometimes cause out of memory errors. Fixed
• 1.3b7
  • Added logging for SQL Export
  • Index names are now prefixed with table name when exported to be more unique
  • Object comments are now exported in SQL as comments
  • Bug in ordering of default and not null in Oracle and Postgres fixed
  • Window zoom menu now appears on mouse down not mouse up
  • Bug which deleted foreign keys when duplicating table fixed
  • Minor bug fixes
• 1.3b6
  • Fix for a bug that removed foreign keys when duplicating a table
  • Application bundle information was wrong in finder windows - fixed
• 1.3b5
  • Copy and Paste for single fields in the main canvas should now work
  • Drawing a connector will now scroll the view if necessary so objects can be linked more easily
  • Improved suggestion system a bit
  • Fixed a bug that caused object handles to stick when resizing
  • Postgres - autoincrement to serial mapping now working again
  • Registration and certain startup information windows now appear less often (Only once a day)
• 1.3b4
  • Export operations can now be canceled
  • Fix for adding types in preferences window
  • Fix for schema name missing on export
  • Fix for artifacts appearing when dragging
  • Hide/show objects causes resize when auto size tables option set
  • Fix for connectors highlighting after document load
  • Minor bug fixes
• 1.3b3
  • Export to image now supports JPEG and PNG formats
  • Export to JDBC is now interruptable
  • Find object is now case insensitive
  • Fix for a bug involving undo and redo with foreign keys
  • Export to SQL and Save As Image are now sheets (not dialog boxes)
  • Improvements when importing from MySQL Isam tables
  • Export now correctly includes schema name (if set)
  • Fix to a bug that caused objects to resize in a weird way
  • Internal improvements
• 1.3b2
  • Improvement in group selection speed
  • First version of SQLite export dialect
• 1.3b1
  • Rails improvements
  • Added option to remove the SQLEditor exporter header in exported SQL
  • Major Version number increased (1.2→1.3b1)
• 1.2.4b4
  • Added rails export type replacement
  • Added rails export file name correction
  • Modified camel case converter (rails)
• 1.2.4b3
  • Added multi-column unique index support for tables
  • Improved some parts of import export
  • Added default SQL Dialect setting for new documents
  • Rearranged preferences panel
  • File export popup now changes file extension to match export type (mainly for rails)
  • File extension can now be shown or hidden in export dialog
  • Option Dragging tables to another application using option now respects export setting
  • Rails export now uses rb extension
  • Rails Export identifiers now auto convert to Camel case if quote identifiers is off
  • Other rails improvements
  • Rails id columns are now automatically removed from exported data (but not from the sqs file)
• 1.2.4b1
  • Ruby on rails exporter added (experimental)
  • Limited release only
• 1.2.3
  • Fix for file reading error with certain types of corrupt files [FS#376,FS#374]
  • Fix for inline field rename bug [FS#375]
  • Fix for version check bug involving beta versions [FS#378]
• 1.2.2
  • Fix for Postgres export [FS#373]
    • Fix for incorrect quoting
    • Fix for incorrect sizes
    • Fixes for incorrect handling of default values
• 1.2.1
  • Fix for a bug with moving connector handles
  • Fix for Oracle named schema bug
  • Fix for Postgres JDBC connect string bug
  • Fix for Postgres quoting bug
  • Fixes for Postgres JDBC bug
  • Fix for a postgres unique key export bug
  • Added option for schema name on tables (only Oracle exporter supports this)
  • Added option to disable all quoting of tables in export (advanced users only)
• 1.2
  • Released 24/04/2006
• 1.2b6
  • Internal - not released
  • Added option to prevent quoting of default column/field values with a checkbox
  • Improvements to online help and the manual
• 1.2b5
  • Released 31/03/2006 - Expires 30/04/2006
  • Fix for comment inspector text coloring errors [FS#340]
  • Log files weren’t being attached to suggestions - fixed [FS#361]
  • Added export support for timestamp with timezone option box [FS#267]
  • Added support for hiding of field icons on columns [FS#255]
  • Fixed quoting character appearing when importing from SQL [FS#362,FS#365]
  • Import complete message was appearing twice - fixed [FS#364]
• 1.2b4
  • Fix for a window resize bug [FS#359]
  • Fix for a canvas sizing bug when reopening large schemas [FS#360]
• 1.2b3
  • Fix for a MySQL export bug [FS#357]
  • Fix for non-quoting of names in export [FS#341]
• 1.2b2
  • Parsing improvements
  • JDBC Import and export improvements
  • New zoom controls on each window
  • Fixes for Oracle JDBC and SQL dialect errors
  • better support for Oracle indexes
  • Minor fixes
  • Option to zoom using Mouse wheel
• 1.2b1
  • Parsing improvements: better index import, first support for constraints
  • Fix for a bug involving undo handling and connectors
  • Better index support (at table level), now also handles multi-column indexes
  • type matching is now case insensitive
  • added the expiry date for the beta to the about box
  • renumbered to 1.2 from 1,1
• 1.1.4b6
  • Fix for a bug that caused files not to load if the comment namespace overlapped with the table namespace
• 1.1.4b5
  • Minor internal refactoring of label handling
• 1.1.4b4
  • SQL Parser improvements
  • Added support (initial for timezone option on timestamps)
  • Preference to change grid size (global)
  • Removed plugin and export menus (unless plugins are installed)
  • First version of import table selection - note that this may cause export errors
  • Minor fix to table layering
  • JDBC export can now alter mysql table types (e.g from INNODB to MyISAM
  • Fix for index export bug
  • Fix for bug that prevented undo on connector delete
  • connectors are now deleted using the delete key (or via the target field)
  • Fix for improved error recovery on JDBC import errors
• 1.1.4b3
  • Fix to improve import from SQL of foreign keys
  • Fix for a minor bug in SQLParser that produced incorrect error messages
  • Fix for a bug that caused extra commas to be inserted into exported SQL files.
• 1.1.4b2
  • Fixes for saving, importing and pasting in intel release
  • Improvements to SQL export via JDBC
  • Fix for an exception that wasn’t being caught when importing
• 1.1.4b1
  • First release with intel architecture support
• 1.1.3
  • Fix for problem that caused lines to be missing on print outs
  • Added support for importing column sizes and enums via jdbc
  • Fix for context menu sometimes being disabled
  • Fix for bug when resizing an object that is part of a selection
  • Fix for an obscure foreign key export problem
  • Changed quoting of tables and columns in mysql
  • Added a preference for using GO when exporting to sybase
  • Fix for duplicate index creation bug in mysql
  • Fix for beta expiry date being wrong (although not visible in release version)
  • Rewritten update checking code - now checks for updates in a separate background thread
  • SQLEditor now saves window size and position in each document
  • New option to not open a new window at startup
• 1.1.2
  • Internal release only
• 1.1.1
  • Fix to a bug that prevents moving the control handle on connectors [FS#290]
• 1.1
  • Non beta version - this version won’t expire if you have a serial code
  • Improved handling of large tables when scrolling and dragging [FS#184,FS#287] (scrollview doesn’t move in the wrong direction anymore)
  • Improved printing support on 10.4, page header doesn’t overlap objects now [FS#124]
  • Option added to disable checking for beta versions [FS#286]
  • Page grid added on a per document basis [FS#119]
  • snap to grid added [FS#264]
  • Added new Oracle dialect for export (still being worked on) [FS#260]
  • switched to IF EXISTS in mysql exporter [FS#283]
  • Improved update checking [FS#243]
  • fixes for some SQL import bugs including timestamp fields with on update arguments, some kinds of comments and table names that start with symbols such as the underscore.[FS#274,FS#265,FS#270]
  • other minor fixes
  • reverted to b6 behaviour on quotation marks for default values. 1.1.0b7 tried to automatically add and remove these, but failed. Functionality has been removed, although it may return as an option in a future version

• 1.1b7
  • Added auto detection of JDBC Drivers
  • Fix to SQL import to fix a problem that prevented comments followed by semi-colons from being imported
  • Fix for importing enums with NULL option
  • Fix for the add driver menu in the import and export windows not working
  • Improvements for Export to database
  • New preference for foreign key type checking
  • Fix to drawing of cardinality lines where these were sometimes chopped off.
  • Made field (column) types case insensitive (and forces them to uppercase)
  • Minor fixes to a number of other areas
• 1.1b6
  • Basic index support added, multi-column indexes aren’t supported yet though
  • Fix for an odd export bug that caused fields to appear in the exported sql without an enclosing table
  • Improved version checking code (now checks for beta versions as well)
  • Fix for a crash that sometimes occurred when setting document options
  • new printing code (option in preferences) that allows better headers, time and date and file name indications
  • Fix for a bug with annotations that caused the annotation to appear for all objects and with null values
• 1.1b5
  • Fixed a bug that was preventing export to database from working. (Please read the readme file for information about database export)
  • user settable tooltip ‘notes’ on tables and fields
  • New guidance and warning icon (red U) on unique keys for foreign key relationships
  • re-written sizing and icon drawing for field icons, should be more efficient.
  • Comment autosizing
  • better handling of compound primary and foreign keys
  • The cancel button in the add label panel now works (not that it really does anything the close box doesn’t do though)
  • Fix for some bugs that could cause a crash when you have a circular foreign key relationship i.e. if you have three tables: a, b c. a.id → b.id → c.id → a.id. That worked before, but more complicated relationships crashed. Now appears to be fixed.
  • changed the way that the warning icons appear in the inspector
• 1.1b4
  • Fix for scrolling jitter with very tall or wide objects
  • Added a way of changing the drag handle size from the preferences window
  • Added Help→Registration to allow registration from the help menu
  • Modified the welcome window to be clearer
• 1.1b3
  • Added a new find object panel
  • Drop object on export added (File→Document Options)
  • Per document sql export dialects now saved (File→Document Options)
  • Improved selection, copy and paste so it fits in with other applications better. It now selects the new object after pasting or dragging, rather than leaving the selection on the old object
  • Default value quoting. Changed to give permanent quoting
  • Icon highlighting. Fixed : Fixed as far as testing can tell
  • A suggestions window - directly accessible from the application. Creates an email in mail.app with the correct address
  • Microsoft SQLServer is now believed to be working
  • Added a collection of new checkboxes to the field inspector
  • Bug in inspector undo. Fixed
  • Changed the architecture of the inspector panel so that inspectors are registered dynamically (Should support plugin inspectors, except that the API isn’t public yet)
  • Using copy/paste export now correctly reflects the current document dialect
  • Changed the Database preference window “Open Directory” button to work more reliably.
  • Drag to copy on the canvas or between documents by using drag+option.
• 1.1b2
  • Fixes for a serious bug in the load/save system that was causing some characters to be lost under some rather odd circumstances
  • Fix for a bug that was introduced in 1.1b1 that caused a crash if a circular relationship was created.
  • Midpoints for othogonal lines are now saved when they are changed. (There is a preference to disable this)
  • Connector drawing system has been re-arranged which will provide extra features in the future.
  • Fixes for some minor parser bugs
  • JDBC Export improvements
  • The about box now shows what type of license is in use, in addition to the existing information
  • Fix to a bug that caused some objects that were dragged from the palette to be incorrectly positioned
• 1.1b1
  • JDBC Export functionality.
    This is still being worked on, but it supports exporting tables to a JDBC database, adding and dropping, plus adding and dropping fields. Modifying fields is still to come
  • Save JDBC connect details between launches. Implemented
  • Specify field size instead of using custom field types. Implemented
  • Objects can have size 0, causing them not to display. Fixed
  • allow setting colors on objects. Implemented
  • Store state of palette and inspector. Implemented
  • Bug with enums, spaces and import from file. Fixed: Fixed
  • allow drag/drop between windows. Implemented
  • Color code/hilite primary keys.. Implemented
  • Foreign key type checking. Implemented
  • A window toolbar. Implemented
  • Duplicate Objects. Implemented
  • Field gap at bottom of table. Fixed
  • Drag handle size. Implemented
  • Table name positioning. Implemented
  • Field spacing too big. Fixed
  • Oracle JDBC Connectivity. Fixed
  • Duplicate object command. Implemented
  • Draw Border Checkbox state. Fixed
  • Freeze in update checking if server is down. Fixed
  • Object layering is not saved. Fixed
  • Default file names for exporting. Implemented
• 1.0.5
  • Fix to a layering bug that prevented canvas areas from being layered behind other objects.
  • Improved behaviour with version checking if the update server is unreachable
  • Initial support for some minor parsing improvements when using INSERT
  • Minor optimizations
• 1.0.4
  • Fix to a bug that was created during the fix to the foreign key export bug
  • Fixes to some other minor issues
  • 1.0.3 was incorrectly built using an experimental SQL parser. This has been removed and replaced with the production parser
• 1.0.3
  • Fix to a bug that caused a crash when using the popup menu to delete a field from a table
  • Fix to a bug that caused foreign keys to be exported incorrectly if the target field had been renamed
  • Improved preferences handling in some cases
  • Improved registration handling in some cases
  • Slightly changed the arrangment of menus
• 1.0.2
  • Added capability to move connectors horizontally when in orthogonal mode
  • Improved oracle support
  • Fixed a bug where page numbers, headers and footers were not being displayed correctly
  • Improved automatic update checking in various ways
• 1.0.1
  • Added a field to select a schema within a database from JDBC import
  • Fixed a memory leak in the JDBC import system that was causing out of memory errors
  • Minor optimisations
• 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