MicroOLAP Database Designer meets PostgreSQL 9.4

Posted on 2014-12-23 by Microolap

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with full support for PosgreSQL 9.4, an comprehensive CASE tool with intuitive graphical interface allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from a server,
  • export diagram to common graphic formats or as SQL script,
  • create detailed printings and reports.

This release introduces support for the latest v9.4 SQL grammar. Among other important features JSONB type support were added. Modify Engine allows creating indexes CONCURRENTLY. Several non critical bugs fixed.

Download

You're welcome to download the Database Designer for PostgreSQL 1.10.3 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:

  • [!] PostgreSQL 9.4 support added
  • [+] Allow creating indexes CONCURRENTLY using Modify script
  • [+] JSONB type support added
  • [*] Primary column removed from Column Manager
  • [*] Support for ENUM types improved in Column Manager
  • [*] uuid[] type added to editors
  • [-] "Quote Default Value option not saved in Column Manager" bug fixed