SQLEditor

About SQLEditor

A Database design and entity relationship diagram (ERD) tool for Mac OS X.

SQLEditor replaces typing SQL by hand with dragging, dropping and clicking.
It makes creating databases much faster and really reduces errors.

If you already have a database then SQLEditor can help you see what it looks like by creating a diagram of it.

Update on Java For Mac OS X 10.5, release 1

SQLEditor 1.4b21 and 1.3.9 don't work if you have this update installed. This relates to the version of Java that SQLEditor is set up to use. Initally the idea was to provide a version of the new development branch of SQLEditor, add in the missing features and continue from there. However this has caused a few problems.

After some more development and research it was realized that it would be possible to modify the existing 1.4 beta release to work with Java For Mac OS X 10.5,
release 1. A new beta 1.4b26 has been made available which should work with this update.

SQLEditor 1.4b26 (3.5MB DMG)

(This replaces the previous 1.4b22 release posted here)

For all SQLEditor users this is now the recommended beta version to be using.

So what's going to happen to the 1.5 release?

The new codebase of the 1.5 release will arrive later in the year. It's been in progress now for nearly a year and includes rewrites of substantial portions of the application. Unfortunately it is still lacking several key features, so it will be put back under wraps for a little while longer.

If you would like to keep using SQLEditor 1.5 pre-releases you can take part in the private beta test. Please email support@malcolmhardie.com for more details.

What about stable versions?

There is an experimental build of the 1.3.9 code base, numbered 1.3.9r2. Since offering experimental builds of stable releases seems a bit odd, it's available only by request.
Please email support@malcolmhardie.com for more details.

Key Features

• Visual editing, including drag and drop
• Live source view - the SQL source changes as you edit the diagram
• Ruby On Rails Migrations - SQLEditor can export them and now (from 1.4b8) import them too!
• With SQLEditor's reverse engineering you can import existing databases to diagram and SQLEditor will create an ER diagram for you.
• Once you've created your diagram you can export it directly via JDBC to one of several supported database systems including Postgresql, Oracle® and MySQL®.
• You can save your database to an SQL instruction (DDL) file for immediate use on remote servers or with other tools.
• Import existing DDL files directly into SQLEditor
• Copy and paste to import and export supported SQL to and from SQLEditor
• You can print out designs so that you can see your database up on the wall.¹ SQLEditor also supports PDF output for easy sharing.

^{1. (You could also try mugs or t-shirts.)}

Screenshots

Product Support

For support please visit the SQLEditor Product Support page

Latest Beta Release

A beta release is a version of the program that is offered for testing before the final release. Beta versions may contain bugs and could crash. Please report any issues you may have to support@malcolmhardie.com

Alternatively you may wish to use a release version instead.

Version 1.4b26
This release offers new features and bug fixes

[Download Now]
(dmg 3MB)

Expires: 24th July 2008

30 Free Trial

SQLEditor is available to try as a fully functional 30 day trial. The trial contains all of the features of SQLEditor and when you buy a copy you simply enter the registration code into your copy to remove the time limitation.

Announcement List

Signup to the announcements mailing list to receive notification of new versions

JDBC Database drivers

The latest version of sqleditor uses JDBC drivers for database access.

For more information see the JDBC driver page

SQLEditor Component Downloads

SQLEditor uses the QStackTrace framework, which is available under the LGPL

QStackTrace Framework

^{MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates}