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
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.1:
- This version includes improved drag and drop into documents, better PostgreSQL view importing, some rails improvements, fixes for undo, some UI fixes, a fix for a crash relating to the preview window and various other minor improvements.
- Improved file dragging into documents, now you can drag SQLEditor documents,SQL source files and SQLite files directly into the document window.
- Change to post-import arranging code so that objects should get arranged in a more correct order during import (objects were previously being arranged in reverse order)
- Fix for bug where deleting objects and undoing would not restore all deleted objects
- Altered undo event coalescing behaviour
- Fix for zerofill in database import
- Drag types and pasteboard types are now using UTI instead of type strings
- Modified Paste menu command to only enable when the clipboard contains something that SQLEditor accepts
- Fix for bug that caused a crash if a connector was moved then deleted, before undoing both actions
- Changed handling of overview image
- Fix for possible bug relating to lock focus
- Fix for broken Database SQL View import/export. (file got removed from build target causing failure)
- Changed PostgreSQL view definition query to use pg_views instead of pg_get_viewdef
- Fix for Rails export not exporting indexed or unique properties on fields
- Fix for Rails import failing with add_index
- Fix for broken Rails schema (i.e. not migration) import, because it was looking for a classname which wasn’t present
- Fix for rails not recognizing index type unique on import
Version 2.7.1:
- This version includes improved drag and drop into documents, better PostgreSQL view importing, some rails improvements, fixes for undo, some UI fixes, a fix for a crash relating to the preview window and various other minor improvements.
- Improved file dragging into documents, now you can drag SQLEditor documents,SQL source files and SQLite files directly into the more...
Requirements
Intel, OS X 10.6.8 or later
Intel, OS X 10.6.8 or later
(15)
| Downloads:54,403 |
| Version Downloads:133 |
| Type:Development : Editors |
| License:Demo |
| Date:26 Feb 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
-
-
-
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
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
-1
+38
Kris_nx reviewed on 25 May 2013
+2
+47
Drtyrell969 reviewed on 23 Aug 2010
-6
Trashie reviewed on 26 Feb 2010
+18
+1
+15
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... :)
+15
I'm sure people already knew this, but just in case :)
+11
kiddailey reviewed on 01 Mar 2008
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.
+20
silverdr reviewed on 25 Nov 2006
-1
Anonymous reviewed on 21 Oct 2004
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.
Anonymous reviewed on 18 Oct 2004
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....
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 reviewed on 15 Oct 2004
-1
Anonymous reviewed on 15 Oct 2004
Ronman rated on 30 May 2013
Ronman rated on 18 Feb 2013
Terryr rated on 09 Jan 2012
-6
http rated on 02 Aug 2011
LucasH rated on 25 Apr 2011