• Revised java handling, changed requirement to an installed JDK (not JRE) - either Oracle 7 or Apple 6
• 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
• Fix for field inspector not updating
• Fix for exception with label handling

New features:

• SVG Export
• Java 7 support (JDK or JRE),
• improved java runtime management
• Constrained object dragging (with the shift key)

Bug fixes and stability improvements:

• Fix for SVG exporting of views (entries were missing)
• Fix for issue with inspector not matching object - causing an exception
• 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
• Revised inspector handling to avoid inspecting non-inspectable objects
• 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
• 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
• 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
• Fix for hidden objects being displayed when printed and exported in images

• Fixes for bugs in rails exporter
• Added preferences for Rails changes (new style columns and change vs up/down)
• Removed diff mode logging message
• 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

• 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

(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

• 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.
• 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

• 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
• 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)

• This is a paid upgrade from SQLEditor 1.x
• Requires Mac OS X 10.6.8 or later and an Intel Mac (32bit or 64bit)
• This upgrade is free if you bought SQLEditor on or after August 1st 2010

• First 2.0 Release, based on 2.0b26 release
• New diff export
• Support for sql views
• New find sidebar
• New Labels panel with grouping and hiding
• Uses Lion style autosaving and versioning
• 64 bit supported
• New object drawing system
• Performance improvements in various areas
• Lots of bug fixes and improvements
• Signed for gatekeeper

SQLEditor - 1.7.18

• Release of 1.7.18b1
• From Version 1.7.18b1
• • First gatekeeper signed version (for mountain lion)
  • Fix for bug where object locations could be corrupted
  • New minimum System 10.5.8 (due to gatekeeper signing)

• MySQL unique could be ignored by importer if table name contained mixed upper and lower case
• Fix for Oracle foreign key importing
• Fix for oracle export, on update is now not exported if set on foreign key since most oracle SQL doesn't support this
• Fix for bug with indexes on export which could cause a duplicate index exception due to incorrect matching
• Fix for undo when pasting
• Rewrite of layering system (from v2.0) to fix a performance issue when pasting.

• SQLite autoincrement keyword parsing
• SQLite add column fix

• Fix for 10.4 compatibility
• Fix for parsing single alter table with multiple foreign key instructions
• Parser now supports both TIMEZONE and TIME ZONE for relevant time types
• Parser add support for some missing data types (including CURSOR)
• Parser better handling of keywords that are also identifiers
• Parser better handling of intervals for postgres and oracle
• fix for YEAR keyword with and without PRECISION
• fix for DOUBLE keyword and PRECISION keyword
• fix for some other keywords that weren't reliably recognized.

• Fix for cardinality on table level foreign keys not saving
• SQLite export now uses double quotes for identifiers and single quotes for quoted values

• Fix for graphical glitch on Lion when scrollbars are hidden

• SQL Import: now collapses single entry indexes into a field level index
• SQL Import: better handling of double quote mark escaping
• Fix for type field parsing so that it correctly splits enums where the enum string contains a closing bracket

• Image Export improvements
• Exported PDF images now smaller to better match the size of exported bitmaps
• Exported images and printed documents no longer display selected objects
• Preference to optionally display selected objects in prints and exported images
• Fix for saved images sometimes being blank

This version offers improved Lion compatibility and several bug fixes

• SQLEditor now registers itself only for the current user when running on Lion/10.7
• Fix for preference bug (keys and values switched in 1.7.7b1)
• Fix for bug where the first connection preset couldn’t be deleted
• Fix for error with how update menu item was being created
• Fix for for database panel presets not saving port numbers
• Fix for database panel connection delete preset option being enabled when it shouldn’t be
• Updated nib files to remove redundant objects

• Find objects now searches for the string anywhere in the object name (not just at the beginning)
• Fix for bug where JDBC table filters were being used when exporting (FS#894)
• Fix for MySQL timestamp where default value is NULL also needing NULL on column (FS#891)
• Fix for Postgres BIGINT should match BIGSERIAL when type matching foreign keys (FS#889)
• SQLite foreign keys now export ON DELETE and ON UPDATE actions correctly (FS#892)
• Fix for bug where db connection strings not updating when preset changed [FS#890]
• Fix for alter table engine export bug
• Fix for crash when typing accented characters or symbols into table name field
• Ruby on Rails now generates “references” statement in migration export
• Ruby on Rails importer now imports some types of references statements

• 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

• Release version of 1.7.4b4
• From Version 1.7.4b4
• • Fixed to support sparkle beta appcast correctly
  • Modified update system to fix other minor bugs
• From Version 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
• From Version 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

Improvements

• Added ON UPDATE for foreign keys
• Improved file saving, fewer unnecessary changes and improved scm compatiblity
• Objects in saved files should now be generated in a more predictable order
• Improved quoting in Postgres for data/time constants in default values
• Improved inspector code and removed obsolete parts
• Switch to zip format for distribution

Bug fixes

• 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
• Fix for bug with cardinality editing which caused stray error messages in log
• Fix for some uid related issues
• Fix for schema name reseting to empty when editing table name
• Fix for SQLite JDBC username bug
• Fix for bug in “Don’t quote default value” setting with postgres
• Fix for Ruby On Rails down methods using underscore to camel case incorrectly

• Transparent Image Export support
• Ruby On Rails improvements (including better rvm support)
• Default cardinality setting added
• Improvements for Oracle foreign key handling
• JDBC bug fixes
• Fixed errors in SQL code quality
• Other minor bug fixes and improvements

SQL parsing improvements
Improved SQL export accuracy
Fixes and improvements to database import and export
More accurate progress display during import and export
User interface improvements
Bug fixes and other minor improvements

1.4.1
* All improvements from 1.4.1b1 to 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
* Modifed 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 draging 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 consolate the TIME and TIMESTAMP options together
o (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 idents!)
* 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

• 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

Fix for a save bug that caused tables not to get saved correctly under certain conditions

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