On 02/01/2017 01:35 PM, Greg Slawek wrote: > > Can anyone recommend a data modeling tool (preferably Mac OSX compatible)? > > I would like to be sure it can export version specific SQL code (ie 9.1 vs > 9.4) > <snip>
I'm very happy with pgmodeler, which I picked up about 6-8 weeks ago. It's an open source / paid bundle Qt-based app (so in C++) which I'm running on OpenSuSE 42.2 / KDE. See the web site of same name, and associated GITHub project. AIR, "version specific" DDL generation is a backlog item or partially implemented. Over all, there are some gaps in function compared to what I'd like, and occasional fit and finish, BUT it's on par with any of the modeling tools, including commercial, I've seen over the years, and better than most. (I've never seen a modeling tool that did everything I'd like, or even robustly did everything it claimed.) YMMV - I'm using my design / build effort to get hands' on with postgreSQL's distinctive features, so haven't exercised pgmodeler over the whole scope of what it could model and maintain. -- Jim Bullock, Rare Bird Enterprises, "Conscious Development" LinkedIn: http://www.linkedin.com/in/rarebirdenterprises Listen to a round table of experts in these books from Dorset House: Roundtable on Project Management, http://www.dorsethouse.com/books/rpm.html Roundtable on Technical Leadership, http://www.dorsethouse.com/books/rtl.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
