SQLEditor3.7.4

For me it is useful app without any bugs

For me it is useful app without any bugs

How are Rails migrations handled?

Solid app, allowing you to draw ERD diagrams, which get reliably translated into the native script language - SQL or otherwise - of several databases, including: MySQL, PostgreSQL, SQLite, Filemaker, Rails and Django. Able to also connect to several databases and create the ERD diagram on-the-fly, thereby making it somewhat easier to reverse-engineer the data design of existing systems. These features alone make it worth the money.

I will deduct 1 star, however, because the developer has been announcing version 3 for well over a year, making existing users fearful that development has been abandoned. Also, although it is a solid data design tool, it is seriously lacking in the graphics department: the user is given very little control over the graph's appearance - it is impossible to even change the font used in the graphs, let alone change stroke and background colours. More polish on the interface is still needed, as it still looks like a java app programmed by a newbie.

PROS: solid ERD diagramming tool, which reliably produces good database scripts - in SQL as well as in other languages - which is directly usable in a variety of systems.
CONS: very little graphics configuration options - your graphics will all look like java charts from the 1990's. Interface needs polish.

FYI from the Company web page... "SQLEditor 3 is coming soon Buy now and get a free upgrade when it is released"

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

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.

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.

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

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.

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.

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.

For an alternative see DataWerkz by www.uwerkz.com!

I agree with many of the other reviewers that this is a good-to-great start. Some of the things I would like to see from a designers/DBA perspective would be: - ability to change the relationship style to Crow's Feet or at least directional relationship (The F for foriegn key is good, but I would like it to be visible in the relationship. - ability to set cardinality and referential integrity on relationships - ability to set indexes on a table - ability to add views (denoted differently from tables) - ability to add stored procedures - ability to add triggers (when available... see theme comment below) - ability to separate items into multiple SQL sections (e.g. primary keys, foreign keys, procedures, views, etc with ADD/DROP functions being an option). This would drive how the SQL was written and nicely divide (if the user wanted to) constraints from structure, adds, drops, etc. - ability to specify more data types at the application level instead of having to type those in. - ability to set a "theme" for the type of SQL database that would be written to (e.g. MySQL, SQL Server, Oracle, etc.) this would drive optimizations in the SQL in the future. This isn't quite where I could use it yet, but for a 1.0 release and a good set of features to get started, it is something I don't have a Mac tool for this functionality yet. Especially one that writes out SQL. I hope my comments are read as suggestions to improve the product and hopefully drive future features so that you are encouraged to continue development.

Very interesting implementation. Several "wish-list" items include: - ability to set id field to "auto-increment" - ability to re-sort field order by dragging - selection of field type by typing the first characters and having the selection "auto-fill" (e.g., typing "var" auto-completes "VARCHAR(255)"). - ability to designate a field for indexing and full-text indexing Would be wonderful to see in a later version the ability to diagram and existing database live, and after changes are made, to have those implemented to the database.. but that's for a later day, eh? Nice first effort, indeed!

Looking good for a first release - Mac OS X really needs something like this. Not quit 1.0 level yet though, feels more like somewhere around 0.5. That said, looks very promising.

Excellent! This is a very promising start for a visual database schema editor. Sure it's a beta and some features are not yet implemented, but what is working is doing so well for me so I'm giving it a 5 stars for the feature set as it exists on this version. I'm using it without problems on 10.3.2.