SQLEditor 3.3.9

SQLEditor 3.3.9 macOS

Add tables and columns, indexes and foreign keys with the click of a mouse. See everything that you’ve created displayed in front of you. You can zoom out to see an overview of the structure, zoom in to see the details, everything remains editable at all zoom levels. The inspector panel displays object specific editing options for each object type and you can edit multiple objects at the same time.

SQLEditor makes database design easier

Add tables and columns, indexes and foreign keys with the click of a mouse. See everything that you’ve created displayed in front of you. You can zoom out to see an overview of the structure, zoom in to see the details, everything remains editable at all zoom levels. The inspector panel displays object specific editing options for each object type and you can edit multiple objects at the same time.

Working with your existing database

Import it into SQLEditor, make changes easily and then update the database with the changes that you’ve made. Use the diff sidebar to see the changes you’ve made in the current session, or compare against another file. SQLEditor can create a diagram from both source SQL files and live databases. You can also import and export Ruby on Rails migration files. SQLEditor logs all of the instructions that it uses so you can see what changed, and you can preview changes before exporting if you want to check the correctness first.

Presenting your database

Once you’ve built your database, SQLEditor can help you present your work to your customers, clients or boss. You can export in PDF or PNG formats for use in presentation programs and web sites. Why not put a diagram into your presentation to show how all of the tables fit together? Documentation creators may find a SQLEditor image is useful for explaining how tables fit together or which objects link to each other.

SQLEditor works with other tools

SQLEditor can create diagrams from snippets of SQL, tables can be pasted into SQLEditor, edited and copied out again in moments. SQLEditor parses SQL it finds on the clipboard and turns it into objects you can edit. Need to quickly create a table in a command line sql client? Create it in SQLEditor and paste it in, simple! And it works the other way too, if you have some SQL you need to visualize.

Major databases Supported

You can export to major database systems including MySQL, SQLite, Postgres and Oracle. SQLEditor customizes the SQL produced to work with the dialect you want. SQLEditor also supports editing Ruby on Rails migration and schema files. We also have an experimental Django plugin.

Requirement: OS X 10.9 or later

Web Site: http://www.malcolmhardie.com/sqleditor/

What’s New in SQLEditor 3.3.9

• 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
• 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
• 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
• 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.
• 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.
• 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.
• Sparkle has been updated to a newer release
• Some obsolete resources have been removed