SQLEditor
SQLEditor 2.7.3
Your rating: Now say why...

(3) 5

Create SQL databases graphically.   Demo ($79.00)
Add to my Watch List
Email me when discounted
SQLEditor is a SQL database design and entity relationship diagram (ERD) tool for OS X.

SQLEditor replaces typing SQL by hand with dragging, dropping, and clicking. It makes creating databases faster and easier.

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

SQLEditor supports exporting database designs to MySQL, Postgres, Oracle, and others. Plus it also imports and exports Ruby On Rails Migration files.

Site license: $349, Single Copy $79. Discounts for
What's New
Version 2.7.3:
  • This version includes SQLServer dialect improvements, Postgres export fixes, better default value quoting, rewritten overview panel thumbnail code and various bug fixes and smaller improvements
  • Improved SQLServer primary key export - can now specify constraint name
  • Fix for SQLServer diff - can now alter existing primary keys (if constraint name is set)
  • New SQLServer table inspector panel - to allow editing Primary key constraint name
  • Better quoting and escaping of default values that include quote characters in the value
  • New warning when attempting to drop a foreign key but the constraint name is unknown
  • Can now explicitly set constraint name for foreign keys in Postgres and SQLServer
  • Fix for Postgres database export bug where tables without a schema should have been exported to the default schema (either set in DB panel schema field or “public” if nothing else set)
  • Fix for error in log about SQLEditor_documentInfo when accessing database via JDBC
  • Fix for bug in label panel that was possibly causing crashes when dragging objects
  • Fix for crashing bug in overview panel image drawing (and optimised the code path too)
  • Fix for primary key constraint name when constraint name is empty or nil (removes CONSTRAINT keyword from output when empty)
  • Fix for foreign key diff changes when both original and new target field had the same name but were in different tables
  • Fix for alter foreign key constraint name keyword order
  • Fix for bug in alter foreign key with Postgres
  • Fix for duplicate export foreign key in Postgres diff
  • Removed some regex code that was possibly causing a crash
  • Removed obsolete regular expressions code and replaced with better code
Version 2.7.3:
  • This version includes SQLServer dialect improvements, Postgres export fixes, better default value quoting, rewritten overview panel thumbnail code and various bug fixes and smaller improvements
  • Improved SQLServer primary key export - can now specify constraint name
  • Fix for SQLServer diff - can now alter existing primary keys (if more...
Requirements
Intel, OS X 10.6.8 or later



MacUpdate - SQLEditor






SQLEditor User Discussion (Write a Review)
ver. 2.x:
(3)
Your rating: Now say why...
Overall:
(15)

sort: smiles | time
burypromote
-1

+41

Kris_nx reviewed on 25 May 2013
Great program and support. The latest release would not launch and the support I received from the developer was excellent -very responsive and got me a version of the program that worked. He also got the latest build working within a week. Turned out to be a JAVA issue. I highly recommend this program.
[Version 2.1.3]


burypromote
+2

+48

Drtyrell969 reviewed on 23 Aug 2010
This product is instrumental in designing but also communicating to your clients what it is you've done. I highly recommend this software at any cost. A picture is worth a saved day. I use this product religiously.
[Version 1.6.5]


burypromote

-6

Trashie reviewed on 26 Feb 2010
Great application and made in Scotland of all places. Very good, very stable. Another little hidden gem on osx.
[Version 1.6.1]


burypromote

+18
barefeettom commented on 06 Mar 2008
I tested SQLEditor with an SQLite database. It imported the table structures fine, using the appropriate driver. After playing with it a bit, I realize that SQLEditor only shows relationships between tables that are set up as a "foreign key" within the tables. SQLite (and I think others) don't have a foreign key parameter for fields within tables. I set up relationships in SQLite within views. Unfortunately, SQLEditor does not appear to show views or the relationships tat they contain. So it seems of little use to show or edit the structure of my SQLite databases.
[Version 1.4b19]

2 Replies

burypromote
+1

+16
Sparrowhawk replied on 22 Oct 2008
SQLite does actually support foreign keys in terms of parsing - however it does not enforce them (i.e. they are ignored). Hopefully one day they will support them fully.

So theoretically this tool should be able to see these implied relationships and display the ERD for SQLite. I've not tried it so cannot say - if not you could ask the developer, it sounds like he is quite responsive.


Incidentally, you can force SQLite referential integrity using triggers - plenty of articles about this online.

Hope this helps.

Now, what I'd really like to see is TOAD for MySQL on OS X... :)
burypromote

+16
Sparrowhawk replied on 12 Mar 2013
I just noticed my comment here about foreign keys. As it is now so out of date, I thought I'd post a quick update just to say that SQLite acquired native foreign key constraints as of v3.6.19, so my 2008 (!) comment is now redundant.

I'm sure people already knew this, but just in case :)
burypromote

+11

kiddailey reviewed on 01 Mar 2008
Just thought I'd post an updated comment because my original one below is a bit outdated.

I've been using this for years now, and it is by far the best ER diagramming tool I've used on OS X or Windows.

Everything is straight-forward. You don't have to hover over buttons to figure out what they do and most of the work takes place in the canvas area (and optionally, the inspector) keeping you from having to constantly return to a toolbar or menu.

The layout tools are simple. Color, notes and canvas areas make it easy to organize and group segments, types and blocks of entities around the work area.

Printed output is fantastic and you can turn on page-breaks as well, enabling you to move objects to fit on individual sheets just as you want.

Import and export tools are awesome, and being able to see the raw query as you work is handy.

I use it for both MS SQL and MySQL. Though it doesn't (yet?) come configured to diagram for MS SQL Server, it is fairly trivial to get it configured for it in terms of diagramming. For MySQL and a few others, it's perfect out of the box.

The developer is responsive and the software is actively maintained.

For any serious DB architect on the Mac, this is worth every penny.
[Version 1.4b19]


burypromote

+20

silverdr reviewed on 25 Nov 2006
I have to admit that the app is quickly entering maturity stage and may well be one of the quite popular among database design enabled OS X users. The recent version even managed to properly read-in and parse my hand-made DDL with lots of nasty things inside ;-) I still have some doubts concerning the data types, which could be more aligned to what the (chosen?) RDBMS supports but this is in no way a show-stopper. The author is supportive, reacts to bug reports and suggestions quickly and efficiently. Price, while not cheap is quite moderate and IMHO not too high.
[Version 1.3]


burypromote
-1


Anonymous reviewed on 21 Oct 2004
Excellent, excellent, excellent! This great ER Diagramming tool just keeps getting better with every release.

It's got the basic functions for creating simple diagrams that can be exported to a few different SQL formats.

It doesn't easily allow you to specify field lengths, and it's got a few minor bugs, but otherwise it's a great tool.
[Version 1.0CB11a]


burypromote


Anonymous reviewed on 18 Oct 2004
I guess I should just download it and have a look, but... what databases does it support (the review kinda misses that !)

I have a remote SQL Server database (actually it runs inside a VPC session on my Mac) and a native MySQL database that I need to develop against... one tool that can do that (so I don't have to go into Enterprise Manager) would be great....
[Version 1.0CB11a]

2 Replies

burypromote
Anonymous commented on 21 Oct 2004
The field types that are available can be completely customized to your needs, so it essentially works with any SQL Server from the design aspect.

As far as exporting SQL Queries, it supposedly exports to 'generic' SQL, MySQL, PostgreSQL and Sybase though I haven't tested it yet.

For importing, it utilizes the JDBC drivers, so if you've got a driver for your DBMS, you should be able to import just fine. Again, I haven't tested it myself, but the feature's in there.
burypromote
Anonymous commented on 31 Aug 2005
Have you tried Aqua Data Studio?
burypromote


Anonymous reviewed on 15 Oct 2004
For yet another alternative see www.mludi.net/YourSQL/!
[Version 1.0CB11a]

1 Reply

burypromote
Anonymous commented on 21 Oct 2004
YourSQL doesn't allow you to create ER diagrams.
burypromote
-1


Anonymous reviewed on 15 Oct 2004
For an alternative see DataWerkz by www.uwerkz.com!
[Version 1.0CB11a]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


Ronman rated on 30 May 2013

[Version 2.1.3]



Ronman rated on 18 Feb 2013

[Version 2.0.8]



Terryr rated on 09 Jan 2012

[Version 1.7.12]



-7

http rated on 02 Aug 2011

[Version 1.7.6]



LucasH rated on 25 Apr 2011

[Version 1.7.5]


Downloads:54,613
Version Downloads:125
Type:Development : Editors
License:Demo
Date:15 Apr 2014
Platform:Intel 64 / Intel 32 / OS X
Price: $79.00
Overall (Version 2.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-10 of 16
1 2 >
Displaying 1-5 of 5
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
SQLEditor is a SQL database design and entity relationship diagram (ERD) tool for OS X.

SQLEditor replaces typing SQL by hand with dragging, dropping, and clicking. It makes creating databases faster and easier.

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

SQLEditor supports exporting database designs to MySQL, Postgres, Oracle, and others. Plus it also imports and exports Ruby On Rails Migration files.

Site license: $349, Single Copy $79. Discounts for qualified educational orders

Discounted upgrades from SQLEditor 1.x and free upgrades for copies bought on or after August 1st 2010


- -