SQLEditor
3.6.2Create SQL databases graphically.
Overview
SQLEditor is a SQL database design and entity relationship diagram (ERD) tool for OS X. It replaces typing SQL by hand with dragging, dropping, and clicking, making database creation faster and easier. And if you already have a database, then SQLEditor can help you see what it looks like by reverse engineering a diagram. Or use SQLEditor to create documentation with the new design report exporter. SQLEditor may be useful if you need to design a database or you have existing databases to manage. It's also useful if you're learning about database design.
SQLEditor supports exporting database designs to MySQL, Postgres, SQLite, Oracle, and others. Plus it also imports and exports Ruby On Rails Migration files.
Group License: $349, Single User License $79. Discounts for qualified educational orders.
Note SQLEditor 3 is a paid upgrade from earlier versions. Free upgrades for licenses purchased on or after 1 March 2014.
What's new in SQLEditor
Minimum required Mac OS is now 10.10
New Features
- This release supports Mac OS Catalina / 10.15
- New object visibility menus in toolbar and view menu - show and hide objects by type
- New Help system, should work the same as AppleHelp and contain the same content as before
- New option for comments without visible titlebars
- New command to show only fields that are primary keys in tables
- Now bundles and uses Amazon Corretto Java 11
- New system to save django properties when used
- New preferences panel to edit the saved django properties list
- Updated feedback reporter to newer release from upstream
- Hardened runtime enabled
- First notarized version
- Removed obsolete Java 6 support
- Updated drag and drop code
Fixes
- Fixes for foreign keys where fields are hidden (the line retargets the table header)
- Fix for left sidebar icon drawing on 10.12,10.13
- Fix for potential issue where invalid django properties could render a file unreadable by SQLEditor
- Updated some old code that still used old style alert panel methods
- Removed final parts of Java 6 installation code
- Fix for bug where “Show All Objects” would not show table components that had been hidden
- Fix for incorrect checkmarks in visibility toolbar item menu
- Fix for bug in feedback reporter where tab view labels would disappear
- Feedback reporter now displays the log data in the console tab instead of the script tag
- Warnings about ASL access in feedback system have baeen fixed
- Fixes for some memory management issues
- Fixed some web links that were using http instead of https
- Fixes for new help system search on 10.10 and 10.11
SQLEditor Screenshots
- Intel 64
- OS X 10.10.0 or later
Install with MacUpdateDownloaded & Installed 59,807 times
Apps you might also like
22 SQLEditor Reviews
See allRate this app:
Most helpful
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.