(13)
Your rating: Now say why...
- Download Now
4.5 MB -
Visit Developer's Site
MalcolmHardie Solutions Limited
SQLEditor is a SQL 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 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
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
What's New
Version 1.7.14:
- Fix for 10.4 compatibility
- Fix for parsing single alter table with multiple foreign key instructions
- Parser now supports both TIMEZONE and TIME ZONE for relevant time types
- Parser add support for some missing data types (including CURSOR)
- Parser better handling of keywords that are also identifiers
- Parser better handling of intervals for postgres and oracle
- fix for YEAR keyword with and without PRECISION
- fix for DOUBLE keyword and PRECISION keyword
- fix for some other keywords that weren't reliably recognized.
Version 1.7.14:
- Fix for 10.4 compatibility
- Fix for parsing single alter table with multiple foreign key instructions
- Parser now supports both TIMEZONE and TIME ZONE for relevant time types
- Parser add support for some missing data types (including CURSOR)
- Parser better handling of keywords that are also identifiers
- Parser more...
Requirements
PPC / Intel, Mac OS X 10.5 or later
PPC / Intel, Mac OS X 10.5 or later
SQLEditor User Discussion (Write a Review)
Overall:
(13)
(13)
| Downloads:48,072 |
| Version Downloads:262 |
| Type:Development : Editors |
| License:Shareware |
| Date:23 Jan 2012 |
| Platform:PPC / Intel |
| Price: $79.00 |
Overall (Version 1.x):  |
| Features: |
Ease of Use: |
| Value: |
| Stability: |
Displaying 1-10 of 15
-
-
-
SQLEditor is a SQL 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 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
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
Copyright © 2012 MacUpdate LLC
- -
+1
+44
Drtyrell969 reviewed on 23 Aug 2010
+17
Trashie reviewed on 26 Feb 2010
+18
+1
+13
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... :)
+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.
+19
silverdr reviewed on 25 Nov 2006
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
Anonymous reviewed on 29 Sep 2004
And, by the way, don't knock Macs because 'MonopolySoft' doesn't port their software to other platforms. Don't kid yourself, Macs can certainly handle it.
-1
Yes I mean Inferior exactly like my spelling ability. My spelling sucks, just like database apps for the Mac. Good example man. I'm proud of you. If spelling is your foundation for a good argument or a defense, you have a severe problem my friend.
I'm a die hard Mac user & am not knocking Apple itself in the slightest way. I never said anything in my post that would indicate that I was. I dont even own a Wintel box. As good as the OS envoronment is, the support for databases SUCKS. The ODBC Admin utility is largely useless as well as there being a severe lack of ODBC compliant applications for OS X.
Am I knocking MySQL? Ummm... yeah, actually I am. Sorry dude, market share doesn't equal quality. There is no easy way to install, configure, and administrate the application. Its largely command line, half the distributions require the end user to compile the stupid thing themsleves. Half the GUI front ends require a web server and PHP to run. I have yet to see a front end app that allows you to create and edit tables, fields stored procedures & relationships by dragging & connecting fields in tables. It supports fewer concurrent connections (at least it did last time I looked into it) than either Postgres SQL or SQL Server 2000. When I did Install it it I had to have an additional user on my laptop just to give MySQL an identity, which may be trivial but is just annoying to me. Overall its fine for epople that want to spend a bunch of time fighting with it, but I am far too busy to want to do command line work on a regular basis, let alone train anyone else to do it.
FURTHERMORE, many companies require SQL Server for other reasons. The BlackBaud fundraising software for example requires a SQL Server back end. MySQL is useless to me in that instance. Mac's offer very few solutions to administer SQL Server and those options are pricy & still incomplete.
As far as it MySQL being the most popular DB out there. Duh... its FREE. Same reason Apache is the most popular. Microsoft has the most widely distributed OS. You planning on switching to Windows soon? By your logic it MUST be better.
When push comes to shove yeah MySQL does a fine job & I wouldn't have any problem using it if it were even slightly conveniant, but the inconveniance of the app is rediculous & entirely antequated for anyone but the Unix geeks out there. I bought a MAC, the system that popularized the GUI. I dont want to Muck about with SQL statements & command line garbage. Now granted DB work isn'[t my full time thing so I dont know all the ins & outs, but thats the point. I need an app that doesn't require me to learn more. I have too much to have to keep up with as it is.
Might I recommend an intelligent argument next time rather than resorting to something as inconsequential as spelling or typos? And dont get your panties ina wad just because there are a few things that Microsoft really does do better for now.
"I dont give a d@mn for any man that can only spell a word one way" - Mark Twain
C: "...don't knock Macs because 'MonopolySoft' doesn't port their software to other platforms. Don't kid yourself, Macs [could] certainly handle it."
10 decimeters.
A: "...yeah MySQL does a fine job & I wouldn't have any problem using it if it were even slightly convenient"
100 millimeters.
A: "Might I recommend an intelligent argument next time rather than resorting to something as inconsequential as spelling or typos?"
0.01 decameters
A: "(High profile) ...Customers ...are realizing significant cost savings by using MySQL's high performance, reliable database management software..."
0.001 kilometers.
And the winner is...
Terryr rated on 09 Jan 2012
-10
Marcello_Mr rated on 21 Oct 2011
http rated on 02 Aug 2011
LucasH rated on 25 Apr 2011