Softpedia >Mac >Developer Tools >SQLEditor >  Changelog

SQLEditor Changelog

What's new in SQLEditor 4.0.2

Feb 1, 2023
  • 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

New in SQLEditor 4.0.1 (Feb 1, 2023)

  • First native Apple Silicon Release
  • Improvements for UI layout and controls on MacOS 12 and 13
  • 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
  • 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
  • Internal improvements and refactoring work to SQL export
  • MacOS 10.14 now minimum.
  • And a beautiful New Icon created by Johan Basberg!

New in SQLEditor 3.7.7 (Sep 28, 2021)

  • Fix for launch issue on Apple Silicon M1 macs

New in SQLEditor 3.7.6 (Sep 7, 2021)

  • 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

New in SQLEditor 3.7.4 (Sep 17, 2020)

  • 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

New in SQLEditor 3.7.3 (Sep 17, 2020)

  • Fix for label color changing to black if color picker window was open after changing label color
  • Fix for clicking default label color not changing color of default objects

New in SQLEditor 3.7.2 (Jun 30, 2020)

  • 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)
  • This version has a Java runtime with more modules included to solve problems with certain JDBC drivers
  • Added Amazon redshift data types
  • Added importing of Postgres comments
  • Schema background color can be set by user
  • 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
  • Fixes for SSL support when using MySQL JDBC Drivers
  • 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
  • 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
  • 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

New in SQLEditor 3.6.2 (Oct 1, 2019)

  • New Features:
  • This release supports Mac OS Catalina/10.15
  • New object visibility menus in toolbar and view menu - show and hide objects by type
  • New Help system, should work the same as AppleHelp and contain the same content as before
  • New option for comments without visible titlebars
  • New command to show only fields that are primary keys in tables
  • Now bundles and uses Amazon Corretto Java 11
  • New system to save django properties when used
  • New preferences panel to edit the saved django properties list
  • Updated feedback reporter to newer release from upstream
  • Hardened runtime enabled
  • First notarized version
  • Removed obsolete Java 6 support
  • Updated drag and drop code
  • Fixes:
  • Fixes for foreign keys where fields are hidden (the line retargets the table header)
  • Fix for left sidebar icon drawing on 10.12,10.13
  • Fix for potential issue where invalid django properties could render a file unreadable by SQLEditor
  • Updated some old code that still used old style alert panel methods
  • Removed final parts of Java 6 installation code
  • 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
  • Fix for bug in feedback reporter where tab view labels would disappear
  • 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
  • Fixes for new help system search on 10.10 and 10.11

New in SQLEditor 3.5.5 (Jun 20, 2019)

  • 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

New in SQLEditor 3.5.4 (Feb 5, 2019)

  • 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

New in SQLEditor 3.5.1 (Jan 8, 2019)

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

New in SQLEditor 3.3.12 (Aug 2, 2018)

  • Fix for MySQL JDBC Connector/J 8.x issue which caused tables not to be imported.

New in SQLEditor 3.3.11 (Jun 14, 2018)

  • Fix for possible crash when running on 10.11 or earlier and opening inspector panels

New in SQLEditor 3.3.10 Beta (Jun 11, 2018)

  • Fix for possible crash when running on 10.11 or earlier and opening inspector panels

New in SQLEditor 3.3.9 (Jun 10, 2018)

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

New in SQLEditor 3.3.8 (Jun 10, 2018)

  • 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

New in SQLEditor 3.3.7 (May 27, 2018)

  • 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

New in SQLEditor 3.3.5 (Apr 27, 2018)

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

New in SQLEditor 3.3.4 (Mar 30, 2018)

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

New in SQLEditor 3.3.3 (Mar 12, 2018)

  • Fix for bug which caused an active inline rename edit text edit field not be removed when the field was deleted.

New in SQLEditor 3.3.2 (Mar 12, 2018)

  • 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

New in SQLEditor 3.3.1 (Mar 1, 2018)

  • Fix for a crashing bug that could prevent SQLEditor from launching due to plugin issue.

New in SQLEditor 3.3.0 (Feb 23, 2018)

  • 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

New in SQLEditor 3.3.0 Beta 4 (Feb 19, 2018)

  • Fix for crash in find sidebar
  • New method of loading ui panels for plugins
  • Native plugins now support custom foreign key type matching (in JS soon)
  • Django now allows specifying a virtualenv directory
  • Django now doesn't flag ForeignKey type mismatches
  • Fixed various bugs in foreign key type matching
  • Fixed some memory management issues

New in SQLEditor 3.3.0 Beta 3 (Feb 1, 2018)

  • Can now use inline renaming on indexes
  • Fix for inline renaming editing issues
  • Fix sidebar toolbar button icons

New in SQLEditor 3.3.0 Beta 2 (Jan 19, 2018)

  • 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

New in SQLEditor 3.3.0 Beta 1 (Dec 10, 2017)

  • New option to add custom SQL at the beginning of exported SQL
  • 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 behavior)

New in SQLEditor 3.2.2 (Oct 16, 2017)

  • Fix for exception when selecting objects on 10.11 and earlier caused by touchbar code.

New in SQLEditor 3.2.1 (Oct 16, 2017)

  • 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 auto-sizing

New in SQLEditor 3.2.0 (Oct 6, 2017)

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

New in SQLEditor 3.1.9 (Jun 12, 2017)

  • Fix for exception in new JSON exporter

New in SQLEditor 3.1.9 Beta (Jun 7, 2017)

  • Fix for exception in new JSON exporter.

New in SQLEditor 3.1.8 (Jun 5, 2017)

  • Fix for crash in parser that occurred when default values failed to parse
  • 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

New in SQLEditor 3.1.8 Beta 2 (May 23, 2017)

  • Fix for crash in parser that occurred when default values failed to parse.

New in SQLEditor 3.1.8 Beta 1 (May 18, 2017)

  • 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

New in SQLEditor 3.1.7 (Feb 22, 2017)

  • 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

New in SQLEditor 3.1.7 Beta (Feb 10, 2017)

  • 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

New in SQLEditor 3.1.6 (Jan 13, 2017)

  • 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

New in SQLEditor 3.1.6 Beta (Jan 6, 2017)

  • 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

New in SQLEditor 3.1.5 (Dec 12, 2016)

  • 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

New in SQLEditor 3.1.4 (Sep 28, 2016)

  • New Features:
  • Check Constraints (Add Constraint, set type to CHECK)
  • SQL export improvements
  • SQL diff and database export improvements
  • Parsing of foreign keys where only the target table name is provided
  • More use of constraint names in export
  • Can now set primary key constraint name in all dialects
  • Significant Bug Fixes:
  • Fix report comments and foreign keys not exporting
  • Fix layering bug when opening documents
  • Fix field dragging bug after copying tables
  • Better line positioning, less likely to draw through object
  • Plus lots of other bug fixes - see the version history for more details
  • Earlier Changes:
  • Now distributed in a dmg (again) due to changes in gatekeeper on 10.12

New in SQLEditor 3.1.4 Beta (Sep 27, 2016)

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

New in SQLEditor 3.1.2 (Sep 26, 2016)

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

New in SQLEditor 3.1.1 (Sep 16, 2016)

  • Fix for primary key values not updating in export when field name is changed.

New in SQLEditor 3.1.0 (Sep 14, 2016)

  • 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

New in SQLEditor 3.0.3 (Aug 15, 2016)

  • 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

New in SQLEditor 3.0.2 (Jun 30, 2016)

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

New in SQLEditor 3.0.2 Beta 2 (Jun 27, 2016)

  • 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

New in SQLEditor 3.0.2 Beta 1 (Jun 13, 2016)

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

New in SQLEditor 3.0.1 (May 26, 2016)

  • 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

New in SQLEditor 3.0.1 Beta (May 23, 2016)

  • 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

New in SQLEditor 3.0 Beta (May 19, 2016)

  • SQLEditor 3.0 Release Version
  • Functionally identical to 3.0rc5

New in SQLEditor 3.0 RC 5 (May 18, 2016)

  • Removed an obsolete assertion in the resize code that caused an exception
  • Fixed missing diff callback for js plugins

New in SQLEditor 3.0 RC 4 (May 11, 2016)

  • Added extra new line in diff between alter table instructions
  • Fixed source sidebar not refreshing with changes made when it was closed

New in SQLEditor 3.0 Build 8896 (Apr 18, 2016)

  • Fix code sign issue relating to HTML plugin that caused updates to fail.

New in SQLEditor 3.0 Beta 16 (Mar 26, 2016)

  • 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

New in SQLEditor 3.0 Beta 15 (Mar 21, 2016)

  • 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

New in SQLEditor 3.0 Beta 14 (Mar 7, 2016)

  • 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

New in SQLEditor 2.9.17 (Mar 2, 2016)

  • Fix grid drawing when grid size was set to a non-standard size using the slider.

New in SQLEditor 2.9.16 (Feb 29, 2016)

  • 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

New in SQLEditor 2.9.15 (Feb 26, 2016)

  • 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

New in SQLEditor 3.0 Beta 12 (Feb 12, 2016)

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

New in SQLEditor 3.0 Beta 11 (Feb 1, 2016)

  • Improve parser support for CLUSTERED and FULLTEXT index types
  • Fix for line position in arrow style being wrongly positioned

New in SQLEditor 2.9.14 (Jan 29, 2016)

  • Fix for crashing bug when editing view query string.

New in SQLEditor 3.0 Beta 10 (Jan 23, 2016)

  • 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

New in SQLEditor 3.0 Beta 9 (Jan 21, 2016)

  • 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

New in SQLEditor 3.0 Beta 8 (Jan 19, 2016)

  • 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

New in SQLEditor 3.0 Beta 7 (Jan 11, 2016)

  • 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

New in SQLEditor 2.9.12 (Nov 30, 2015)

  • 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

New in SQLEditor 2.9.11 (Oct 23, 2015)

  • 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
  • Fix for backing store exception on 10.6
  • 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)

New in SQLEditor 2.9.8 (Jul 10, 2015)

  • This version fixes a crash in window creation and improves grid drawing performance (a bit) which should make zooming slightly smoother
  • This version removes window titlebar components (beta/unregistered) which seem to have caused a crash
  • Background grid line drawing (which was identified as slow) has been speeded up a bit by using an offscreen cache.

New in SQLEditor 2.9.7 (Feb 28, 2015)

  • This version bundles a newer Java runtime, adds better support for the mysql BINARY keyword and fixes a bug with connector positioning in orthogonal connector mode.

New in SQLEditor 2.9.6 (Jan 26, 2015)

  • Fix for schema names in view definitions caused the name to display incorrectly

New in SQLEditor 2.9.5 (Jan 26, 2015)

  • 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

New in SQLEditor 2.9.4 (Dec 27, 2014)

  • Fix for bug where right clicking on drag handle or connector handle could cause exception
  • Fix for clipping of connector lines when in orthagonal mode for vertical connectors

New in SQLEditor 2.9.3 (Dec 10, 2014)

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

New in SQLEditor 2.9.2 (Nov 12, 2014)

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

New in SQLEditor 2.9.1 (Nov 7, 2014)

  • 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.
  • 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
  • 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
  • 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
  • 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
  • Disabled responsive scrolling (unexpected performance issues)
  • Fix for comment inline editing bugs
  • 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
  • Fix for overview panel ignoring saved visibility state.
  • 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)
  • 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)

New in SQLEditor 2.8.5 (Aug 21, 2014)

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

New in SQLEditor 2.8.4 (Jul 11, 2014)

  • 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

New in SQLEditor 2.8.3 (Jun 27, 2014)

  • Fixed an issue relating to index diff with SQLServer

New in SQLEditor 2.8.2 (Jun 17, 2014)

  • Fix for help menu items that were broken due to readme and release notes html files being missing from build.

New in SQLEditor 2.8.1 (Jun 16, 2014)

  • 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

New in SQLEditor 2.7.4 (May 8, 2014)

  • This version fixes issues with invalid characters in document files and fixes various other bugs
  • Fix for mysql character set list not appearing in inspector
  • 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

New in SQLEditor 2.7.3 (Apr 16, 2014)

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

New in SQLEditor 2.7.1 (Feb 27, 2014)

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

New in SQLEditor 2.7 (Jan 27, 2014)

  • This version includes a new customizable object palette, fixes for running on case-sensitive formatted drives and various bug fixes
  • 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.
  • 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

New in SQLEditor 2.6.2 (Jan 3, 2014)

  • This version includes fixes for object target highlighting, scaled drawing, and object dragging
  • 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

New in SQLEditor 2.6.1 (Dec 17, 2013)

  • Fix for find panel bug where selection would be forced back to items selected in find panel

New in SQLEditor 2.6 (Dec 10, 2013)

  • 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

New in SQLEditor 2.5.1 (Oct 2, 2013)

  • This version includes fixes for various parser bugs, a fix for an xml parsing issue and fixes for some registration problems.
  • Fix for trial menu not disappearing when registering + related fixes
  • 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.

New in SQLEditor 2.5 (Sep 9, 2013)

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

New in SQLEditor 2.5 Beta 3 (Sep 9, 2013)

  • Helper tool now renamed "SQLWorker"
  • Moved command line operations to "SQLWorker" instead of main binary
  • Command line mode fixed for JDBC operations

New in SQLEditor 2.5 Beta 2 (Sep 9, 2013)

  • 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

New in SQLEditor 2.5 Beta 1 (Sep 9, 2013)

  • Renumbered to 2.5 (too many threes already)
  • 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

New in SQLEditor 2.3 Beta 3 (Sep 9, 2013)

  • Special build with java disabled by default

New in SQLEditor 2.3 Beta 2 (Sep 9, 2013)

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

New in SQLEditor 2.3 Beta 1 (Sep 9, 2013)

  • 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

New in SQLEditor 2.2.3 (Aug 16, 2013)

  • Fix for custom dialect panels being loaded more than once
  • 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
  • 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

New in SQLEditor 2.2.2 (Jul 17, 2013)

  • Fix for bug in handling import errors in rails + other plugins

New in SQLEditor 2.2.1 (Jul 4, 2013)

  • Release version of 2.2.1b3
  • Key changes include a new "last database export" diff snapshot and various bug fixes

New in SQLEditor 2.2 (Jun 13, 2013)

  • Key changes include user interface fixes, performance improvements (particularly with bigger documents) and various bug fixes
  • Fix for panels not saving open/closed state
  • Fixed a bottleneck in the dialect specific panels code
  • Updated to newer version of Sparkle library
  • 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
  • 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 '='
  • 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

New in SQLEditor 2.1.3 (May 24, 2013)

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

New in SQLEditor 2.1.2 (May 15, 2013)

  • Fix for SVG exporting of views (entries were missing)

New in SQLEditor 2.1.1 (May 15, 2013)

  • Fix for another issue with inspector not matching object - causing an exception

New in SQLEditor 2.1 (May 15, 2013)

  • 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

New in SQLEditor 2.0.14 (Mar 28, 2013)

  • 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

New in SQLEditor 2.0.12 (Mar 11, 2013)

  • 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

New in SQLEditor 2.0.11 (Feb 22, 2013)

  • Fix for out of range exception when editing view query

New in SQLEditor 2.0.10 (Feb 21, 2013)

  • 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 in SQLEditor 2.0.9 (Feb 21, 2013)

  • 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

New in SQLEditor 2.0.8 (Feb 18, 2013)

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

New in SQLEditor 2.0.8 (Feb 18, 2013)

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

New in SQLEditor 2.0.7 (Feb 18, 2013)

  • 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

New in SQLEditor 2.0.6 (Dec 14, 2012)

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

New in SQLEditor 2.0.3 (Dec 14, 2012)

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

New in SQLEditor 2.0.2 (Oct 31, 2012)

  • 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

New in SQLEditor 2.0.1 (Oct 22, 2012)

  • 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

New in SQLEditor 2.0 (Oct 9, 2012)

  • New diff export
  • Multiple selection and editing
  • 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

New in SQLEditor 1.7.18 (Jul 26, 2012)

  • Release of 1.7.18b1

New in SQLEditor 1.7.18 Beta 1 (Jul 24, 2012)

  • First gatekeeper signed version (for mountain lion)
  • Fix for bug where object locations would be corrupted

New in SQLEditor 1.7.16 Beta 3 (May 8, 2012)

  • Rewrite of layering system (from v2.0) to fix a performance issue when pasting.

New in SQLEditor 1.7.16 Beta 2 (Apr 19, 2012)

  • Fix for undo when pasting

New in SQLEditor 1.7.16 Beta 1 (Apr 2, 2012)

  • 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

New in SQLEditor 1.7.15 (Feb 29, 2012)

  • SQLite autoincrement keyword parsing
  • SQLite add column fix

New in SQLEditor 2.0 Beta 11 (Feb 15, 2012)

  • 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

New in SQLEditor 2.0 Beta 10 (Feb 15, 2012)

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

New in SQLEditor 1.7.14 (Jan 24, 2012)

  • From Version 1.7.13b1:
  • This release contains sql parser improvements:
  • 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
  • From Version 1.7.13b2:
  • 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.
  • From Version 1.7.14b1:
  • Fix for 10.4 compatibility
  • Fix for parsing single alter table with multiple foreign key instructions

New in SQLEditor 1.7.14 Beta 1 (Jan 18, 2012)

  • Fix for 10.4 compatibility
  • Fix for parsing single alter table with multiple foreign key instructions

New in SQLEditor 1.7.13 Beta 2 (Jan 11, 2012)

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

New in SQLEditor 1.7.13 Beta 1 (Jan 5, 2012)

  • This release contains sql parser improvements:
  • 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

New in SQLEditor 1.7.12 (Dec 30, 2011)

  • Release version of 1.7.12b1

New in SQLEditor 1.7.12 Beta 1 (Dec 22, 2011)

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

New in SQLEditor 1.7.11 (Oct 31, 2011)

  • Release version of 1.7.11b2
  • [includes: 1.7.11b1,1.7.11b2]

New in SQLEditor 1.7.11 Beta 2 (Oct 28, 2011)

  • Added zoom menu item to toolbar
  • Added zoom menu to context (right click) menu in main window

New in SQLEditor 1.7.11 Beta 1 (Oct 28, 2011)

  • removed zoom placard to fix lion scroll tearing with gesture mouse (FS#923)
  • removed scroll zoom option (to return in b2)

New in SQLEditor 1.7.10 (Oct 21, 2011)

  • Release version of 1.7.10b2
  • [includes: 1.7.10b1,1.7.10b2]

New in SQLEditor 1.7.10 Beta 2 (Sep 24, 2011)

  • SQL Import: now collapses single entry indexes into a field level index
  • SQL Import: better handling of double quote mark escaping

New in SQLEditor 1.7.10 Beta 1 (Sep 7, 2011)

  • Fix for type field parsing so that it correctly splits enums where the enum string contains a closing bracket

New in SQLEditor 1.7.9 (Aug 19, 2011)

  • Image Export improvements
  • Exported PDF images now 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

New in SQLEditor 1.7.9 Beta 2 (Aug 17, 2011)

  • Exported PDF images now 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

New in SQLEditor 1.7.7 Beta 1 (Aug 6, 2011)

  • SQLEditor now registers itself only for the current user when running on Lion/10.7
  • 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

New in SQLEditor 1.7.6 (Jun 20, 2011)

  • Release version of 1.7.6

New in SQLEditor 1.7.6 Beta 4 (Jun 11, 2011)

  • Fix for bug where JDBC table filters were being used when exporting (FS#894)

New in SQLEditor 1.7.6 Beta 3 (Jun 7, 2011)

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

New in SQLEditor 1.7.6 Beta 2 (Jun 2, 2011)

  • Fix for bug where db connection strings not updating when preset changed [FS#890]

New in SQLEditor 1.7.6 Beta 1 (May 23, 2011)

  • Find objects now searches for the string anywhere in the object name (not just at the beginning)
  • 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

New in SQLEditor 1.7.5 (Mar 29, 2011)

  • Release version of 1.7.5b1
  • [includes: 1.7.5b1]

New in SQLEditor 1.7.5 Beta 1 (Mar 28, 2011)

  • 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

New in SQLEditor 1.7.4 (Mar 22, 2011)

  • Release version of 1.7.4b4
  • [includes: 1.7.4b4,1.7.4b3,1.7.4b2]

New in SQLEditor 1.7.4 Beta 4 (Mar 21, 2011)

  • Fixed to support sparkle beta appcast correctly
  • Modified update system to fix other minor bugs

New in SQLEditor 1.7.4 Beta 2 (Mar 16, 2011)

  • 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

New in SQLEditor 1.7.3 (Mar 4, 2011)

  • Release version of 1.7.3b4
  • [includes: 1.7.3b4,1.7.3b3,1.7.3b2,1.7.3b1]

New in SQLEditor 1.7.3 Beta 4 (Feb 23, 2011)

  • Fix for bug where pasting a field would put new field in wrong location (bug in 1.7.3b3)
  • 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

New in SQLEditor 1.7.3 Beta 3 (Feb 22, 2011)

  • Improved file saving, fewer unnecessary changes and improved scm compatiblity
  • 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

New in SQLEditor 1.7.3 Beta 2 (Feb 15, 2011)

  • ON UPDATE now imported from JDBC
  • SQLite JDBC username bug fixed
  • Fixed "Don't quote default value" setting with postgres

New in SQLEditor 1.7.3 Beta 1 (Feb 9, 2011)

  • 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

New in SQLEditor 1.7.2 (Jan 28, 2011)

  • Release version of 1.7.2b2
  • [includes: 1.7.2b1,1.7.2b2]

New in SQLEditor 1.7.2 Beta 2 (Jan 25, 2011)

  • Fix for bug where object locations weren't saving

New in SQLEditor 1.7.2 Beta 1 (Jan 19, 2011)

  • 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

New in SQLEditor 1.7.1 (Jan 12, 2011)

  • Release version of 1.7.1b1

New in SQLEditor 1.7.1 Beta 1 (Jan 7, 2011)

  • 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

New in SQLEditor 1.7.0 (Dec 14, 2010)

  • Release version of 1.7.0b2
  • [includes: 1.7.0b1,1.7.0b2]

New in SQLEditor 1.6.9 (Sep 19, 2010)

  • Release version of 1.6.9b2
  • [includes: 1.6.9b1,1.6.9b2]

New in SQLEditor 1.6.9 Beta 2 (Sep 17, 2010)

  • 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

New in SQLEditor 1.6.8 (Aug 25, 2010)

  • 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

New in SQLEditor 1.6.7 (Aug 25, 2010)

  • Internal development version only

New in SQLEditor 1.6.6 (Aug 25, 2010)

  • 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

New in SQLEditor 1.6.5 (Jul 2, 2010)

  • 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

New in SQLEditor 1.6.4 (Jun 18, 2010)

  • 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

New in SQLEditor 1.6.4 Beta 2 (Jun 4, 2010)

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

New in SQLEditor 1.6.3 (Apr 29, 2010)

  • Fix for some Help Menu items not working
  • Release version of 1.6.3b1

New in SQLEditor 1.6.2 (Apr 23, 2010)

  • 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

New in SQLEditor 1.6.1 (Feb 23, 2010)

  • 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

New in SQLEditor 1.6 (Nov 30, 2009)

  • Release Version.
  • New online help.
  • Changed position of inspector on first launch.

New in SQLEditor 1.6 Beta 17 (Nov 20, 2009)

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

New in SQLEditor 1.6 Beta 16 (Nov 18, 2009)

  • 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

New in SQLEditor 1.6 Beta 14 (Nov 3, 2009)

  • 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

New in SQLEditor 1.6 Beta 11 (Oct 9, 2009)

  • 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

New in SQLEditor 1.6 Beta 9 (Sep 28, 2009)

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

New in SQLEditor 1.6 Beta 8 (Sep 24, 2009)

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

New in SQLEditor 1.6 Beta 7 (Sep 22, 2009)

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

New in SQLEditor 1.6 Beta 6 (Sep 19, 2009)

  • Fix for strange object dragging behavour 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.

New in SQLEditor 1.6 Beta 5 (Sep 10, 2009)

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

New in SQLEditor 1.4.7 (Jul 22, 2009)

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

New in SQLEditor 1.4.6 Beta 6 (Jun 27, 2009)

  • Now identifies columns that differ in "unsigned" setting when looking for mismatches in foreign keys.

New in SQLEditor 1.4.6 Beta 3 (Jun 3, 2009)

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

New in SQLEditor 1.4.5 (May 5, 2009)

  • Release version of 1.4.5b1
  • [includes: 1.4.5b1]

New in SQLEditor 1.4.4 (Apr 28, 2009)

  • All improvements from 1.4.4 Beta 1 to 1.4.4 Beta 2.

New in SQLEditor 1.4.4 Beta 2 (Apr 22, 2009)

  • Fix for error message when importing from Oracle.
  • Fix for bug that moved connector handles when an object was pasted into a document.

New in SQLEditor 1.4.4 Beta 1 (Apr 6, 2009)

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

New in SQLEditor 1.4.3 (Jan 11, 2009)

  • All improvements from 1.4.3b1 to 1.4.3b3
  • [includes: 1.4.3b1,1.4.3b2,1.4.3b3]

New in SQLEditor 1.4.3 Beta 3 (Dec 22, 2008)

  • 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

New in SQLEditor 1.4.3 Beta 2 (Dec 15, 2008)

  • 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

New in SQLEditor 1.4.3 Beta 1 (Nov 14, 2008)

  • JDBC importer can now correctly import MySQL comments on tables and columns.
  • JDBC exporter can now modify MySQL 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.

New in SQLEditor 1.4.2 (Nov 5, 2008)

  • All improvements from 1.4.2b1 to 1.4.2b3
  • [includes: 1.4.2b1,1.4.2b2,1.4.2b3]

New in SQLEditor 1.4.2 Beta 3 (Oct 24, 2008)

  • Fix for comments on fields in MySQL exporter having extra ‘=’ (equals) sign

New in SQLEditor 1.4.2 Beta 2 (Oct 22, 2008)

  • 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

New in SQLEditor 1.4.1 (Oct 10, 2008)

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