Licence: Commercial with demo
Version 3.1.4 | Release Date: 2016-09-27 | Download

SQLEditor requires MacOS 10.9 or later

SQLEditor - 3.1.4

Changes in this version

  • 3.1.4
    • Now distributed in a dmg (again) due to changes in gatekeeper on 10.12

Earlier Changes

  • 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
Version 3.0.2 | Release Date: 2016-07-07 | Download
  • SQLEditor v3 requires OS X 10.9 or later
  • Fix field foreign key diff where only the constraint name differed
  • 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
  • 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)
  • Add redshift diff export (early support still)
Version 3.0.1 | Release Date: 2016-05-26 | Download

SQLEditor 3

Note SQLEditor 3 is a paid upgrade from earlier versions. Free Upgrades for licenses purchased on or after 1st March 2014.

What's new?

  • Streamlined single window interface which is faster and easier to use
  • New Design Report Generator to instantly generate a comprehensive listing of tables and views, with columns, indexes, foreign keys and constraints listed.
  • Javascript Plugin System allows you to write new export dialects in Javascript
  • Performance improvements for bigger documents and better performance
  • Improved preflight system to find errors more easily
  • New visual style options
  • Plus various other new features and improvements
Version 2.9.16 | Release Date: 2016-02-29 | Download
  • Fix grid drawing code when scaled to a non-standard factor (like 0.65)
  • Fix for grid drawing at very large grid sizes because the cache tile wasn't updating
Version 2.9.15 | Release Date: 2016-02-26 | Download
  • Update sparkle to 1.1.14 release
  • Rewritten grid drawing code to reduce memory usage (Bug report by TS)
  • Fix bug that caused exception if grid size was set to 0
Version 2.9.14 | Release Date: 2016-01-28 | Download
  • Fix for crashing bug when editing view query string
Version 2.9.12 | Release Date: 2015-12-04 | Download
  • Fix bug where dragged fields could be vertically flipped
  • Filemaker exporter now only exports sizes for VARCHAR and CHARACTER VARYING types
  • Added DATE type for SQL Server
Version 2.9.11 | Release Date: 2015-10-23 | Download
  • Minimum system requirement is now 10.7
  • Fix for crashing bug on 10.11 due to a duplicate KVO observation if a document was imported then a preference was changed
  • Remaining openssl usage removed
  • Fixed Filemaker primary key bug
  • Fixed Filemaker numeric type bug
  • Fixed Filemaker create and drop index bug
  • (Version 2.9.10 was skipped to avoid confusion)
Version 2.9.8 | Release Date: 2015-07-10 | Download
  • Fixes a crash in window creation
  • Improves grid drawing performance (a bit) which should make zooming slightly smoother
Version 2.9.7 | Release Date: 2015-02-27 | Download
  • Adds support for BINARY keyword (including new inspector checkbox)
  • Now bundles an updated Java JRE (7u75)
  • Fixed: Should be able to double click connector midpoint to clear user-set fixed position
Version 2.9.6 | Release Date: 2015-01-25 | Download
  • Fix for schema names in view definitions caused the name to display incorrectly
  • Fix for schema name editing bug where schema names couldn't be reset back to the empty string
  • Fix for incorrect name collision handling if a schema name was changed so two tables had the same name+schema
  • Fix for bug in diff export where the diff mode set in the export panel was ignored and the value set in the document used instead
  • Diff mode change in the export panel now correctly updates the diff mode menu in the document
Version 2.9.3 | Release Date: 2014-12-09 | Download
  • 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
  • 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
  • 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
Version 2.9.1 | Release Date: 2014-11-06 | Download

New Features

  • “Export Again” for images and SQL files
  • Option to sort objects in output by name order instead of logical order


  • Drawing performance should be faster
  • Better object selection and dragging
  • Update postgres types list
  • SQL parser now supports VARCHAR(max) and certain table level constraints
  • Comment object body text is now editable inline
  • Assorted performance improvements

Bug Fixes

  • Fixed a number of memory managment bugs
  • SVG output fixes
  • ALTER TABLE for index wasn’t working for table level indexes
  • Assorted other bug fixes
Version 2.8.5 | Release Date: 2014-08-21 | Download
  • This version includes better comment editing, improved MySQL index creation, fixes for various bugs and better Yosemite (OS X 10.10) support
  • Added double-click to edit on comment field text
  • Added text overflow indicator on comment boxes
  • New export preference option to use use ALTER TABLE ADD INDEX instead of CREATE INDEX in mysql dialect
  • Updated bundled Java JRE to 7u67 (bundled into the app and used only by SQLEditor)
  • 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)
Version 2.8.1 | Release Date: 2014-06-16 | Download
  • This version includes SQL parsing improvements, better tracking of state for unmodified 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
  • 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
  • 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
  • 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)
  • 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
  • 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
  • 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
Version 2.7.4 | Release Date: 2014-05-08 | Download
  • This version improves handling of document files with invalid characters and fixes various other bugs
  • 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
  • Fix for possible exception if a connector line was selected when creating a new label via the object menu
  • Fix for shared document controller not being created early enough in the startup sequence
  • Fix for diff in SQLServer with indexes. They would register as new objects every time due to an issue if quote identifiers was ON
  • Fix for mysql character set list not appearing in inspector
Version 2.7.3 | Release Date: 2014-04-15 | Download

Version 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
  • 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
  • Better quoting and escaping of default values that include quote characters in the value
  • New warning when attempting to drop a foreign key but the constraint name is unknown
  • Can now explicitly set constraint name for foreign keys in Postgres and SQLServer
  • 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
  • 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)
  • 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
  • Fix for bug in alter foreign key with Postgres
  • Fix for duplicate export foreign key in Postgres diff
  • Removed some regex code that was possibly causing a crash
  • Removed obsolete regular expressions code and replaced with better code
Version 2.7.1 | Release Date: 2014-02-26 | Download
  • 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.
  • Improved file dragging into documents, now you can drag SQLEditor documents,SQL source files and SQLite files directly into the document window.
  • 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)
  • 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
  • Fix for bug that caused a crash if a connector was moved then deleted, before undoing both actions
  • Changed handling of overview image
  • Fix for possible bug relating to lock focus
  • Fix for broken Database SQL View import/export. (file got removed from build target causing failure)
  • Changed PostgreSQL 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
Version 2.7 | Release Date: 2014-01-27 | Download
  • This version includes a new customizable object palette, fixes for running on case-sensitive formatted drives and various bug fixes
  • 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 bug which prevented launch on case sensitive drives
  • Fix for Java launch bug on case sensitive drives
  • 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.
  • 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
Version 2.6.2 | Release Date: 2014-01-02 | Download
  • Bug fix release to fix bugs identified in v2.6
  • 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
Version 2.6.1 | Release Date: 2013-12-17 | Download
  • This version fixes a bug in the find panel that caused the selection to change unexpectedly
Version 2.6 | Release Date: 2013-12-09 | Download
  • This version includes a new overview window, an updated bundled jvm, and various bug fixes
  • Removed incorrect keyboard shortcut from overview panel menu item
  • 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
Version 2.5 | Release Date: 2013-09-06 | Download
  • Built in, native driver support (for MySQL, Drizzle, Postgres and SQLite)
  • Database operations now run in a separate process for better stability
  • All java operations now occur in a separate process
  • Better quoting of reserved words
  • Better zooming, now zooms centered on window visible area if possible
  • Improvements for command line mode
  • Other minor improvements and bug fixes
Version 2.2.3 | Release Date: 2013-08-15 | Download
  • Release version of 2.2.3b3
  • From 2.2.3b3
    • Fix for custom dialect panels being loaded more than once
  • From 2.2.3b2
    • 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
  • From 2.2.3b1
    • 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
    • Changes to way toolbar is handled (not a category any more)
    • Added support for max_length in django
    • Fixed django field inspector subpanel not appearing
    • Django removed quotes from choices option on export
    • Fixed exception in window controller with particular types of key events
Version 2.2.1 | Release Date: 2013-07-03 | Download
  • Key changes include a new "last database export" diff snapshot and various bug fixes
  • 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
  • Fix for bug in sqlite foreign key importing, where foreign and primary columns were being reversed
  • 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
Version 2.2 | Release Date: 2013-06-13 | Download


  • Java runtime now bundled, system installed java not needed if using OS X 10.7.3 or later
  • Updated to newer version of Sparkle library
  • Revised find sidebar panel, now selects object on first click
  • Canvas area popup menu now has add object commands
  • Asynchronous file saving on 10.7 and later
  • Switched sidebar standard sql export to run in a background thread
  • Improved Undo - missing object properties and settings should now be undo-able

Bug Fixes

  • Fix for panels not saving open/closed state
  • Fix for inspector when switching between documents - it now updates the selection properly
  • Fix for forced unique option for foreign keys not working correctly
  • Changes to the way that the inspector handles empty selections
  • Fix for position of new objects being incorrect - objects should appear at last clicked location
  • 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
  • Fix for table type not enabled when document opens
  • Fix for parser to allow "ALTER COLUMN table SET DATA TYPE". The "SET DATA" bit wasn't supported before
  • Fix for parser not ignoring ALTER instructions for objects that we don't support (like FUNCTION in postgres)
  • 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
  • Schema View popup cut command is now in correct place
  • Fix for bug which prevented setting empty foreign key label on foreign key objects
  • revised object name stem handling for class naming (rails, django)
  • Better primary key handling internally
  • Revised handling of model setting
  • Revised handling of dialect specific subpanes in the inspector
  • Fix for view parsing where conditions include a '<=' or '>='
  • Some fixes for compound foreign keys
  • Various other stability and correctness improvements

Performance Improvements

  • Fixed a bottleneck in the dialect specific panels code
  • Changes to selection handling to speed up deselection in large documents
  • Revised object quoting to improve performance
  • Revised find object system to reduce overhead when not in use
  • Rearranged exporters to support state during export as a performance improvement
  • Changes to primary key handling for better performance
Version 2.1.3 | Release Date: 2013-05-24 | Download
  • 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
Version 2.1.2 | Release Date: 2013-05-14 | Download

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
Version 2.0.14 | Release Date: 2013-03-28 | Download
Version 2.0.14
  • 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
Version 2.0.12 | Release Date: 2013-03-11 | Download
  • 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
Version 2.0.11 | Release Date: 2013-02-21 | Download

Fix for out of range exception when editing view query

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

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

Version 2.0.8 | Release Date: 2013-02-18 | Download
  • 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
Version 2.0.6 | Release Date: 2012-12-13 | Download
Version 2.0.6 - A Bug fix release for SQLEditor 2:
  • 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)
Version 2.0 | Release Date: 2012-10-10 | Download
  • 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
Version 1.7.18 | Release Date: 2012-07-25 | Download
SQLEditor Change Log http://www.malcolmhardie.com/sqleditor/appcast.xml Most recent changes with links to updates. en Version 1.7.18 http://www.malcolmhardie.com/sqleditor/versionhistory.php?htmlFragment=1&version=1.7.18

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)
25th July 2012 10.5.8
Version 1.7.17 | Release Date: 2012-05-11 | Download
  • 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.
Version 1.7.15 | Release Date: 2012-02-28 | Download
  • SQLite autoincrement keyword parsing
  • SQLite add column fix
Version 1.7.14 | Release Date: 2012-01-23 | Download
Version 1.7.14
  • 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.
Version 1.7.12 | Release Date: 2011-12-30 | Download
  • Fix for cardinality on table level foreign keys not saving
  • SQLite export now uses double quotes for identifiers and single quotes for quoted values
Version 1.7.11 | Release Date: 2011-10-31 | Download
  • Fix for graphical glitch on Lion when scrollbars are hidden
Version 1.7.10 | Release Date: 2011-10-21 | Download
  • 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
Version 1.7.9 | Release Date: 2011-08-19 | Download
  • 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
Version 1.7.8 | Release Date: 2011-08-09 | Download
Version 1.7.8

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
Version 1.7.6 | Release Date: 2011-06-20 | Download
  • 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
Version 1.7.5 | Release Date: 2011-03-29 | Download
  • 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
Version 1.7.4 | Release Date: 2011-03-22 | Download
  • 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
Version 1.7.3 | Release Date: 2011-03-04 | Download


  • 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
Version 1.7.2 | Release Date: 2011-01-27 | Download
  • 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
Version 1.6.9 | Release Date: 2010-09-18 | Download

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

Version 1.6 | Release Date: 2009-11-29 | Download
SQLEditor - 1.6 Release Version New online help Changed position of inspector on first launch
Version 1.4.7 | Release Date: 2009-07-21 | Download
SQLEditor - 1.4.7 All improvements from 1.4.6b1 to 1.4.6b7From Version 1.4.6b1 New Icons New Toolbar graphicsFrom Version 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 behaviour of index exporting. Table names are not now automatically added to index names on exportFrom Version 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)From Version 1.4.6b5 Improved canvas dragging Improved behaviour 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.5From Version 1.4.6b6 Now identifies columns that differ in "unsigned" setting when looking for mismatches in foreign keysFrom Version 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)
Version 1.4.5 | Release Date: 2009-05-01 | Download
SQLEditor - 1.4.5 Release version of 1.4.5b1From Version 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 cancelling a create connector action more than once.
Version 1.4.4 | Release Date: 2009-04-27 | Download
SQLEditor - 1.4.4 All improvements from 1.4.4b1 to 1.4.4b2From Version 1.4.4b1 New foreign key object with support for multi-column foreign keys New options to modify behaviour 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)From Version 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
Version 1.4.3 | Release Date: 2009-01-04 | Download
SQLEditor - 1.4.3 All improvements from 1.4.3b1 to 1.4.3b3From Version 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 buttonFrom Version 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 schemaFrom Version 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
Version 1.4.1 | Release Date: 2008-09-16 | Download

* All improvements from 1.4.1b1 to 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

* 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

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

* 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

Version 1.4 | Release Date: 2008-07-14 | Download

* Release version

* Fixes for auto increment with SQLite
* Final Candidate Version for 1.4

* 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

* Fix for Java Update for Mac OS X 10.5 release 1 bug.

* 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

* 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

* 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

* 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

* internal release only

* 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

* 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

* 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

* FIX: startup failure on 10.4

* Added per document option to hide field types

* 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

* 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

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

* 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

* 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

* Fix for JDBC Driver list sometimes being empty
* Fix for a bug relating to updating the source sidebar when closing a window.

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

* Fix for undo on index fields
* Minor fix to registration window user interface

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

* 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

Version 1.3.9 | Release Date: 2007-05-19 | Download
  • 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
Version 1.3.8 | Release Date: 2007-03-08 | Download

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

Version 1.3.6 | Release Date: 2007-02-06 | Download

* Fix for mysql auto increment not being read correctly when using jdbc database import
* further fixes for database connection issues.

* Fix for a bug that prevented Database connection windows from opening if there were no preset connections.

* 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

* Internal release only

* 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

Version 1.3.1 | Release Date: 2006-12-10 | Download
No changes specified