Version History

This document contains details of changes made in each release of SQLEditor

---

• 4.0.3
  • Fix for crash when parsing default values on intel machines
• 4.0.2
  • Fix for auto-resizing issue if all instances of an object type (e.g indexes) are hidden
  • Fix for incorrect escaping in SQL comments
  • Increase maximum length for MySQL comments to 1024 characters
  • MySQL comments are now truncated before being escaped to allow the full length to be exported
  • changed the appcast url for v4 release
• 4.0.1
  • Fix for crash when editing views with schemas in certain configurations
  • [includes 4.0.0b2,4.0.0b5,4.0.0b6,4.0.0b7]
• 4.0.0
  • Release version of 4.0.0b7
  • [includes 4.0.0b2,4.0.0b5,4.0.0b6,4.0.0b7]
• 4.0.0b7
  • Internal improvements and refactoring work to SQL export
  • Other minor changes
  • (Some of the planned features for this beta were not ready and pushed to a later release)
• 4.0.0b6
  • Updated Icon (Created by Johan Basberg)
  • Updated expiry date to 30 April 2022
• 4.0.0b5
  • Updated registration system for V4
  • Updated upgrade and registration windows for V4
  • Fix internal page links
  • Now correctly shows 2020-01-01 as start of valid licenses
• 4.0.0b2
  • MacOS 10.14 now minimum.
  • First native Apple Silicon Release
  • This release bundles both Intel and ARM Java runtimes for JDBC use
  • Updates to Postgres and SQLite database drivers
  • Bundled JRE is now optional and SQLEditor can instead use system installed Java runtime if one is available
  • Updated Sparkle updating
  • Improvements for UI layout and controls on MacOS 12
  • DJango plugin can now find and use homebrew or Official python installs
  • Fix Python warning at startup on MacOS 12
  • Fixed bug where the parser would fail to parse default values if the parser was called too frequently in certain odd cases.
  • Fixes for Django Plugin including better error reporting
• 4.0.0b1
  • Internal beta release
• 3.7.7
  • Fix for launch issue on Apple Silicon M1 macs
• 3.7.6
  • Fix for document restoration bugs
  • Fix for possible issue where draft documents that had not been named could fail to reopen on restarting SQLEditor
  • Scroll position and left sidebar panel selection should now be saved correctly
  • Minor changes to handling of auto-save settings
• 3.7.5
  • Now parses and imports independent CREATE FULLTEXT INDEX instructions in imported SQL DDL
  • Fix some unnecessary FULLTEXT index drop/add replacement
  • Fix incorrect dialect export on SQLWorker command line export
  • SQLWorker now has a command line option to specify an SQLite database for import or export
  • Minor change to embededded JRE to fix symlink issue
• 3.7.4
  • Fix for control handle on orthogonal connectors sticking
  • Fix for crash when saving images and exported sql (when a specific preference value is missing)
  • Fix for SVG fonts appearing incorrectly in some cases
• 3.7.3
  • Fix for label color changing to black if color picker window was open after changing label color
  • Fix for clicking default lable color not changing color of default objects
• 3.7.2
  • Fix for duplicate labels appearing in labels list
  • Fix for labels when copying and pasting
  • Better label handling when you paste a labeled object into another document
  • Better performance when selecting labeled objects
  • Better select all performance
  • Fixed redraw performance issue when selecting objects in a group
  • Fixed label list updating when deleting and undoing the delete of a labeled object
  • Colors are now always sRGB colors, previously some colors were device colorspace
• 3.7.1
  • Fixes for SSL support when using MySQL JDBC Drivers
  • This version has a Java runtime with more modules included to solve problems with certain JDBC drivers
• 3.7.0
  • New dark content mode option in preferences panel - display content of documents in dark mode
  • Options for light and dark UI and Content
  • Default setting uses dark ui with light content when in dark mode, light ui+light content in light mode
  • Dark mode option for saving images (choose light or dark export in image export panel)
  • Added Amazon redshift data types
  • Added importing of Postgres comments
  • Schema background color can be set by user
  • Fix for file type not updating in save panels
  • Fixes for some minor analyser issues
  • Fix for bug where export images or files could cause save panel to freeze in various odd cases
  • Fix for bug where moving connector handle could cause schema to scroll to origin
  • Connector midpoints (if set) now get relocated relative to the originating table when copied
• 3.6.2
  • Release version of 3.6.0b6
  • [includes 3.6.0b1,3.6.0b2,3.6.0b3,3.6.0b4,3.6.0b5,3.6.0b6]
• 3.6.1
  • No public release
• 3.6.0
  • No public release
• 3.6.0b6
  • Fix for help search box not working on 10.10 and 10.11
• 3.6.0b5
  • Fix for bug when launching on Mac 10.10
• 3.6.0b4
  • Fix for bug where "Show All Objects" would not show table components that had been hidden
  • Fix for incorrect checkmarks in visibility toolbar item menu
• 3.6.0b3
  • New Help system, should work the same as AppleHelp and contain the same content as before
  • Fix for bug in feedback reporter where tab view labels would disappear
  • Updated feedback reporter to newer release from upstream
  • Feedback reporter now displays the log data in the console tab instead of the script tag
  • Warnings about ASL access in feedback system have been fixed
  • Fixes for some memory management issues
  • Fixed some web links that were using http instead of https
• 3.6.0b2
  • New object visibility menus in toolbar and view menu - show and hide objects by type
  • New command to show only fields that are primary keys in tables
  • New system to save django properties when used
  • New preferences panel to edit the saved django properties list
  • Fix for potential issue where invalid django properties could render a file unreadable by SQLEditor
  • Fixes for foreign keys where fields are hidden (the line retargets the table header)
  • Updated some old code that still used old style alert panel methods
  • Removed final parts of Java 6 installation code
  • Merge in 3.5.6 fix
• 3.6.0b1
  • Minimum required Mac OS is now 10.10
  • First notarized version
  • Hardened runtime enabled
  • Now bundles and uses Amazon Corretto Java 11
  • Removed old Java 6 support
  • Updated drag and drop code
  • New option for comments without visible titlebars
• 3.5.6
  • Fix for left sidebar icon drawing on 10.12,10.13
• 3.5.5
  • Fix for inline renaming and comment editing in dark mode not working due to text sometimes appearing in white on white background
  • Fix for insertion point color being incorrect in some cases (and so hidden also)
  • Fix for drag handles not layering correctly
  • Fix for bug when copying object and the dialect was set to JSON
• 3.5.4
  • Fix for issue where comment objects would stop drawing comment text after double click during editing
  • Fix for minimum size not being respected for comments (could set size to zero)
  • Slightly modified automatic resizing for comments and tables to better fit object title
• 3.5.3
  • Modify postgres identifier quoting so that mixed case object names are quoted
  • Postgres exporter also defaults to quoting object names that are entirely uppercase. (New preference turns this off)
• 3.5.2
  • Identical to 3.5.1, used for testing sparkle self updating only
• 3.5.1
  • Fix toolbar label positioning
  • Fix spacing in toolbar items
  • Fix missing icon in constraint inspector
  • Fix for focus ring not drawing in canvas when dragging objects into the document
  • Fix jump to parent table button in inspector panels not working when inspecting constraints and foreign keys
  • Fix for text-only mode toolbar items not working
  • Modified application help to improve reliability
  • Updated Sparkle update system which should fix a crashing bug that occasionally occurred
  • Changed wording of option to "Always quote identifiers on export"
• 3.5.0
  • Release version of 3.5.0b2
  • [includes 3.5.0b2]
• 3.5.0b2
  • Add new dark mode for Mojave (10.14)
  • Better applescript support, can now add more types of object, delete objects and extract cardinality information
  • Better file reading code is now enabled by default
  • New option to turn dark mode on or off for SQLEditor only or follow system setting
  • The icon on the button that links a field to its parent has been changed
  • Some other graphics have been redrawn mostly without change
  • The drawing of the icons in the left (source) sidebar toolbar has been improved
  • Cursor images for creating foreign key connections have been redrawn
  • Color modification for selected tables has been modified slightly
  • Fix: Tables that have position locked will now resize if a field is added
  • Fix: The show object palette menu command now works properly again
  • Fix for extra lines sometimes appearing in the blue overlay selection rectangle
  • Fix: the add field button on the table inspector is now disabled if more than one table is selected
  • Fix: Better automatic quoting for identifiers with characters that require quoting (postgres,mysql)
  • Fix: for bug where about box display caused crash if appearance had changed
  • Added new preference to turn off quoting for identifiers with characters that require quoting (postgres,mysql)
  • Removed print toolbar item
  • Some images in the app that were redundant have been removed
  • Minor cleanup and fixes
  • Now built with 10.14 sdk
• 3.5.0b1
  • Internal beta release
• 3.3.12
  • Fix for MySQL JDBC Connector/J 8.x issue which caused tables not to be imported
• 3.3.11
  • Release version of 3.3.10
  • [includes 3.3.7,3.3.8,3.3.9,3.3.10]
• 3.3.10
  • Fix for possible crash when running on 10.11 or earlier and opening inspector panels
  • [includes 3.3.7,3.3.8,3.3.9]
• 3.3.9
  • Fix for smart quotes being substituted for standard quotes in view definition text field and various object comment text fields
  • Fix for odd crash that occurred when document became main in 3.3.8 but notification occurred on a secondary thread. This mostly meant that the app crashed if you checked for updates manually.
• 3.3.8
  • Fix for bug where SQLEditor wasn't matching MySQL default update and delete actions correctly on imported foreign keys, causing foreign keys to be dropped and readded incorrectly when no changes had occurred.
  • MySQL initial default type could sometimes be INTEGER instead of INT (This mapped to INT, but was confusing). Fixed.
  • Source view is now updated when a document becomes the main window.
  • List of file names in diff view is now updated when document changes or becomes main window
  • ON DELETE/ON UPDATE now export RESTRICT in relevant dialects
  • ON DELETE/ON UPDATE "SET DEFAULT" is now treated as an empty setting (which is normally RESTRICT) in MySQL, which doesn't support this action in INNODB
  • [includes: 3.3.7]
• 3.3.7
  • Fix: creating a new object wasn't moving focus to the name/title field in the inspector
  • Fix: "Inspect Object" command now correctly moves the focus to the name/title field of inspector.
  • Foreign key objects now highlight the columns they link when either the connector or the foreign key object is selected
  • Connector lines now have a context menu with appropriate commands
  • Sparkle has been updated to a newer release
  • Some obsolete resources have been removed
• 3.3.6
  • Internal release version only
• 3.3.5
  • Fix for a bug in postgres where foreign key target table names that included a schema could be incorrectly quoted if "quote identifiers on export" "was off
  • Fix for bug where postgres and oracle exporters would produce "drop default" instruction when both document and database column default value were empty.
• 3.3.4
  • Fix for a bug where object hidden state wasn't being saved
  • Rewritten parts of the inspector code to remove a crashing bug
  • TargetProxy object which caused some crashes has been removed entirely and the section rewritten
  • Undo after deleting a table which is the target of a foreign key object now correctly restores the connection line
  • Connector control handles now don't snap too far to the right in certain odd cases
  • Fix so that constraint key names cannot be edited with the inspector when multiple objects are selected
  • It was previously possible to fix a connection point and move both tables to the right of that point. The line will now snap properly to the right.
  • (This behaviour wasn't correct, but it is hoped to add more positioning options in the future)
  • Much of the document XML loading code has been rewritten (but this new code is currently turned off)
• 3.3.3
  • Fix for bug which caused an active inline rename edit text edit field not be removed when the field was deleted
  • [includes: 3.3.2]
• 3.3.2
  • Fix for bug where ui code could sometimes be executed on the wrong thread when saving files in the background
  • Fix for bug where file types didn't update correctly in the report save panel
  • Javascript exception message for plugins now display file name if it is available
• 3.3.1
  • Fix for a crashing bug that could prevent SQLEditor from launching due to plugin issue
• 3.3.0
  • [includes: 3.3.0b4,3.3.0b3,3.3.0b2,3.3.0b1
• 3.3.0b4
  • Django now allows specifying a virtualenv directory (See Preferences->Export>Django)
  • Native plugins now support custom foreign key type matching (in JS soon)
  • Fix for crash in find sidebar
  • New method of loading ui panels for plugins
  • Django now doesn't flag ForeignKey type mismatches
  • Fixed various bugs in foreign key type matching
  • Fixed some memory management issues
• 3.3.0b3
  • Can now use inline renaming on indexes
  • Fix for inline renaming editing issues
  • Fix sidebar toolbar button icons
• 3.3.0b2
  • Fix bug which caused table to move when copying if non default label applied
  • Fix for svg canvas areas and comments being incorrectly drawn
  • fixed bug causing extra semi colon to be inserted in prologue sql blocks
• 3.3.0b1
  • New option to add custom SQL at the beginning of exported SQL
  • New option to export custom SQL, both pre and post document, to database. (Cannot deal with delimiter changes yet though)
  • Postgres now uses DROP TABLE IF EXISTS when dropping tables
  • Comment inline editing now turns off the font panel (which allowed unexpected behaviour)
• 3.2.2
  • Fix for exception when selecting objects on 10.11 and earlier caused by touchbar code
  • [includes: 3.2.1,3.2.0]
• 3.2.1
  • Fix for crash when save connector position was turned off and connector style is orthogonal (#268)
  • Renamed "save connector position" preference to "Use stored orthogonal connector position"
  • Previously connector position data was lost if the "save connector position" setting was turned off, it is now saved if it is available
  • Connector handles are not shown if the "Use stored orthogonal connector position" preference is unchecked
  • Add a new compatibility warning if you open a file from a new version of SQLEditor in an older version
  • Fixed a bug relating to autosizing
• 3.2.0
  • Add first touchbar support (Add table, add field, duplicate and copy commands are available)
  • Modified django exporter field panel (can now add any property you like on columns)
  • Type sizes will not be displayed in the main canvas where the dialect doesn't support them (preference to turn off)
  • SQLServer exporter is better at knowing which types support sizes and which don't
  • Drag and drop now supports plugins (including JS plugins)
  • Fixed issue where icon for sidebars was different on retina screens vs non-retina
  • Fixed issue where SQLWorker was sending messages to the wrong thread during startup
  • Fix issue with some selection events not changing with multiple selections
  • Fewer log messages at startup for Java
  • Plugin loading now logs to a single line
  • Fix for Django plugin python error on startup if Django is not installed
  • New list of currently installed plugins in preferences window (under export)
• 3.1.9
  • Fix for exception in new JSON exporter
• 3.1.8
  • Release of 3.1.8b2
  • [includes: 3.1.8b1,3.1.8b2]
• 3.1.8b2
  • Fix for crash in parser that occurred when default values failed to parse
• 3.1.8b1
  • First support for importing with Javascript plugins
  • New JSON file export format
  • New option to enforce unique foreign key names across the document (currently off by default, but will be on by default in a future release)
  • Parser fix for GROUP_CONCAT
  • Parser fix for select entries that involved calculated expressions
  • Parser fixes for importing certain types of triggers
  • Fix for bug when importing triggers from SQLite
  • Fix for inline rename bugs when using undo
  • Better resizing of objects in the right hand sidebar
  • Internal changes to modernize code and remove some obsolete stuff
• 3.1.7
  • Added new refactor command (menu->edit->refactor) to bulk change field types across the whole document
  • Added new refactor command to change the case (uppercase/lowercase) of all object names
  • Fix crashing bug with javascript export due to a circular reference between the export jscontext and a SQLEditorJS helper object
• 3.1.6
  • Fix for bug where diff output was empty due to exporter incorrectly thinking canvas objects were tables when they were not.
  • Fix for diff which failed to drop foreign keys in some cases
• 3.1.5
  • Update bundled java runtime to Java 8
  • Fix bugs in dropping Unique keys
  • Fix JSON dictionary for field foreign keys having missing values
  • Fix Postgres drop cascade
  • Fix for ordering of foreign key modification
  • Fix for various auto layout warnings
• 3.1.4
  • Now distributed in a dmg (again) due to changes in gatekeeper on 10.12
• 3.1.2
  • Move primary key constraint name into object section of table inspector
  • New db export checkbox "Drop Check Constraints". Prevents dropping check constraints unless checked.
  • (Altering constraints is permitted)
  • Removed SQL server specific panel (primary key constraint name is now part of the main inspector)
  • Fix postgres alter not null and default value
  • Fix oracle alter not null and default value
  • Fix incorrect sql when dropping postgres constraint
  • Most dialects now add a primary key constraint name when exporting
  • Field level check constraints (appeared in 3.1.0) have been removed in favor of table level check constraints.
  • Any field level check constraints will be converted to table level constraints when loaded
  • Fix check constraint name parsing (SQL)
  • Removed obsolete "Install Java" button in preferences panel
  • [includes: 3.1.0,3.1.1]
• 3.1.1
  • Fix for primary key values not updating in export when field name is changed
• 3.1.0
  • Added Check Constraint object for tables
  • Added field level check constraints for fields
  • Added import check constraints via SQL parser
  • Added import check constraints from database import for Postgres and SQLite, SQLServer
  • Check Constraint exporting for Postgres, SQLite, SQL Server
  • Better modification of primary keys when modifying columns that are part of the primary key
  • SQLEditor will now drop and replace foreign keys if it needs to modify a primary key
  • Fix for SQL server export where SQLEditor was exporting RESTRICT keyword incorrectly
  • Can now move default style connector position in some modes (control handle appears when possible)
  • Modified connector lines to avoid objects better
  • Fix parse foreign key where the column list in the target table is unspecified
  • Revised field and index export slightly so that constraints appear after fields
  • Fix table name lookup for foreign keys in specific cases where the name included a schema
  • Fix SQL server field constraints
  • Fix table ordering when importing (incorrectly reversed in 3.0.3
  • Primary key constraint name is now used in most dialects
  • Foreign key constraint names are used in more cases
  • Field to set primary key constraint name in postgres, sql server dialects
  • New field for foreign key constraint setting in field inspector fk panel
  • SQLite exporter now rebuilds tables in more cases including when primary or foreign keys have changed
  • SQL server primary key columns now export as NULL even if this is not explictly set
  • Updated help with new sections on constraints
  • Fix html report export foreign key constraint name not exporting on field fks
  • Fix html report export object comments not exporting on fields
• 3.0.3
  • Fix for bug where fields could not be dragged after a table was copied or duplicated
  • Fix for forced object renaming incorrectly where the name contained an underscore and a number
  • Fix for layering of objects on opening saved document being wrong
• 3.0.2
  • Release version of 3.0.2b2
  • [includes: 3.0.2b1,3.0.2b2]
• 3.0.2b2
  • Fix redshift jdbc 4.1 driver auto detection
  • Fix field foreign key diff where only the constraint name differed
  • Add redshift diff export (early support still)
  • Fix SQL Server unique constraint export
  • Fix missing drop table instruction
  • Fix index auto-naming adding the table name more than once in some cases
• 3.0.2b1
  • Added line numbers for javascript plugin exceptions
  • Added type list support for js plugins
  • Add early support for Amazon redshift (driver detection + use of postgres dialect)
• 3.0.1
  • Fix HTML report if value has been unset between document being opened and report being generated
  • Fix javascript diff so that plugins get an empty container instead of an empty string
  • Fix for javascript plugin crash caused by plugins with incorrect directory structure
• 3.0
  • SQLEditor 3.0 Release Version
  • Functionally identical to 3.0rc5
• 3.0rc5
  • SQLEditor 3.0 Release Candidate 5
  • Removed an obsolete assertion in the resize code that caused an exception
  • Fixed missing diff callback for js plugins
• 3.0rc4
  • SQLEditor 3.0 Release candidate 4
  • Added extra new line in diff between alter table instructions
  • Fixed source sidebar not refreshing with changes made when it was closed
• 3.0rc3
  • SQLEditor 3.0 Release candidate 3
• 3.0b18
  • Fix for canvas sometimes not correctly resizing when documents loaded
• 3.0b17
  • Fix code sign issue relating to HTML plugin that caused updates to fail
• 3.0b16
  • Deleting foreign keys using the delete key could break undo
  • You can now select a group of fields and delete all of their simple foreign keys using the delete button in the inspector
  • Hiding connector lines now correctly also hides the connector label
  • Fix for source view not updating when deleting fields (and field like objects)
  • Foreign key names for table level foreign keys should now get exported in mysql dialect
  • Foreign keys now get named using the same algorithm as indexes
  • Foreign key and index naming algorithm now includes schema name if set
  • Fix to make tabbing between controls in inspector views work better
• 3.0b15
  • Fix for inline rename text scrolling while editing
  • Fix for comment text inline editing bug which caused the edit to abandon immediately
  • Fix for autosizing comments (Previously double clicking on the titlebar went to rename instead of autosize)
  • Fix rename text field sizing
  • Fix for right clicking on field while rename in progress not working
  • Changed add preset label to make it clearer
• 3.0b14
  • New grid drawing code which should hopefully improve performance and reduce memory usage
  • Database import and export now log host and database name in the message pane
  • Cause of serial code issue has been identified as an incorrect locale on a NSDateFormatter
  • Serial code issue affected users where mac was using 12 hour rather than 24 time display in some locales
  • Fix missing nib outlet for new document with dialect panel
  • Modified inline name editing to stop editing if the canvas magnification changes (This seems better in testing)
  • We skipped beta 13 for obvious reasons
  • Slightly newer sparkle 1.14 release
• 3.0b12
  • Hopefully fix bug that prevent serial codes being accepted in some cases
  • Fix exception when entering serial codes when reaching the 11th letter
  • Upgrade sparkle to 1.14.0 (although we use HTTPS for appcasts anyway)
• 3.0b11
  • Improve parser support for CLUSTERED and FULLTEXT index types
  • Fix for line position in arrow style being wrongly positioned
• 3.0b10
  • Fix crash in view parsing when a select statement ended in a space followed by an invalid string
  • Views now remove field and table list entries when the select statement is empty
• 3.0b9
  • Better parsing of postgres create procedure
  • Fix some parser errors that were causing log messages
  • Fix check constraint parsing (not actually used yet, but doesn't now cause an error)
  • Certain parse error messages now display line and char position
  • When parsing primary keys, there was an error message that referred to foreign keys instead, this has been fixed
• 3.0b8
  • All errors and warnings should now appear in the sidebar
  • Parse status window shoudn't appear any more (all functions moved to status sidebar)
  • Fixed parsing for alter table instructions with unique and primary keys
  • Better handling of values quoted with a double quote during SQL import
  • Parse status window could hang in some cases, it's now been removed, so won't hang any more.
  • Parsing default values has been improved, especially for postgres style function values
  • Parsed default values that are not quoted should now automatically set the option to export that value without quotes
  • Fixed SQL parser handling of exclamation mark as a negation operator in boolean expressions
• 3.0b7
  • New connector line styles (solid, dotted, dashed) via inspector
  • Added svg support for arrow notation style
  • Crash with an undo-redo cycle on foreign keys
  • Fix foreign key inspector key path
  • Fix svg font size bugs
  • Fix svg text positioning
  • Fix svg cardinality circle positioning bug
  • Removed log message relating to empty foreign keys
  • Fix svg connector line positioning bug when connecting to a table rather than a field
• 3.0b6
  • Added new arrow style for foreign key connectors (Menu -> View -> Cardinality Style) in addition to default crows foot style
  • Fix exception when aligning objects (caused by changes to object storage arrays)
  • Fix toolbar version
• 3.0b5
  • Added drop table support for SQLite via database export
  • Focus correctly moves to object name in inspector when object is created (as happened in 2.x)
  • Removed NSForm from inspector panels (obsolete)
  • Canvas area labels were being drawn incorrectly
  • Modified registration system to use new v3 upgrade pages on website
  • Fixed appearance of toolbar items on 10.9
  • Fixed palette on 10.9
  • Fix for left sidebar starting width being less than minimum
  • Reducing logging when parsing (especially views)
  • Modified HTML Report to add primary key in indexes section
  • Improved HTML Report appearance
  • Moved report export to a new menu item (File->Save Report)
• 3.0b4
  • You can now choose font/size used for table titles and field text
  • First revision of applescript support for object editing
  • SQLite column drop is now possible
  • Changed add field name from "Add sibling" to "Add field to table" in response to a suggestion
  • New foreign key line drawing during creation (now snaps to location)
  • You can now delete multiple fields at once (and undo them)
  • Table numbering is now per document
  • Preflight panel has been removed and preflight actions now appear in the status panel (left).
  • Preflight action added to File menu
  • New preflight actions
  • Fix line thickness on exported pdf
  • Possible to connector foreign key to view, fixed
  • Better accessibility/voice-over support (WIP)
  • Fix index prefix being added more than once when moved between parent tables
  • field drag images could be vertically flipped
  • Updated Sparkle
  • Fixed delete/update actions in simple foreign key inspector panel
  • Removed various obsolete code
  • Fix crash when adding toolbar hand tool
  • Added exception for TLS 1.2 for update checking due to server limitations
  • SQLite foreign key ordering so that foreign keys appear after the fields they reference
  • V3 toolbar identifier is now different to V2
  • Minor changes to autosave for window position and split view sizing
  • Minor drawing changes for various things
  • Fixed the registration state indicator on the top of the window to use a NSTitlebarAccessoryViewController
  • Modified table header height when running on 10.9
  • Performance with font handling has been improved
  • Fixed bug causing slow downs during dragging
  • Modified loading to do less work in field height calculations
• 3.0b3
  • HTML report generator is now an export option and the JS Plugin is bundled into the app
  • JS API wasn't returning constraints properly
  • Added "deferrable" and "initially deferrable" "for constraints and foreign keys (Postgres dialect only currently)
  • Parse import for deferrable and initially deferrable
  • Fix for undo bug when dragging foreign key fields between tables
  • Updated icons
  • Improved icon drawing performance
  • SVG exporter now draws icons that match
  • Overview now shows page boundaries
  • Rearranged sidebar display menus
  • DJango plugin now tests for django before importing
  • Added option for SQL Server to add NULL for columns which do not have "NOT NULL" set
  • Restructured framework code and separated out the parser into a separate framework
  • Binary icon would sometimes appear incorrectly
• 3.0b2
  • Label sidebar panel was document specific and could change to show the front document instead
  • Fix overview panel redrawing when document scaled
  • New javascript plugin API
  • SQLModel now has better header structure
  • Removed obsolete methods from various classes
  • Performance with large documents has been profiled and improved in various places
  • More rails tests
  • Fix for label popup menu being really slow
  • Lots of api modernization and minor performance improvements
• 3.0b1
  • Tree view adds schema tree elements
  • Popup menu to switch tree mode from flat to by schema
  • Modernized most of the window and panel code
  • Merged in changes from 2.9.5-2.9.7
  • Fixed inspector dialect specific (mysql) stuff for table inspector
  • Object Palette has become the Object Library pane in the right sidebar
  • Inspector now displays default panel
• 2.9.4
  • Fix for bug where right clicking on drag handle or connector handle could cause exception
• 2.9.3
  • This version improves drag selection over locked canvas areas, fixes a keyboard navigation bug and fixes a possible exception when using the types popup via the keyboard
  • [includes: 2.9.3b1,2.9.3b2]
• 2.9.3b2
  • Now possible to drag select objects that are within the boundary of a locked canvas area.
  • Fix for next/prev to prevent selection of bits of the view object that aren't otherwise selectable
• 2.9.3b1
  • Previous Object/Next Object command order now matches the tree sidebar
  • Fix for bug where pressing T (field types shortcut key) caused an exception if the current object wasn't a field
  • Fix for Previous Object/Next Object commands not moving between tables properly
• 2.9.2
  • This version is a bug fix release for 2.9.1, which fixes an issue with the copy/paste export dialect.
  • Fix for possible exception when removing a menu item
• 2.9.2b1
  • Fix for copy/paste not generating sql in the selected document dialect
  • Added beta/status indicator back to window titlebar
• 2.9.1
  • This release offers better drawing performance, improvements to object selection and movement, SQL parsing improvements, better handling of sql types, various memory usage reductions and other bug fixes. It also offers an experimental new "export again" feature for sql and image export.
  • [includes: 2.9b3,2.9b2,2.9b1,2.8.6b6,2.8.6b5,2.8.6b4,2.8.6b3,2.8.6b2,2.8.6b1]
• 2.9b3
  • Fixes for bugs caused by changes to selection code:
  • Fix for group drag being broken
  • Fix for double click to rename and resize being broken
  • Fix shift deselect broken
• 2.9.0
  • Didn't escape beta release
• 2.9b2
  • Added postgres types - json,jsonb, tsquery, tsvector, txid_snapshot, uuid, xml
  • SQLEditor will now update dialect type lists with new or missing types (previously this required resetting the type list)
  • Change type list handling so it loads slightly earlier, this should remove a pause when the first field inspector loads
• 2.9b1
  • Renumbered to 2.9b1 because this release ended up being more significant than planned
  • New repeat export commands for file export. Hold down CTRL and the export to file command will be replaced by the new repeat export command. This repeats the last export without displaying any user interface (enable in advanced preferences for now)
  • New save image again command, similarly for image export, hold down CTRL and the save as image command is replaced (enable in advanced preferences for now)
  • The save as image panel now remembers the last image format correctly (even if you don't use the save again command)
  • Modified object selection to happen on mouseDown instead of mouseUp which should improve object dragging responsiveness
  • Right click now selects the object under the click if it is not selected (or part of a group selection).
  • Right clicking on the canvas now deselects objects
  • Icon caching is now selectively enabled depending on the scale factor (less than 0.75 and the cached icons are used) and turned off entirely for PDF output and print
  • Fix for text label clipping on connector view
  • Fix for deprecated drawing warning in sidebar tree view
  • Fix for memory management issue where a retain cycle was causing document windows to be incorrectly retained (the toolbar controller was retaining the window controller and so was a separate object proxy)
  • Fix bindings in main document nib as part of retain cycle problem
  • Fix for SQL parsing VARCHAR(max)
  • Fix for SQL parsing certain table level constraints
  • Fix SVG comment color was incorrect
  • Fix SVG comment shape was more complicated than required (two separate paths instead of one)
  • Fix for progress windows not being released and using extra memory
  • Refactored the welcome windows into separate nibs to reduce memory usage
  • Fixed some minor memory management issues that were flagged by the static analyzer
  • Revised app signing which should make no difference - but please report if it does
• 2.8.6b6
  • This version should hopefully fix the unexpected slowdowns in 2.8.6b1-b5 beta releases
  • Modified drawing system to better clip the invalid regions, which should speed up drawing
  • Main view is now reverted to being non-layer backed
  • This beta has a new advanced preferences panel to enable and disable layer backed main view drawing (it applies to newly opened documents only)
  • The advanced preferences panel will probably get removed again
  • [KNOWN ISSUE] text label on connector lines may get clipped
• 2.8.6b5
  • Disabled responsive scrolling (unexpected performance issues)
  • Fix for comment inline editing bugs
• 2.8.6b4
  • Fixed ALTER TABLE INDEX option for fields with indexed property (vs Table level Index objects)
  • Fix for inspector label menu crash
  • Overview panel was not updating when the last document was closed
• 2.8.6b3
  • Fix for overview panel ignoring saved visibility state.
• 2.8.6b2
  • Objects are now selected on the mouse down, not the mouse up (unless there are already objects selected). This should make dragging a non-selected object more responsive
  • Field icons are now cached
  • Optimized field drawing a bit. This isn't really noticable unless there are lots of fields
  • Field text is now drawn with core text which should be faster
  • Overview panel won't now redraw while you are dragging an object.
  • Fix for bug that appeared in 2.8.6b1 where a documentInfo object wasn't being retained
  • Inline rename rewritten to fix various bugs
  • Fix for field and table names that weren't automatically changing to avoid duplication
  • Experimental deferred notification for field selection, which slightly defers the inspector update for fields but allows them to draw sooner after clicking. (This may get changed)
• 2.8.6b1
  • Change sidebar tree to sort objects using natural order (1,2,...,10 rather than 1,10,2 ..)
  • New preference to change sort order of objects in exported SQL documents, to use name order instead of foreign key reference order
  • Responsive scrolling should now work on supported OS X versions
  • Improved overview drawing to draw less often
  • Fix to allow deleting multiple labels in the labels panel
  • Fix for delete label undo label being wrong
  • Fix for registration system to ignore space before or after when entering registration information
  • Fix for multiple inspector windows appearing when registering the app after initial startup.
  • Fixed possible bug in connector dragging code
  • Fixed Debug Menu test case (clickObjects)
• 2.8.5
  • This version includes better comment editing, the option to use "ALTER TABLE ADD INDEX" instead of CREATE INDEX in MySQL dialect, fixes for various bugs and better Yosemite (OS X 10.10) support. It also includes an updated bundled Java Version (7u67)
  • [includes: 2.8.5b1,2.8.5b2]
• 2.8.5b2
  • Added double-click to edit on comment field text
  • Added text overflow indicator on comment boxes
  • Updated bundled Java JRE to 7u67 (bundled into the app and used only by SQLEditor)
• 2.8.5b1
  • New export preference option to use use ALTER TABLE ADD INDEX instead of CREATE INDEX in mysql dialect (http://bugs.mysql.com/bug.php?id=48875)
  • Revised mysql index generation code
  • Revised MySQL dialect to allow fractional seconds support on TIME, DATETIME, and TIMESTAMP types (use the size field in the inspector)
  • Fix for bug where resizing the window while an object was being renamed caused the renaming field to resize proportionally with the window
  • Yosemite support changes - still a work in progress
  • Fix for exception in Yosemite when clicking on the document title in the window titlebar
  • Changed gradient drawing in sidebar when running on Yosemite
  • Removed remaining gestalt system calls (which was deprecated and generating a warning)
  • Removed view from titlebar which was generating warning in 10.10 (beta,unregistered, etc)
• 2.8.4
  • Fix for possible exception when dragging foreign keys and indexes
  • Fix for issue with foreign keys where the target table was empty
  • Moved the connection point for table level foreign keys upwards a bit (Now connects to the side of the object titlebar rather than the first object, which may not be there)
  • Minor fix to foreign key object to remove redundant log message
• 2.8.3
  • Fixed an issue relating to index diff with SQLServer
• 2.8.2
  • Fix for help menu items that were broken due to readme and release notes html files being missing from build
• 2.8.1
  • This version includes SQL parsing improvements, better tracking of state for unedited documents, revised inspector handling with better undo, a fix for misalignment of new objects, fixes to name conflict handling, better auto increment handling in mysql and a number of other minor improvements and bug fixes
  • [includes: 2.8,2.8.1b1,2.8.1b2]
• 2.8.1b2
  • Fix for schema name change on table not fixing name conflicts
  • Fix for auto increment restriction not being applied correctly where there are previous invalid auto increment columns
  • Fix for binding bug with table component parent name
• 2.8.1b1
  • Improvements to name matching (which prevents name duplication) with better handling of schema names and better updating
  • Fix broken name conflict match in 2.8b2 (and 2.8)
  • Revised mysql auto increment handling so that modifying a field to add auto-increment now works correctly
  • Fix for incorrect MySQL export where auto increment might appear on fields where it is invalid
• 2.8
  • This version includes SQL parsing improvements, better tracking of state for unedited documents, revised inspector handling with better undo, a fix for misalignment of new objects and a number of other minor improvements and bug fixes
  • [includes: 2.8b1,2.8b2]
• 2.8b2
  • Fix for add label menu command in table inspector (broken in 2.8b1)
  • Fixed object placement so that all objects are properly aligned at integer coordinates (Should appear sharper)
• 2.8b1
  • Fixed bug where documents would be marked as edited when just opened
  • Internal changes to status messages inside app (to fix document edited bug)
  • Revised inspector code, the inspector fields now should all update in line with undo actions in the document
  • Diff export for the sidebar is now run in a background thread
  • Work to improve startup time
  • Removed obsolete code in various places
  • Fix bug where dragging a selection area around a single object didn't update the inspector
  • Fix undo with locked status and draw border
  • Fixed crashing bug when undoing table name editing while in diff mode with MySQL exporter
  • Added workaround for NSDocument bug where app would crash if you save one document over another
  • Changed internal document field color handling, now uses property labelColor instead of FieldBackgroundColor (which is to be deprecated)
  • Fixed inspector field color handling bugs
  • Fixes for label inspector updating
  • Fix an odd bug which caused fields and tables with the exact name 'SOURCE' (without quotes) to be rejected by the SQL parser.
  • SQL parser should now have a much smaller list of reserved words due to parser improvements (new list tba soon)
  • Objects were being arranged backwards when imported from files, modified layout system to correct this
  • Documents that had been created via import (jdbc or SQL) were not being marked as edited
• 2.7.4
  • This version fixes issues with invalid characters in document files and fixes various other bugs
  • [includes: 2.7.4b1,2.7.4b2]
• 2.7.4b2
  • Fix for mysql character set list not appearing in inspector
• 2.7.4b1
  • Fix for bug which document code couldn't deal with certain invalid ascii control characters when reading files.
  • SQLEditor now removes any invalid characters from files before saving
• 2.7.3
  • This version includes SQLServer dialect improvements, Postgres export fixes, better default value quoting, rewritten overview panel thumbnail code and various bug fixes and smaller improvements. It also fixes 10.6 support which was broken in 2.7.2 beta versions.
  • [includes: 2.7.2b1,2.7.2b2,2.7.2b3,2.7.2b4,2.7.3b1]
• 2.7.3b1
  • Fix for OS X 10.6 support which got broken by accidentally using referencing two symbols only found in the newer OS X 10.7
• 2.7.2b4
  • Fix for postgres database export bug where tables without a schema should have been exported to the default schema (either set in DB panel schema field or "public" if nothing else set)
  • Fix for error in log about SQLEditor_documentInfo when accessing database via JDBC
• 2.7.2b3
  • Better quoting and escaping of default values that include quote characters in the value
  • Fix for bug in label panel that was possibly causing crashes when dragging objects
  • Fix for crashing bug in overview panel image drawing (and optimised the code path too)
  • Removed some regex code that was possibly causing a crash
  • Removed obsolete regular expressions code and replaced with better code
• 2.7.2b2
  • Fix for primary key constraint name when constraint name is empty or nil (removes CONSTRAINT keyword from output when empty)
  • Fix for foreign key diff changes when both original and new target field had the same name but were in different tables
  • Fix for alter foreign key constraint name keyword order
  • New warning when attempting to drop a foreign key but the constraint name is unknown
• 2.7.2b1
  • Improved SQLServer primary key export - can now specify constraint name
  • Fix for SQLServer diff - can now alter existing primary keys (if constraint name is set)
  • New SQLServer table inspector panel - to allow editing Primary key constraint name
  • Can now explicitly set constraint name for foreign keys in Postgres and SQLServer
  • Fix for bug in alter foreign key with postgres
  • Fix for duplicate export foreign key in postgres diff
• 2.7.1
  • This version includes improved drag and drop into documents, better postgresql view importing, some rails improvements, fixes for undo, some UI fixes, a fix for a crash relating to the preview window and various other minor improvements.
  • [includes: 2.7.1b1,2.7.1b2,2.7.1b3,2.7.1b4,2.7.1b5]
• 2.7.1b5
  • Change to post-import arranging code so that objects should get arranged in a more correct order during import (objects were previously being arranged in reverse order)
• 2.7.1b4
  • Improved file dragging into documents, now you can drag SQLEditor documents,SQL source files and SQLite files directly into the document window. If you drag in multiple files, the new files will arrange left to right in the document. You can also drag a mix of supported files.
  • Fix for bug where deleting objects and undoing would not restore all deleted objects
  • Altered undo event coalescing behaviour
  • Fix for zerofill in database import
  • Drag types and pasteboard types are now using UTI instead of type strings
  • Modified Paste menu command to only enable when the clipboard contains something that SQLEditor accepts
• 2.7.1b3
  • Fix for bug that caused a crash if a connector was moved then deleted, before undoing both actions
• 2.7.1b2
  • Changed handling of overview image
  • Fix for possible bug relating to lock focus
• 2.7.1b1
  • Fix for broken Database SQL View import/export. (file got removed from build target causing failure)
  • Changed postgres view definition query to use pg_views instead of pg_get_viewdef
  • Fix for Rails export not exporting indexed or unique properties on fields
  • Fix for Rails import failing with add_index
  • Fix for broken Rails schema (i.e. not migration) import, because it was looking for a classname which wasn't present
  • Fix for rails not recognizing index type unique on import
• 2.7
  • This version includes a new customizable object palette, fixes for running on case-sensitive formatted drives and various bug fixes
  • [includes: 2.7b1,2.7b2,2.7b3]
• 2.7b3
  • Fix for bug which prevented launch on case sensitive drives
  • Fix for Java launch bug on case sensitive drives
• 2.7b2
  • Fix for bug in new palette code, where palette item image would disappear because it wasn't in the cache
  • Fix for bug where View objects would incorrectly accept field objects via dragging and then crash or generate exception (depending on what else happened). Views can only be edited using the inspector currently.
• 2.7b1
  • New object palette, can rearrange objects, drag [holding option key] groups of objects to the palette or add new snippets from the clipboard via the palette menu (bottom left)
  • Fix for dragged objects sometimes being slightly misaligned from the pixel grid causing blurred edges
  • Removed previous palette
  • Fix for drag images of fields being vertically mirrored
  • Fix for custom SQL box in document info window incorrectly doing 'smart' quote conversion on 10.9
  • Revised SQLServer primary key handling - no longer generates a unique index as well as a primary key
  • Fix for case where diff was generated using generic rather than specific exporter
• 2.6.2
  • This version includes fixes for object target highlighting, scaled drawing, and object dragging
  • [includes: 2.6.2b1]
• 2.6.2b1
  • Fix for drop location being wrong when view is scaled
  • Fix for drop location when dropping on table
  • Fix for non-field objects dropped on tables being ignored
  • Fix for table focus ring being clipped wrongly when scaled
  • Changed drawing of table focus ring
• 2.6.1
  • Release version of 2.6.1b1
  • [includes: 2.6.1b1]
• 2.6.1b1
  • Fix for find panel bug where selection would be forced back to items selected in find panel
• 2.6
  • This version includes a new overview window, an updated bundled jvm, and various bug fixes
  • Removed incorrect keyboard shortcut from overview panel menu item
  • [includes: 2.6b1]
• 2.6b1
  • New overview window - shows a miniature view of the document with scroll position
  • Fix for bug when generating last-export snapshot (caused export to fail)
  • Fixes for various minor bugs (mainly memory management)
  • Fix for Overview window not refreshing when zooming
  • Revised code signing and moved JRE location to fix internal build issues on 10.9
  • Fix for a NSDateFormatter which was in 10.0 mode and generating a warning in the log
  • Fix for the SQLWorker tool using NSUserDefaults addSuite incorrectly
  • Fix for undo manager being incorrectly used from a secondary thread - should hopefully fix undo event grouping bug
  • Fix for bug in beta date display
  • Updated Java JRE to 7u45
  • Fixed SQLite table names were incorrectly being imported in uppercase.
  • Fix for colorWithString being missing from the SQLWorker tool causing export failures
• 2.5.1
  • This version includes fixes for various parser bugs, a fix for an xml parsing issue and fixes for some registration problems.
  • [includes: 2.5.1b1,2.5.2b2]
• 2.5.1b2
  • Fix for trial menu not disappearing when registering + related fixes
• 2.5.1b1
  • SQL parsing improvements.
  • Includes better parsing of unsupported objects like triggers and procedures.
  • Some keywords that should be valid for object names were being incorrectly rejected
  • Better handling of boolean expressions in views and procedures
  • Fixes for default value parsing
  • Identified bug in xml invalid character handling added fix.
• 2.5
  • This version includes new native driver support (for MySQL, Drizzle, Postgres and SQLite) and process separation for database operations. Also lots of minor improvements and various bug fixes. Note that JDBC drivers are still fully supported.
  • [includes: 2.5b3,2.5b2,2.5b1,2.3b3,2.3b2,2.3b1]
• 2.5b3
  • Helper tool now renamed "SQLWorker"
  • Moved command line operations to "SQLWorker" instead of main binary
  • Command line mode fixed for JDBC operations
• 2.5b2
  • Revised to use a separate process for JDBC driver discovery - so if this fails, database operations can continue
  • Java renabled by default
  • Automatic quoting of identifiers that are reserved words (SQL Dialects)
  • JDBC import objects now appear in a predictable ordering (broken with process separation before)
  • Changes to comment text handling to fix possible undo bug
  • Minor changes to remove some deprecated method usage
  • Change to popover handling (for 10.6 compatibility)
  • Fix: driver list can be updated after it is displayed if the discovery process is slow
  • Fix for driver list delete button being enabled for native drivers
  • Fix for deleting manually added drivers
  • Fixes for some possible array index errors
• 2.5b1
  • Renumbered to 2.5 (too many threes already)
  • Misc changes from 2.2.3 branch as follows:
  • Fix for key down in window causing exception if no characters are found
  • Added max_length support in django
  • Revised loading of dialect specific panels
  • Fix for parsing, DOUBLE sometimes required 'PRECISION' when it should be optional
  • Revised handling of preference changes in sidebar (fix for possible exception)
  • Fix for possible exception when closing JDBC window (connection count = 0)
  • Fixed bug where export of indexes and fields would sometime match table order instead of having fields first
  • Changes to way toolbar is handled (not a category any more)
  • Postgres exporter now automatically quotes any identifier starting with a number (0-9)
  • Parsing support for postgres specific (WITHOUT OIDS), (WITH OIDS = FALSE)
  • Better parsing of foreign key ON UPDATE and ON DELETE
  • Fix: Custom dialect panels were being loaded more than once
• 2.3b3
  • Special build with java disabled by default
• 2.3b2
  • Process separation for database operations - these now run in a helper task
  • Java now runs only in the helper task, so it can't affect the main app, hopefully resolving several odd problems
  • Fixed a bug where an empty window could sometimes be displayed when importing sqlite file failed
  • Java must now run headless (JDBC drivers cannot display windows or user interfaces)
• 2.3b1
  • Native Drivers for MySQL/Drizzle, Postgres, SQLite - no need to install anything
  • Revised zooming, now zooms centered on window visible area if possible
  • Rearranged java loading at start up for better loading performance
  • New badge in window title bar for unregistered and beta versions
  • Added preference option to disable loading Java VM completely
• 2.2.1b3
  • Fix for exception during file import
  • Fix for undo handling in SQL import (should be turned off entirely, but wasn't in some cases)
  • Fixed open panel behaviour when importing - panel should now disappear before import starts
  • Minor changes to import handling
  • Fix for inline renaming edit field not cancelling when arrange objects used
• 2.2.1b2
  • Fix for bug in sqlite foreign key importing, where foreign and primary columns were being reversed
• 2.2.1b1
  • Added new snapshot for diff: "As last database export", updated from your document each time you export to the database
  • Fix for bug where empty index that was commented out would still have preceeding comma in SQL export for table
  • Fixed bug in camel case conversion that caused crash when setting name to empty string in Django or Rails
  • Fixes for some identified memory managment issues
  • Rearranged application exception reporting code
  • Minor changes to the way that document controllers allocate
  • Fix for a bug in SQLFieldView with undo manager being invalid
• 2.2
  • Release Version of 2.2b4
  • Key changes include user interface fixes, performance improvements (particularly with bigger documents) and various bug fixes
  • [includes: 2.2b1,2.2b2,2.2b3,2.2b4]
• 2.2b4
  • Fix for panels not saving open/closed state
  • Fixed a bottleneck in the dialect specific panels code
• 2.2b3
  • Updated to newer version of Sparkle library
• 2.2b2
  • Fix for a crashing bug in field undo handling (@selector(undo:) etc)
  • Fix for undo when hiding objects sometimes not working
  • Fix for BLOB and TEXT types in mysql incorrectly exporting default values
  • Fix for parser not ignoring ALTER instructions for objects that we don't support (like FUNCTION in postgres)
  • Fix for parser to allow "ALTER COLUMN table SET DATA TYPE". The "SET DATA" bit wasn't supported before
  • Fix for table type not enabled when document opens
  • Fix for inspector when switching between documents - it now updates the selection properly
  • Fix for position of new objects being incorrect - objects should appear at last clicked location
  • Fix for forced unique option for foreign keys not working correctly
  • Changes to selection handling to speed up deselection in large documents
  • Changes to the way that the inspector handles empty selections
  • Fix for type and size on field inspector not updating each other correctly
  • Fix for bug in find sidebar panel, where fields weren't being selected or scrolled to visible
  • Revised find sidebar panel, now selects object on first click
• 2.2b1
  • Java runtime now bundled, system installed java not needed if using OS X 10.7.3 or later
  • Improved Undo - missing object properties and settings should now be undo-able
  • Switched sidebar standard sql export to run in a background thread
  • Asynchronous file saving on 10.7 and later
  • Fix for view parsing where conditions include a '<=' or '>='
  • Changes to primary key handling for better performance
  • Revised handling of dialect specific subpanes in the inspector
  • Rearranged exporters to support state during export as a performance improvement
  • Revised handling of model setting
  • Better primary key handling internally
  • Revised object quoting to improve performance
  • Some fixes for compound foreign keys
  • Revised find object system to reduce overhead when not in use
  • Various other stability and correctness improvements
  • revised object name stem handling for class naming (rails, django)
  • Fix for bug which prevented setting empty foreign key label on foreign key objects
  • Canvas area popup menu now has add object commands
  • Schema View popup cut command is now in correct place
• 2.1.3
  • release version of 2.1.3b3
  • [includes: 2.1.3b2,2.1.3b3]
• 2.1.3b3
  • Added new commands to table context menu for adding indexes, constraints and table level foreign key
  • Fix for schemaView canDelete crash
  • Fix for exception when setting labels using context menu
  • Fix for Table Type not enabling and disabling with Dialect change
  • Fix for performance issue with object inspection
  • Fix for color exception with comments
  • Fix to ensure indexes appear before foreign keys in SQLServer/Sybase dialect
  • Fix for odd bug where double clicking an object after changing a label color could change the label color to black
  • Fix for bug where choosing a label color affected other color settings unexpectedly
  • Fix for canvas area title not displaying when first added
  • Fix for comment name in labels panel not being trimmed
  • Fix for canvas area objects being described as comments in labels panel
• 2.1.3b2
  • Revised java handling, changed requirement to an installed JDK (not JRE) - either Oracle 7 or Apple 6
  • Fix for field inspector not updating
  • Fix for exception with label handling
• 2.1.3b1
  • Version without Java - for testing
• 2.1.2
  • Fix for SVG exporting of views (entries were missing)
  • [includes: 2.1.1,2.1,2.1b1,2.1.0b2,2.1.0b3,2.1.0b4,2.1.0b5,2.1.0b6,2.1b7,2.1b8]
• 2.1.1
  • Fix for another issue with inspector not matching object - causing an exception
• 2.1
  • Release version of 2.1b8
  • New features include SVG Export, Java 7 support (JDK or JRE), improved java runtime management, and constrained object dragging (with the shift key)
  • Bug fixes and other minor improvements
  • [includes: 2.1b1,2.1.0b2,2.1.0b3,2.1.0b4,2.1.0b5,2.1.0b6,2.1b7,2.1b8]
• 2.1b8
  • Fix for a build issue relating to comment views
• 2.1b7
  • Added constrain object drag with shift key
• 2.1.0b6
  • Fixed an undo bug when deleting and re-adding objects repeatedly
  • Fix for undo bug that messed up undo stack undo used after inspector panel change
  • Switched to GCUndoManager for undo
  • Fix for comment text coloring
  • Fix for comment auto sizing not working
• 2.1.0b5
  • Revised inspector handling to avoid inspecting non-inspectable objects
• 2.1.0b4
  • Fix for enumeration mutation bug in label setting
  • Fix for a bug with custom (non label) object colors and multiple selection
  • Fix for [SQLField getModel] exception
  • Fixed odd bug with Java install prompt
• 2.1.0b3
  • Fix for table frame drawing in SVG images
  • Fix for SVG image not being trimmed to objects (now uses a viewBox)
  • Fix for window scroll origin bug
• 2.1.0b2
  • Support for Java 1.7
  • Support for auto installing Java 6 (optional choice)
  • Fixes for some java related bugs
  • Fix for saving window scroll location
  • documents should now retain their sidebar settings
  • Minor improvements to image export UI code
• 2.1b1
  • New SVG Exporter
  • Fix for hidden objects being displayed when printed and exported in images
• 2.0.14
  • [includes: 2.0.14b2,2.0.14b1]
• 2.0.14b2
  • Fixes for bugs in rails exporter
  • Added preferences for Rails changes (new style columns and change vs up/down)
  • Removed diff mode logging message
  • [includes: 2.0.14b1]
• 2.0.14b1
  • Rails exporter now uses change instead of up/down methods (by default)
  • Fix for several odd bugs relating to dragging fields between tables and deleting fields
  • Fix for bug where table minimum size was larger than it should have been
  • Fix for SQL parser when the file contained an initial semi-colon on a comment or empty statement
  • Fix for postgres style type casting on postgres views and in SQL parsing (preliminary work)
  • Scroll to object from sidebar tree or find views now works properly when zoom factor < 100%
  • Fix for undo of resizing
  • Fix for resizing causing too much scrolling when scaled
  • Fix for Rails importer with Rails 3.2
• 2.0.13
  • Unused release number
• 2.0.12
  • Fix for jdbc connection strings not updating with presets
  • Fix for Database table filter incorrectly applied to exports
  • Fix for exception in setTarget for table inspector
  • Fix for exception in keyDown when multiple key presses represent a single character
  • Fix for saving custom connection strings
  • Fix for Django importing when Django 1.5 is installed
• 2.0.11
  • Fix for out of range exception when editing view query
• 2.0.10
  • Fix for bug in inspector targetProxy selection
  • Fix for exception in inspector with primary and unique key setting
  • Fix for selection bug where table was incorrectly selected instead of field
  • [includes: 2.0.9]
• 2.0.9
  • New objects now immediately set name to be editable if inspector is closed
  • Fix for bug with width of name column when field type alignment is on
  • Fix for onUpdate not being saved on table level foreign keys
  • [includes: 2.0.8,2.0.7]
• 2.0.8
  • Better detection of sqlite databases that don't use the .sqlite file extension. We now read about 16 bytes of the header to identify unknown files.
  • Fix for possible crash in sql parser
  • Fix for possible crash when primary key changed
  • Fix for foreign keys when linking to compound primary keys (It was possible to create a foreign key that had different numbers of fields on each side)
  • [NOTE] We are looking at removing compound foreign keys (where a single field uses other fields to pad out the foreign key) and using table level foreign keys instead.
  • Fix for undo after deleting the target of a foreign key, the link wouldn't be restored
  • Fix for issue in inline rename that caused odd bugs
  • Fix for database preset menu not changing when a preset is selected
  • Changes to the way JDBC connections happen internally in SQLEditor. This is for future use.
  • [includes: 2.0.7]
• 2.0.7
  • FIX: Clicking on the canvas when in tree view would reset the scroll location
  • SQLite foreign keys are now imported directly, rather than relying on the db driver
• 2.0.6
  • Fix for Document Options window not working when reopened after closing it
  • Fix for printing header and footer couldn't be reset to empty
  • Fix for comment title in label panel
  • Fix for label keyboard toggling
  • Fix for SQLContainer being empty when first element called
  • Fix for exception when key was released and it couldn't be identified
  • Fix for exception when editing views
  • Fix slight positioning bug on table name when using inline rename
  • Fix for exception when editing views
  • Fix for control handles bug when deleting a view
  • Some internal improvements for better structure
  • Versions 2.0.4 and 2.0.5 were replaced by 2.0.6 due bugs found before release
  • [includes: 2.0.3]
• 2.0.3
  • Fix for inline editing text field being offset when scale factor isn't 1.0
  • Fix for single line comments in SQL parser which used # (hash) as the comment character
  • Fix for some bugs that occured if inline renaming was happening when an object was deleted
  • Fix for duplicate column error not appearing in parse status when importing from SQL
  • Fix for crash when pasting index
  • fix for exception when changing label colors
  • Fix for bug where an object array was being mutated while enumerated (when loading connectors)
  • Fix for Fix for a bug where targetProxy was being changed and the bound controls didn't expect it to
  • Fix for notes on fields not being editable.
  • Changed the documentInfo panel to use a proper window controller (which it didn't before)
• 2.0.2
  • Fix for exception in labels panel when clicking in color column of table row
  • Fix for exception when setting the append SQL to empty
  • Fix for exception with getPrimaryKey in field inspector
  • Fix for diff bug with updateAction generating a change even when equal
  • Fixes for drawing color bugs including image export and with dark colored backgrounds
  • Fix for sidebar not updating menu status when it was dragged open or closed
  • Renabled command+scroll to zoom with trackpads
  • rewrote preferences toolbar code (no visible changes but much better, really ...)
  • Fixes for some logging messages
  • First build with xcode 4.5.1
• 2.0.1
  • Release version of 2.0.1b1
  • [includes: 2.0.1b1]
• 2.0.1b1
  • Fix for table bug which caused exception if the driver list was empty
  • Fix for bug when entering SQLEditor 1.x serial into 2.x (Should ask for upgrade instead)
  • Fix for exception when using colors other than rgb or gray
  • Fix for for crash when dragging connector handle and snap to grid is on
  • Fix for text in inspector being cut off
  • Added register by URL to save retyping serial codes
• 2.0
  • Release version of 2.0b26
  • First 2.0 Release
• 2.0b26
  • Fix for foreign key copyWithZone that missed key pairs and broke the diff system
  • Fix for Diff Mode being lost (changed from last saved to no diff unexpectedly)
  • Fix for bug when diffing foreign keys
  • Fix for possible crasher in diff mode
  • Fix for connector dragging when scale factor not 1.0
  • Fix for crash when adding driver using "Add Driver" menu item in import/export windows
  • Database connection window is now properly cleared before changing to a new preset
  • Added FeedbackReporter by Torsten Curdt to replace existing "send suggestion" and exception reporting code
  • Release candidate 4
• 2.0b25
  • Fix for expiry date still appearing in about box
• 2.0b24
  • Improved support for multi-touch trackpads
  • Removed slight bounce when zooming to 100%
  • Trackpad scrolling now doesn't affect zoom even if "Use Scroll Wheel Zoom" is on.
  • Other minor code refactoring + improvements
  • License code display removed from "About SQLEditor" panel
  • Updated Help files
  • Release candidate 3
• 2.0b23
  • Updated Filemaker import and export
  • Auto detection for filemaker jdbc driver
  • Minor internal fixes and improvements
  • Second release candidate for 2.0 release
• 2.0b22
  • Improved speed on multiple select
  • Fixed bug where shift clicking objects didn't update the inspector correctly
  • Release candidate for 2.0 release
• 2.0b21
  • Improved inline rename for objects
  • Fixes for bug where object locations could be corrupted
  • Upgrade button links to SSL version now
  • Find menu now shows find panel and selects the search box
  • Old find panel removed
  • Fix for bug where newly added objects weren't updating as edited
  • Signed for Gatekeeper on 10.8
• 2.0b20
  • Fix for zoom to fit if scale factor was 1.0 or greater
  • Option to turn off 10.7+ autosave/versions support
• 2.0b19
  • Multiple object inspector (select and edit multiple objects of the same type at once)
  • Improved view scaling (more accurate percentages)
  • Zoom area and zoom to fit now work better
  • Better handling of grid lines and page boundaries when scaled
  • Fixes for toolbar icon positioning + improved icons
  • Fix for icon not changing on label tool bar icon if window close box used
  • Appearance changes to field drag handle
  • [Experimental] Can now exclude tables from SQL and JDBC export (must enable option in export preference panel first)
• 2.0b18
  • Alignment tools (see Object Menu)
  • Revised context (right click) menus
  • Labels can now be applied to a selection
  • Option click on label visibility control (eye icon) to make only that label visible
  • New label menu command (Object Menu)
  • Added clipboard actions via context menu
  • Added color preference for connector lines
  • Changed default connector line color to gray(-ish)
  • Can now rename tables in label panel
  • Label panel delete alert message now contains label name
  • New prefs window toolbar icons
  • Fixes for redraw when snapping to grid
  • Fix for drag handle redraw being wrong
  • Fix for resetting data types in preferences window
  • Can now edit data types in preferences window as expected
• 2.0b17
  • New toolbar icons
  • Revised java thread handling
  • Performance improvements
  • z-order fixes
  • Label panel now displays label name when asking about deletion
• 2.0b16
  • Fix for label panel dragging (again)
  • Fix for label panel not showing newly added tables immediately
  • Fix for some beta versions not expiring properly
  • Fix for broken links in help menu
• 2.0b15
  • Fix for undo when pasting
  • Removed requirement for Java to be installed. (JDBC drivers won't work unless it is though)
  • Fix for palette field dragging
  • Fix to allow labels to have the same name as other labels
  • Changes to better support upgrades from 1.x
  • Help book is back
• 2.0b14
  • Added "Show all objects" menu item
  • Added toggle label menu item
  • Shortcuts for label window
  • Improvements to table rows in label window
  • Saves expaned/collapsed state in label panel
  • Default label hidden state now saved
  • Fix for bug with unique indexes when MySQL is being case sensitive on import
  • Fix for Oracle foreign key import
  • Oracle export SQL (on update removed, better on delete handling)
  • Fix for selection dragging when some objects are hidden
• 2.0b12
  • Label window improvements
  • Drag tables from one label to another to change label
  • Reorder tables within label
  • Hiding/Showing a label retains previous selection
  • Click on a label to select all labelled objects
  • List of tables/objects for each label
  • Merge label groups together by dragging one label onto another
  • Undo for label actions
  • Palettes now reappear after browsing versions
  • Fix for label visibility not being saved correctly
  • Fixes for SQLite bugs from 1.7.15
  • Fixed label bug which caused multiple labels to appear
  • Delete label option (which moves all tables to default) added
  • Fixes for label context menu
  • Views with empty select statements don't now gewnerate error
  • fix for fields giving label manager error
  • fix for SQLSchemaView not removing objects when it was deallocated
• 2.0b11
  • SQL View inspector now parses queries without loosing focus
  • Command line interface changed to simplify arguments (no need for -tool anymore)
  • JDBC Export for View export added for Oracle and improved for Postgres
  • Fixes for inline renaming of views
  • SQLite database export can now correctly add columns
  • SQL Parser added AUTOINCREMENT keyword for SQLite
  • SQL parser fix for zerofill and unique parsing which had been broken
  • Removed several log messages that appeared when editing views
• 2.0b10
  • Command Line now supports sql parsing and sql export (Command line interface subject to change)
  • Improvements to JDBC view import, update and export in MySQL, Postgres and SQLite
  • Changed view object section headers to be COLUMNS and TABLES, because we don't yet offer all join information
  • Not for use on 10.5 (a later build should add this back)
• 2.0b9
  • Object labels can now be created without being used on an object (for use in templates, etc)
  • Command line mode for import and export from file to database (first revision)
  • Added ability to remove a label from all labeled objects
  • Label change undo
  • Updated sql parser with changes from 1.7.14
  • View export support in most dialects
  • Updated view import support in MySQL, SQLite and Postgres
• 2.0b8
  • Revised label panel, now showing number of tables and allowing selection of all labeled objects
  • Improvements to view support - better parsing of views and now displays list of tables for view
  • improvements to SQL parser - fixes from 1.7.13b1
  • Fixes for object names with multiple qualififiers
  • disabled view support for non-mysql (will be returned in b9 after dialects completed)
• 2.0b7
  • New drawing code
  • Document loading should be faster with big documents
  • Object layering is now much better, canvas areas should now stick to the back, while connectors should be drawn between them and editable objects
  • Dragging a foreign key to another table now moves the connectors too
  • new objects are now added nearer to the last operation
  • Faster snapshotting on load
  • Optimizations in dragging code
  • Connectors now hidden if either parent is hidden when created
  • change to comment drawing (now using NSLayoutManager)
  • Object hiding now hides any connectors that relate to the hidden object
  • Change to color settings to improve drawing speed
  • Certain SQL parser (import) operations have been speeded up, and also use less memory
  • Fix for possible crash shortly after importing
  • Fix for possible source view update crash (it was occasionally being called from a secondary thread)
  • Fix for specific parsing issues with triggers and sequences (note: support of these features is not included)
  • Fixes in drag scrolling and resizing
• 2.0b6
  • Added option to append custom SQL when exporting to file (not yet JDBC)
  • Improvements to document options window (now live with undo rather than modal)
  • Improved undo with document options window
  • Fixed possible crash which occurred because some document observers were being removed after the objects had been released.
• 2.0b5
  • Improved SQLite preset connection handling
  • Objects can now be hidden and shown either individually or by layer
  • Improved exporter, importer and JDBC plugin discovery (ExporterList.plist now redundant)
  • Initial magnify gesture (experimental)
  • SQLite index export improved
  • SQLite now uses single and double quotes - better following language spec
  • Better diff for UNIQUE in mysql
  • Tree view now remembers expanded status
  • Zoom menu moved to toolbar
  • Added zoom to context menus
  • Unique in SQL Server not exports
  • Scrollbar redraw bug now fixed (FS#924 - as 1.7.11)
• 2.0b4
  • Added tree view of document in sidebar
  • Better find panel
  • Removed find window
• 2.0b3
  • SQL Import: now collapses single entry indexes into a field level index
  • SQL Import: better handling of double quote mark escaping
  • Improvements to registration system + changes for upgrade hand
  • Some internal simplification with object inspectors
  • SQLEditor now switched entirely to CocoaOniguruma
• 2.0b2
  • Fix for various autosave bugs
  • Fix for plugin diff support
  • Ruby on Rails migrations now support diff
  • Modified regular expressions to use CocoaOniguruma instead of ObjPCRE
• 2.0b1
  • Versions and autosave support
  • Lion compatibility improvements
  • Upgraded printing interface (now with preview)
  • Improved save as image (including better PDF sizing)
  • Added 'Unique' setting in field popup menu
  • Hide Objects by label support
  • Delete preset JDBC connection fixes
  • Numbering change to 2.x series from internal numbering 1.8
• 1.8.0b4
  • Fix for library link issue that caused startup failure on 10.5
  • Fix for bug where db connection strings not updating when preset changed [FS#890]
• 1.8.0b3
  • Added initial support for views
  • Fixes for exporting symbols to plugins
• 1.8.0b2
  • Drag canvas key is now the spacebar. Hold spacebar then drag
  • Control handles on objects now dim when window is not front window
  • More tolerance when dragging before connectors are changed (drag outside of field to change)
  • Non-anchored search (search for strings anywhere in the object name, not just the beginning)
  • Fixed Alter table engine behaviour from 1.7.6b1
• 1.8.0b1
  • 64 bit support
  • Supports Mac OS X 10.5 and later only
  • New document specfic sidebar panels
  • Added Diff between current document and last save / last import
  • Added Diff between document and another open document
  • Find moved to side bar with per-document searches
  • Revised split view in main window
  • Now using CocoaOniguruma for some regular expressions
  • Fixed bug in schema name spliting.
  • Branched from 1.7.5
• 1.7.5
  • Release version of 1.7.5b1
  • [includes: 1.7.5b1]
• 1.7.5b1
  • Rewritten help menu handling
  • Fixed bug where setString could be called with nil on modifying a field with unique property set
  • Fix for plugin menu handling not working
• 1.7.4
  • Release version of 1.7.4b4
  • [includes: 1.7.4b4,1.7.4b3,1.7.4b2]
• 1.7.4b4
  • Fixed to support sparkle beta appcast correctly
  • Modified update system to fix other minor bugs
• 1.7.4b3
  • Fix for table and canvas area name editing not updating with typing
  • JDBC password saving between operations improved
  • New preference to save last password in keychain (Preferences | database | JDBC Options)
  • Fix for connection string not updating when changing preset
• 1.7.4b2
  • Fix for object layering bug
  • Obsolete foreign key preference removed
  • Updated sparkle to newer release
  • Option to report statistics on system configuration when updating
  • Fix for paste not working without clicking on canvas first
  • Slight changes to appearance and z-order behavior of connector labels
• 1.7.3
  • Release version of 1.7.3b4
  • [includes: 1.7.3b4,1.7.3b3,1.7.3b2,1.7.3b1]
• 1.7.3b4
  • Fix for bug where pasting a field would put new field in wrong location (bug in 1.7.3b3)
  • Fix for bug where duplicating a field would put new field in wrong location (bug in 1.7.3b3)
  • Fix for some uid related issues
  • Fix for schema name reseting to empty when editing table name
• 1.7.3b3
  • Improved file saving, fewer unnecessary changes and improved scm compatibility
  • Objects in saved files should now be generated in a more predictable order
  • Fix for bug where copying field would put entire document's SQL on clipboard
  • Fix for bug in table schema name edit field when field focus lost
  • Removed obsolete xml export code
  • Fix for bug with cardinality editing which caused stray error messages in log
• 1.7.3b2
  • ON UPDATE now imported from JDBC
  • SQLite JDBC username bug fixed
  • Fixed "Don't quote default value" setting with postgres
• 1.7.3b1
  • Added ON UPDATE for foreign keys
  • Improved quoting in Postgres for data/time constants in default values
  • Fix for Ruby On Rails down methods using underscore to camel case incorrectly
  • Improved inspector code and removed obsolete parts
  • Switch to zip format for distribution
• 1.7.2
  • Release version of 1.7.2b2
  • [includes: 1.7.2b1,1.7.2b2]
• 1.7.2b2
  • Fix for bug where object locations weren't saving
• 1.7.2b1
  • Fix for plugin export failures
  • Fix for schema name being nil on export
  • Fix for possible crash with keychain code
  • Modified database export to simplify code in settings window
• 1.7.1
  • Release version of 1.7.1b1
  • [includes: 1.7.1b1]
• 1.7.1b1
  • New default cardinality for imported objects (separate from user created objects)
  • Improved default cardinality settings
  • Fix for ON_UPDATE handling in inspector
  • ON_UPDATE changes now correctly cause updates in SQL source view
  • Fix for Simulate option not working in some cases (Oracle, Filemaker)
  • Fix for possible JDBC failures with database that used "database" as a setting name
  • Commenting out SQL now only occurs in Non-JDBC mode
  • Fix for missing semi-colon in Constraint export
  • Oracle index updating fixed
  • Improved internal handling of JDBC connection settings
  • Removed obsolete code
• 1.7.0
  • Release version of 1.7.0b2
  • [includes: 1.7.0b1,1.7.0b2]
• 1.7.0b2
  • Added image export alpha (transparency) support
  • Better import of Oracle foreign keys which don't reference primary key
  • Rewritten inspector system
  • Fix for auto increment option incorrectly appearing in Oracle SQL
  • Fix for bug where source view stopped updating after failed database export
  • Improvements to plugin system
  • Fix for possible crash in SQL parser + other minor improvements
  • Object name quoting is now off by default
  • Minor parsing improvements
  • Ruby On Rails Plugin now uses system sandbox and should work better with rvm
  • Ruby On Rails plugin now requires 10.5 or later
• 1.7.0b1
  • Internal release only
• 1.6.9
  • Release version of 1.6.9b2
  • [includes: 1.6.9b1,1.6.9b2]
• 1.6.9b2
  • Fixes for multiple indexes being added
  • Fix for indexes being incorrectly added
  • Duplicate index adding fixed
  • Modified single entry index collapsing to work better with JDBC export
• 1.6.9b1
  • Fixes for incorrect index dropping during export
  • Fix to make index names unique with indexed option
  • Table, field and other object names are now quoted by default
• 1.6.8
  • Improved progress bars and status information during database operations
  • Improved database updating (fewer unnecessary DROP, CREATE cycles)
  • Parser improvements (Oracle constraint parsing, MySQL + postgres alter table)
  • Applescript improvements
  • Added custom url based registration system
  • Fix for duplicate indexes with table prefixes
  • Fix for dropping UNIQUE keys
  • Fix for index altering not working
  • Fixed bug which caused empty instructions to be executed during updates
  • Fix for multiple CREATE INDEX instructions being executed
  • Fix for MySQL types being changed on export when size was missing in document
  • Fixed mismatch highlighting with unsigned integers for foreign keys
  • Better handling of MySQL foreign keys when exporting to database
  • Fixes for importing single entry UNIQUE keys (Now imported to UNIQUE option on field)
  • Better handling of single entry indexes (optionally)
  • Minor user interface changes
  • Fix for canvas area naming and renaming not working
  • Find menu item now opens find window
  • Find object list now updates when switching documents
  • Improved inspector display when editing foreign key objects
  • Added label editing for foreign key objects
  • Removed some unneeded logging messages
• 1.6.7
  • Internal development version only
• 1.6.6
  • Removed a conversion between XML and string format when loading (efficiency)
  • Improved load/save
  • Fix for bug which caused import to fail with unrecognized selector on NSDocumentController
• 1.6.5
  • Fix for parser with mysql table options separated by comma
  • Fix for parser create index instructions with prefix
  • Exporting index prefixes now works with more data types in MySQL
• 1.6.4
  • Improved handling of duplicate foreign key indexes on sql export
  • Fixed checking for new beta versions in a release version
  • Fix for a bug where a deallocated selection was mistakenly being accessed when closing a document
  • [includes: 1.6.4b2]
• 1.6.4b2
  • Comments can have now have any title (older SQLEditor versions will rename on opening)
  • Improved object renaming when double clicked
  • Fix for index prefix sizes added on sqlite and others (now only added when supported by database)
  • Re-factored various bits of import and export code
  • Improved modification of existing database foreign keys
  • Improved memory management in JDBC and database operations
  • Better index naming with JDBC export
  • Better reporting of JDBC and database errors
  • Fixed some memory leaks
  • Improvements to the SQL parser for parsing stand-alone create index statements
  • Better handling of comments and commented sections when parsing SQL
  • New Preflight window (although only two actual preflight tests yet)
  • Fields can now draw warning icons for issues in preflight
  • Preflight actions can be added from a plugin
  • Filemaker JDBC driver now auto-detected
  • Experimental filemaker dialect (doesn't work for export yet)
  • Fixed a bug which caused a concurrent modification error when closing a document
• 1.6.3
  • Fix for some Help Menu items not working
  • Release version of 1.6.3b1
• 1.6.3b1
  • Fix for Preferences window on 10.4
  • Fix for SQLite default value constants (CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP)
• 1.6.2
  • Type lists can now be provided from a plugin
  • Plugin system now loads only newest plugin for each identifier (based on CFBundleVersion)
  • JDBC now supports importing types in lowercase
  • Oracle JDBC importer now ignores objects in recycle bin (starting BIN$)
  • Rails importer now parses schema.rb files
  • Rails exporter can now create schema.rb files
  • Fix for SQLite data type sizes when importing via JDBC (now ignores sizes on types when importing)
  • Now correctly quotes default values for DATETIME and TIME in MySQL
  • Fix for MySQL export when ON DELETE was set to SET NULL (unsupported in mysql dialect)
  • MySQL Exporter now adds a size to VARCHAR types if none is specified (as is required)
  • SQLEditor now supports lower case for field types
  • "Automatically add new types as used" has been removed (add using preferences window instead)
  • Improvements to "Add type" system in preferences window
• 1.6.1
  • Better handling of errors during image export
  • Modified image export to better handle large images
  • Improved SQL server database import and export
  • JDBC Import bug fixes for statistic indexes (mainly for SQL Server)
  • bug fix for columns occasionally appearing in wrong tables on import from jdbc
  • Support for indexes in rails migrations
  • Improved object and file naming in migrations
  • Snap to grid now snaps to bottom right as well as top left (with preference setting)
  • Fixed reordering of tables with foreign keys in exported SQL
  • Modified Export preferences to separate Rails migrations into new pane
  • SQLite primary key handling modified (better handling of multiple int primary key columns)
  • SQLite foreign key handling improved (fixed some bugs in the sql export)
  • Fix for sqlite database files having file extension included twice
  • Better handling of file errors when opening and importing files
• 1.6
  • Release Version
  • New online help
  • Changed position of inspector on first launch
• 1.6b17
  • Fix for table level COLLATE and CHARACTER SET being swapped when parsing from SQL
  • Fix for Table and field sql comment (notes) editing changes altering all comments
  • Fix for bug when renaming table or field to the empty string (now returns to previous name)
  • Fix for comment naming
  • Improved document meta data handling (SQLDocumentInfo)
• 1.6b16
  • SQL parser improvements including better handling of TIMESTAMP, COLLATE and CHARACTER SET
  • Improved error reporting of SQL parse errors
  • Fix status window display when pasting SQL into SQLEditor
  • Fixed SQLConstraint exporting
  • Better auto complete in field type box
  • Show Inspector Menu Item not changing when closing window
  • Better memory handling with database drivers
  • Fix for a memory handling bug in document loading
  • New palette images
  • Updated code signing certificate
  • Added user interface for ON UPDATE (for timestamps in mysql)
  • Fixed bug with empty quoted default values
• 1.6b14
  • Fix for foreign key objects not updating if fields that they reference are deleted
  • Fix to allow setting entries in foreign key object back to unset.
  • Fix for bug that caused indexes and foreign keys to get duplicated unexpectedly when dragging
  • JDBC drivers can now be loaded from the SQLEditor specific directory again
  • Fixed custom (non label) object colors
  • field inspector now defaults to its options panel when first starting SQLEditor
  • MySQL table collation and character set exporting now exporting correctly
  • Fix for bug with non-object compound foreign key deleting
  • Improved smoothness when dragging foreign key connections
  • JDBC export should now correctly drop foreign keys that have been deleted in the document
• 1.6b11
  • Connectors can now be repositioned in orthogonal mode (which was broken in 1.6b7)
  • SQLite exporting integer primary keys now behaves better
  • JDBC import now imports NOT NULL status on columns better
  • Save as image files now exports correctly in the chosen format
  • Fix for log messages on 10.6 about requested Java version
  • Fix for bug which could cause a crash when closing documents immediately after opening
  • Reordered some JDBC export instructions to make certain changes to tables after adding columns (rather than before)
  • Fix for bug with boolean settings which are not properties when loading documents (which could affect primary keys and some other settings)
  • More reliable index deleting during JDBC export to MySQL.
  • Modified XML generation for better reliability and improved readability. You may notice this change if you do a diff on SQLEditor documents.
  • Index prefixes now work again
  • Fix for possible crash with document options panel
  • Fix for a bug in copy/paste code
• 1.6b9
  • Fix for crash in preferences window
  • Added connection timeouts on some JDBC drivers
  • Modified layout of database preferences panel
  • Fixed a bug causing an error message to be logged about multiple copies of ObjePCRE
  • Better handling of SQLEditor documents that incorrectly contain objects with the same name
• 1.6b8
  • Fix for foreign key import with schema not connecting foreign key links
  • Reordered post load instructions in JDBC export
  • Fix for JDBC import not setting dialect correctly
• 1.6b7
  • Fixed a crash that could occur when switching dialects
  • Fix for a bug that could corrupt files with old style compound foreign keys
  • Improved broken file recovery.
• 1.6b10
  • Not released
• 1.6b6
  • Fix for strange object dragging behaviour with overlapping objects
  • improvements to JDBC import and export
  • fixes for index handling
  • fix for foreign key naming when several foreign keys link to one target
  • reduced number of log messages when exporting
  • removed dependency on IOKit for identifying Mac model name
  • IF NOT EXISTS now available on indexes in SQLite (for file export)
  • IF NOT EXISTS now not used in JDBC code
  • Fix for XML bug that could cause problems saving files if they were damaged
  • fixes for label color handling when label data elements were damaged or missing
  • fix for an issue that prevented boolean properties being used by JDBC drivers
  • fix for user interface visual glitches on load
  • some internal fixes and improvements
• 1.6b5
  • Improved visual feedback when dragging foreign keys (The cursor changes)
  • Fix for SQLite IF NOT EXISTS
  • Fix for a bug that caused SQLite to be listed more than once in various menus
  • Better handling of exporters that handle more than one driver
  • Fix for a bug involving Postgres (and possibly other) foreign key operations failing due to a an incorrect comparison
  • Fix for hang when dragging from a field to a foreign key object
  • Fix for some unexpected exceptions
  • Improved XML processing on 10.6
  • Table and column comments in MySQL are now trimmed to the maximum supported length when exporting.
• 1.6b4
  • First public 1.6 beta release
  • Minimum System requirement now 10.4
  • Improved toolbar icons
  • Support for 10.6 (Snow Leopard)
  • New ANTLR based SQL parser
  • Improved model code (now entirely Objective C)
  • Rewritten Java interface (now using JNI)
  • Improved Inspector handling
  • User Interface improvements
  • Labels are now per-document instead of global as in 1.4.x
  • There is a new labels window to allow renaming labels and changing label colors
  • Rewritten preferences window system
  • Document auto-save
• 1.5
  • Test and development releases towards 1.6
• 1.4.7
  • All improvements from 1.4.6b1 to 1.4.6b7
  • [includes: 1.4.6b1,1.4.6b2,1.4.6b3,1.4.6b5,1.4.6b6,1.4.6b7]
• 1.4.6b7
  • Corrected SQLite types list
  • Forward delete key should now work to delete objects
  • Improved handling of indexed property on fields when re-exporting
  • Fixes for two internal bugs in the object name handling system
  • Better (but probably slower) handling of objects with dark background colors. (Option at Preferences->Appearance->Colors)
• 1.4.6b6
  • Now identifies columns that differ in "unsigned" setting when looking for mismatches in foreign keys
• 1.4.6b5
  • Improved canvas dragging
  • Improved behavior of object selection and dragging
  • Fix for option+drag copying of objects when the object isn't selected
  • Index inspector name warning now works properly
  • Fixed a button icon that wasn't appearing correctly on systems earlier than 10.5
• 1.4.6b3
  • New tables are correctly named when there is another table which has a name that differs only in case
  • Tables cannot now have names that are different only in case. (Which wasn't correctly enforced before)
• 1.4.6b2
  • Group dragging fixed
  • Improved copy and paste. Objects now act more intelligently when connecting to existing objects
  • Bug fix for possible crash when deleting tables containing connectors
  • Change to default names for indexes
  • Table names are now (optionally) prefixed onto index names when created (although they can be renamed)
  • Changed behavior of index exporting. Table names are not now automatically added to index names on export
• 1.4.6b1
  • New Icons
  • New Toolbar graphics
• 1.4.5
  • Release version of 1.4.5b1
  • [includes: 1.4.5b1]
• 1.4.5b1
  • Fix for bug selecting connectors
  • Fix for double clicking table action bug (resize/rename)
  • Fix for bug which caused connectors to be incorrectly released when canceling a create connector action more than once.
• 1.4.4
  • All improvements from 1.4.4b1 to 1.4.4b2
  • [includes: 1.4.4b1,1.4.4b2]
• 1.4.4b2
  • Fix for error message when importing from Oracle
  • Fix for bug that moved connector handles when an object was pasted into a document
• 1.4.4b1
  • New foreign key object with support for multi-column foreign keys
  • New options to modify behavior when importing foreign keys (via JDBC)
  • Scroll+Cmd key now zooms when in normal (zoom-scroll=off) mode
  • Fix for "on delete" actions not being saved
  • Added jTDS driver support (needs more work still though)
  • Improved SQLite foreign key handling
  • New dialect menu for source view
  • Option to include "IF EXISTS" when exporting to SQL
  • Rewritten object movement code to fix possible location bug
  • PLUS: New and improved Icons (including larger 512x512 sizes)
• 1.4.3
  • All improvements from 1.4.3b1 to 1.4.3b3
  • [includes: 1.4.3b1,1.4.3b2,1.4.3b3]
• 1.4.3b3
  • Fix for incorrect commas between fields and indexes
  • Added simulate export to database mode
  • Added option to disable dropping fields and indexes
  • Status window now shows failed exports in list
  • Fixes for index modification and adding on database export
  • Better handling of foreign key modification
  • Some fixes for instruction ordering when using database export
  • Fix for possible crash when removing an index that has just been added
• 1.4.3b2
  • Improved code to detect pre-existing indexes on JDBC export
  • Fix for better handling of altering primary keys in MySQL
  • Modified generated SQL in JDBC Export to better handle indexes on MySQL foreign keys
  • Fixed to remove comma from index if empty and commented out
  • Modified Comment object to resize text area correctly
  • Better handling of exporting indexes where table names are appended automatically
  • modified parser to remove quoting characters when importing
  • Correction for fix to Drop Table without schema
• 1.4.3b1
  • JDBC importer can now correctly import comments on tables and columns
  • JDBC exporter can now modify comments on existing tables and columns
  • Fix for cursor jumping in table comments
  • Fix for error displaying document info window
  • Minor fixes for some parser bugs (CREATE DATABASE/DROP TABLE with schemas)
  • Fix for a bug where the inspector didn't appear when dragging to select a single table
  • Fix for table inspector not appearing when clicking the parent table button
• 1.4.2
  • All improvements from 1.4.2b1 to 1.4.2b3
  • [includes: 1.4.2b1,1.4.2b2,1.4.2b3]
• 1.4.2b3
  • Fix for comments on fields in MySQL exporter having extra '=' (equals) sign
• 1.4.2b2
  • Modified MySQL exporter to use ENGINE instead of TYPE for better compatibility
  • Comments now attached to fields when exporting MySQL (i.e COMMENT 'xyz' style)
  • Connector inspector is now displayed automatically when a new connector is created
  • More padding added to line click detection to make it easier to click on connectors
  • Now correctly parses comments attached to mysql fields
  • Fix when using Postgres and reexporting objects without specified schema names
  • Database window now doesn't save passwords that aren't part of a preset
  • Improvements for quoting with Sybase and MS SQL-Server
  • Fix for an undo bug that prevented tables with some arrangements of connectors being un-deleted
• 1.4.2b1
  • Added support for editing MySQL character set and collation settings on fields and tables
  • Modified inspector on fields to use popup menu for selecting tabs
  • Fixed bug that prevented saving files after creating new foreign keys when referencing primary keys in tables with indexes
• 1.4.1
  • All improvements from 1.4.1b1 to 1.4.1b4
  • [includes: 1.4.1b1,1.4.1b2,1.4.1b3,1.4.1b4]
• 1.4.1b4
  • Fixes for SQL parser errors when importing some kinds of keys and indexes
  • Fixes for better parsing of several MySQL specific SQL fragments
• 1.4.1b3
  • Fix for image export types being wrong
  • Modified foreign key handling with compound keys
  • Some internal improvements for better performance
  • Fixed undo menu text (was showing wrong object types)
  • Fix for undo movement of connector control handles
  • Fix for bug which caused deletion of compound foreign keys to fail when dragging from on the secondary fields
• 1.4.1b2
  • SQL Parser: Multiple instructions in single table alter
  • Better ignoring of insert and update instructions affecting database data
  • Fix for (null) appearing as index prefix size with mysql
  • Modified MySQL export to better handle types that require index prefix sizes
  • SQL Parser: Better handling of CONSTRAINT primary and foreign keys in tables
  • Better error reporting for some kinds of error (instead of "no reason given")
  • SQL Parser now ignores temporary tables (with message)
• 1.4.1b1
  • Fix SQL parsing bug: multiple parts in alter table instruction
  • Fix for SQL parsing bug: error with foreign key in table body
  • Better handling of SQLEditor specific JDBC driver directory
  • "Open Driver Directory" button in preferences now opens SQLEditor specific directory
• 1.4
  • Release version
• 1.4b26
  • Fixes for auto increment with SQLite
  • Final Candidate Version for 1.4
• 1.4b25
  • Fix for an odd bug that would sometimes cause SQLEditor to quit on startup
  • Fix for a bug that caused JDBC Imports to fail with foreign keys that didn't have names
  • Minor code improvements
• 1.4b22
  • Fix for Java Update for Mac OS X 10.5 release 1 bug.
• 1.4b21
  • Improved handling of database connection settings
  • Fixes for SQL output correctness issues
  • Note text field cursor jumping problem fixed
  • Fix for connector control handle not dragging correctly
  • Modified export naming of created indexes when specifying a schema
• 1.4b20
  • Fix for escaping of quotes for table comments in MySQL
  • Fix for WITH TIME ZONE in Postgres for TIME and TIMESTAMP
  • Modified postgres types list to consolidate the TIME and TIMESTAMP options together
    • (This shouldn't affect existing tables)
  • Fix for BINARY type import from file
  • Fix for a possible bug in index handling
  • Fix for a bug in Clipboard Cut operations
  • Modifications to improve compatibility with Microsoft SQL Server Import
  • Added new index prefix size option for certain types (MySQL)
  • Fixed an odd bug that affected files that were re-opened having incorrect uids under some conditions
  • Increased starting size of Comment object
  • Context (popup) menu on Comment Views now works better
  • Added first version of MS SQLServer Support
  • Improvements to database export for Oracle, Postgres and MySQL
  • Better updating of existing databases when exporting to database
  • Improved JDBC preset handling
  • Importing a document now sets the document dialect to match the original database
  • Better handling of the Keychain
  • SQLEditor is now correctly security signed as an application
  • Minor SQL parser improvements
• 1.4b19
  • Fix for a crashing bug in inspector
  • Several improvements for dragging, scrolling and resizing of objects
  • Fix for enum and set values being forced to uppercase
  • Fix for bug in Find Object
  • Fix for a bug that prevented export if a table had the same name as a canvas object
  • Added back the button to convert comments -> Canvas Areas (and reverse too)
  • Fix for a bug where comments weren't loading colors correctly
  • A few internal optimizations
  • Parser now imports mysql KEYs (as Indexes currently)
  • Fix for repeated JDBC Export of tables with foreign keys to MySQL which was failing
  • Ruby on Rails table names are now forced to start with a capital letter for better compatibility
  • Fix for a log window resizing bug
• 1.4b18
  • Fix for source sidebar
  • SQLEditor now allows JDBC drivers to be stored in "/Library/Application Support/SQLEditor/JDBC Drivers" (as an alternative location)
  • New warning icon for possibly unsuitable default values
  • Fix for Ruby on Rails Plugin issues
  • Fixes and improvements for SQL Parsing (decimals in unquoted default values, fulltext with optional index and table level unique keys)
  • More "ON DELETE" action types for connectors
  • Modified MySQL unique keys when importing from database
  • New constraint object (initially for unique keys)
  • Fixes for indices when exporting (better SQL)
  • Fixes for some database export bugs (indices again)
  • Modified field appearance to better distinguish name from type
  • Fix for Add Driver menu item not working in Import & Export from database windows
  • Fix for an import bug where types would appear in lowercase then switch to uppercase
  • Fix for a problem that caused the source sidebar to be empty
• 1.4b17
  • internal release only
• 1.4b16
  • Fix for autocomplete bug in field types
  • Auto adding field types as they are entered is now optional (see Preferences->Data Types)
  • Fix for occasional bug in displaying status messages when running on PowerPC
• 1.4b15
  • Fix for oracle connection type string missing
  • Changes to prevent adding an empty custom database driver
  • Data type lists for Oracle, Postgres, Rails, Sybase and OpenBase now included. (Reset Dialects to use)
  • Fix for a bug where type sizes imported from a MySQL database could be wrong for some types
  • Fix for a bug where MySQL table types weren't being imported correctly.
  • New hand drag scroll tool (via optional document toolbar palette item)
  • New modifier when scroll wheel zoom: hold down command to switch to normal scrolling mode
• 1.4b14
  • Added default setting preference for automatic table sizing.
  • Better export image cropping
  • Modified image export to add a small border around the image
  • Modified Canvas Areas to randomly select initial color
  • Canvas Area objects can now be added from the popup menu.
  • Changed zoom shortcut to display Command (PLUS) instead of Command (EQUALS),
    this makes no change in functionality since both work equally
  • Better Rails Class naming
  • New Rename underscores for table names option for rails export
  • FIX: First field added to a document sometimes had incorrect type.
  • FIX: for comment inspector selection bug
• 1.4b12
  • FIX: startup failure on 10.4
• 1.4b11
  • Added per document option to hide field types
• 1.4b10
  • FIX: for a bug that caused objects to resize when dragged if the document was scaled
  • FIX: for a crash bug related to the table inspector
  • FIX: for a selection bug when copying objects with option drag
  • FIX: for incorrect visibility of export plugin menu
• 1.4b9
  • Better support for new Ruby On Rails 2.0 migrations
  • New Canvas object to replace old style canvas area comments
  • Minor SQL parser changes
  • Fixed the button style in the SQLite import panel
  • Fixed a packaging error where the disk image was unmountable on Mac OS X 10.3.9
• 1.4b8
  • Ruby On Rails Import from migration added
  • Better Ruby On Rails type conversion
  • New option to align field type labels in a vertical column per table for better readability
  • New "New with Dialect" to allow choosing the document dialect when creating a document
  • Improved preferences window, visual and organizational improvements
  • FIX: Inline rename wasn't updating correctly
  • FIX: Parse status window time was wrong
  • FIX: Source view updates weren't happening
  • FIX: Correct printing system is chosen automatically
  • FIX: SQLite auto-increment
  • CHANGE: "Export to SQL" is now "Export to File"
  • Other minor changes
  • (Also the first public build built with 10.5 and XCode 3.0. Please report any problems)
• 1.4b7
  • Improved visual appearance - rounded corner tables, with colored table headers (optional)
  • Labels and colors on fields as well as tables
  • Can now duplicate fields as well as tables
  • FIX: Inspector now updates if you make changes using a popup menu
  • FIX: Ruby on Rails auto increment output incorrect
  • FIX: Fields could not be dragged between tables
  • FIX: Modified type matching to ignore sizes when matching postgres SERIAL types
  • FIX: Minor improvements and fixes for printing (page numbers particularly)
  • FIX: Fix for some inspector issues that appeared in 1.4b6
• 1.4b6
  • Changed toolbar icons to look better with Mac OS X 10.5 Leopard
  • FIX: for Ruby On Rails join tables
  • FIX: for side bar visibility
  • Passwords for connections are now stored in the keychain
• 1.4b5
  • Fix for JDBC Driver list sometimes being empty
  • Fix for a bug relating to updating the source sidebar when closing a window.
• 1.4b4
  • Modified Inspect Object to display the inspector if it is not already visible
  • Fix for a bug that sometimes caused the application to crash if a source update occurred after the window had closed.
• 1.4b3
  • Fix for undo on index fields
  • Minor fix to registration window user interface
• 1.4b2
  • Fix for a bug that caused connectors to be incorrectly deleted
  • Fix for undo/redo bug
  • Improved update checking (now using Sparkle)
  • New beta warning message (shown once only per version release)
  • Fix for live source view sometimes being blank
  • Fix for live source view not changing when document export dialect changed
  • Fix for a bug that sometimes caused undo to stop working.
• 1.4b1
  • New live source view sidebar
  • Improved search (now searches for fields as well)
  • Image export file type now selectable
  • Some SQL export fixes
  • Fix for a bug that was sometimes preventing fields being added under odd conditions
  • Fix for drop order with referenced tables
  • Fix for a file corruption error
  • Improved status window (it now indents!)
  • Fixes for minor bugs in registration window
  • New Show Inspector toolbar item
  • Better database driver listing delete handling in preferences window
  • Added option to De-Register Software (if selling a machine for instance)
  • Improved undo/redo when repeatedly undoing and redoing (particularly delete)
  • Fixed save/revert menus not becoming inactive
  • Other minor fixes
• 1.3.9
  • Fix for a crash that sometimes happened when importing or exporting
  • Performance fix for selecting objects in large documents
  • Parse status window: Large messages are now displayed completely and not cropped
  • Better handling of java 1.5 drivers when running using java 1.4
• 1.3.8
  • Fix for a save bug that caused tables not to get saved correctly under certain conditions
• 1.3.7
  • Tables and indexes can now correctly have the same name
  • Improved Openbase support
  • Parsing of collate settings on tables is better (allows equal character between option name and option value)
  • Some internal re-optimizations
  • Small bug fixes
• 1.3.6
  • Fix for mysql auto increment not being read correctly when using jdbc database import
  • further fixes for database connection issues.
• 1.3.5
  • Fix for a bug that prevented Database connection windows from opening if there were no preset connections.
• 1.3.4
  • Loading foreign key links now works more reliably (SQLEditor was getting confused if uid values weren't correct)
  • Types are now sorted within each dialect
  • Parser is now better able to understand check constraints (although editing and exporting aren't available yet)
  • Database import window now appears even if there are no drivers present (previously didn't appear)
  • Hand icon appears when cursor is over field drag area
  • Bug fix for an odd crash when drawing
  • First ssl support (for postgres only at the moment) in import and export
  • Improvements to Postgres JDBC support with JDBC drivers >= 8.0
• 1.3.3
  • Internal release only
• 1.3.2
  • Added new per dialect column type system and a new option to select a default type (see preferences - data types)
  • Choosing no-preset in database connect now clears the import/export window
  • Default type list for mysql now includes most (possibly all) mysql data types - please advise if there missing items
  • Fix for a bug that caused altering tables in a mysql to reset some attributes on columns
  • Parser recognizes (but doesn't actually do anything with) collate and character set options
• 1.3.1
  • Fix for a bug which meant that UIDs for objects weren't recreated when an object was copied,
    causing connectors not to be saved correctly under certain conditions.
  • Images are now saved using filename.type, rather than filename-image.type
  • Show/Hide inspector menu item shortcut wasn't working - fixed
• 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 - auto increment 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 interruptible
  • 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 behavior 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 orthogonal 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/highlight 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 behavior 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 arrangement 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 optimizations
• 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 behavior
  • 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 arrangement
  • 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 initially supplied are:
    • Dialects:
      • 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 accommodate 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 aggressive 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