5
Thank you for your review
$79 00
http://www.macupdate.com/download/13893/sqleditor-2-8-4.zip
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 qualified educational orders

Discounted upgrades from SQLEditor 1.x and more...

What's New

Version 2.8.4:
  • Fix for possible exception when dragging foreign keys andindexes
  • Fix for issue with foreign keys where the target table wasempty
  • Moved the connection point for table level foreign keys upwardsa bit (Now connects to the side of the object titlebar rather thanthe first object, which may not be there)
  • Minor fix to foreign key object to remove redundant logmessage

Requirements

OS X 10.6.8 or later

Similar Software

Open Comparison
Suggest Other Similar Software
Leave a Review

SQLEditor User Discussion

Nobody has reviewed or commented on this app yet. Add your own comment and get a discussion going!
Sort by: Time | Smiles
Drtyrell969 Member IconReview+125
Drtyrell969
+0

I'm just chiming in to reaffirm my 5-star rating four years since my last rating. Best product of its kind. GET!

Reply0 replies
Version 2.8.4
Kris_nx Member IconReview+46
Kris_nx
+1

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.

Reply0 replies
Version 2.1.3
Drtyrell969 Member IconReview+125
Drtyrell969
+2

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.

Reply0 replies
Version 1.6.5
Trashie Member IconReview+256
Trashie
+0

Great application and made in Scotland of all places. Very good, very stable. Another little hidden gem on osx.

Reply0 replies
Version 1.6.1
barefeettom Member IconComment+20
barefeettom
+0

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.

Reply2 replies
Version 1.4b19
Sparrowhawk
+1

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

Sparrowhawk
+2

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

kiddailey Member IconReview+15
kiddailey
+0

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.

Reply0 replies
Version 1.4b19
silverdr Member IconReview+27
silverdr
+0

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.

Reply0 replies
Version 1.3
Anonymous Member IconReview
Anonymous
+0

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.

Reply0 replies
Version 1.0CB11a
Anonymous Member IconReview
Anonymous
+0

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

Reply2 replies
Version 1.0CB11a
Anonymous Member Icon
Anonymous
+0

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.

Anonymous Member Icon
Anonymous
+0

Have you tried Aqua Data Studio?

Anonymous Member IconReview
Anonymous
+0

For yet another alternative see www.mludi.net/YourSQL/!

Reply1 reply
Version 1.0CB11a
Anonymous Member Icon
Anonymous
+0

YourSQL doesn't allow you to create ER diagrams.

user icon+0
luispa
Version 2.8.1
user icon+0
Ronman
Version 2.1.3
user icon+0
Ronman
Version 2.0.8
user icon+0
Terryr
Version 1.7.12
user icon+2
http
Version 1.7.6
user icon+0
LucasH
Version 1.7.5
> 5 17

Ratings

Overall
(17)
Current Version (2.x)
(5)

Details

Downloads 55,414
Version Downloads 157
License Demo
Date 10 Jul 2014
Platform Intel 64 / OS X / Intel 32
Price $79.00
Learn how MacUpdate Desktop makes installing apps from MacUpdate.com one-click easy.
Next time, install SQLEditor with 1-click

Learn how MacUpdate Desktop can install apps on MacUpdate with the simple click of the Install apps with MacUpdate Desktop icon. Plus, keep all your apps updated. Play video...