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.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
Intel, OS X 10.6.8 or later
(15)
| Downloads:54,580 |
| Version Downloads:92 |
| 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
-
-
-
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
+40
Kris_nx reviewed on 25 May 2013
+2
+48
Drtyrell969 reviewed on 23 Aug 2010
-6
Trashie reviewed on 26 Feb 2010
+18
+1
+16
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... :)
+16
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
-7
http rated on 02 Aug 2011
LucasH rated on 25 Apr 2011