What's New
Update Channel: release

Paid Upgrade

There is a charge to upgrade to SQLEditor 3

Licenses bought on or after 1st March 2014can upgrade free of charge

SQLEditor 3

SQLEditor 3 brings new features including a new single window interface, design report generation, new style options including the ability to set the object display fonts, performance improvements, better pre-flighting and a new javascript plugin system.

Learn more

Changes in this build (3.1.4)

SQLEditor - 3.1.4

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

  • 3.1.4
    • Now distributed in a dmg (again) due to changes in gatekeeper on 10.12
  • 3.1.2
    • Move primary key constraint name into object section of table inspector
    • New db export checkbox "Drop Check Constraints". Prevents dropping check constraints unless checked.
    • (Altering constraints is permitted)
    • Removed SQL server specific panel (primary key constraint name is now part of the main inspector)
    • Fix postgres alter not null and default value
    • Fix oracle alter not null and default value
    • Fix incorrect sql when dropping postgres constraint
    • Most dialects now add a primary key constraint name when exporting
    • Field level check constraints (appeared in 3.1.0) have been removed in favor of table level check constraints.
    • Any field level check constraints will be converted to table level constraints when loaded
    • Fix check constraint name parsing (SQL)
    • Removed obsolete "Install Java" button in preferences panel
    • [includes: 3.1.0,3.1.1]
  • 3.1.1
    • Fix for primary key values not updating in export when field name is changed
  • 3.1.0
    • Added Check Constraint object for tables
    • Added field level check constraints for fields
    • Added import check constraints via SQL parser
    • Added import check constraints from database import for Postgres and SQLite, SQLServer
    • Check Constraint exporting for Postgres, SQLite, SQL Server
    • Better modification of primary keys when modifying columns that are part of the primary key
    • SQLEditor will now drop and replace foreign keys if it needs to modify a primary key
    • Fix for SQL server export where SQLEditor was exporting RESTRICT keyword incorrectly
    • Can now move default style connector position in some modes (control handle appears when possible)
    • Modified connector lines to avoid objects better
    • Fix parse foreign key where the column list in the target table is unspecified
    • Revised field and index export slightly so that constraints appear after fields
    • Fix table name lookup for foreign keys in specific cases where the name included a schema
    • Fix SQL server field constraints
    • Fix table ordering when importing (incorrectly reversed in 3.0.3
    • Primary key constraint name is now used in most dialects
    • Foreign key constraint names are used in more cases
    • Field to set primary key constraint name in postgres, sql server dialects
    • New field for foreign key constraint setting in field inspector fk panel
    • SQLite exporter now rebuilds tables in more cases including when primary or foreign keys have changed
    • SQL server primary key columns now export as NULL even if this is not explictly set
    • Updated help with new sections on constraints
    • Fix html report export foreign key constraint name not exporting on field fks
    • Fix html report export object comments not exporting on fields
  • 3.0.3
    • Fix for bug where fields could not be dragged after a table was copied or duplicated
    • Fix for forced object renaming incorrectly where the name contained an underscore and a number
    • Fix for layering of objects on opening saved document being wrong

SQLEditor (com.malcolmhardie.sqleditor.cocoa) is a Mac software application that has been discovered and submitted by users of Software.com. The latest version that our users have reported running on their systems is SQLEditor 9312.

Operating System: Mac

Default Install Path: /Applications/SQLEditor.app

Bundle Information: SQLEditor (Cocoa) v1.7.6