Database Designer for PostgreSQL 1.12.1 is out

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This maintenance release fixes bug with sequence Reverse Engineering and introduces support for PostgreSQL 10.1 minor release.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.12.1 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:

[!] Support for PostgreSQL 10.1 added
[+] "Report bug" functionality added to detailed error dialog
[-] "Column 'min_value' does not exist" Reverse Engineering error fixed
Advertisements

MicroOLAP Database Designer meets PostgreSQL 10!

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This release introduces preliminary support for PostgreSQL v10.

A huge amount of internal and architecture tasks were done either. Updated visual controls used as well as new exception tracer introduced.

Several new sample models were added: “USDA Food database”, “Chinook” and “AdventureWorks for Postgres”. There are many changes and bug fixes.

This slideshow requires JavaScript.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.12.0 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 change log:

  • [!] SQL Executor and Validator support v10.0 grammar now
  • [+] “AdventureWorks for Postgres” model added as sample
  • [+] “Font Color” options added to Display Preferences
  • [+] “Font Color” options added to object editors
  • [+] “Quote Default value” option added for Domain editor
  • [+] Chinook database model added as sample
  • [+] macaddr8 type support added
  • [+] New detailed error dialog introduced for Reverse Engineering
  • [+] PARALLEL option added for stored routines
  • [+] PL/sh procedural language support added
  • [+] PL/v8 procedural language support added
  • [+] SQL keywords are properly highlighted according to 10.0 version
  • [+] USDA Food database model added as sample
  • [*] “Execution interrupted by user” error dialog replaced
  • [*] “Modify process interrupted by user” message box added
  • [*] Copyright info label updated
  • [*] Improved main window position and state restoring for maximized state
  • [*] Old unfancy loader removed
  • [*] Reverse Engineering respects role permissions on sequences now
  • [*] Splash screen updated
  • [-] “‘Rules…’ pop-up menu doesn’t work for tables on diagram” bug fixed
  • [-] “Comments not displayed for views on diagram” bug fixed
  • [-] “Domains with time and timestamp base types were reversed with 0 type modifier, e.g. time(0)” bug fixed
  • [-] “EConvertError during time out for SSH connection” bug fixed
  • [-] “ERangeError after applying some colors to model background” bug fixed
  • [-] “Most Recent Used list of files for Access Import is empty after restart” bug fixed
  • [-] “Rare EAccessViolation during renaming references in the Reference Manager” bug fixed
  • [-] “Some views and stored routines need to be redrawn after Reverse Engineering by Redisplay menu” bug fixed
  • [-] “Universal Reverse Engineering returns empty model for sources with schemas” bug fixed

Meet the MicroOLAP Database Designer for PostgreSQL 1.11.3

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This release improves user experience allowing hide unneeded objects. Adds option to not run executor after database generation or modification. Allows run default application associated with .sql files. Fixes two nasty bugs.

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

Full changelog:
[+] “Don’t run, just save” option added to Generate and Modify
[+] “Run default application associated with .sql files” option added to Generate and Modify
[+] Hide\Show objects functionality added
[*] String constants highlighted blue in SQL scripts
[*] UUID type is highlighted as type in SQL scripts
[-] “ERangeError during CHECK constraint editing” bug fixed
[-] “Model name not properly loaded from file” bug fixed

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

MicroOLAP Database Designer for PostgreSQL release v1.11.1 is out!

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This release adds long-awaited functionality for reference (foreign key) custom points and fixes several non-critical display bugs. Check screenshots for details.

On screenshots we may see how one note hides the reference. However we can get around the note. Just add one more routing point to the reference.
Also we can move reference label to any position from now. And of course we can move reference tails and pick exactly place where they adjusted to the table.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.11.1 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:

  • [!] Reference label position can be changed by user now
  • [!] User can add, move and remove custom points of references now
  • [!] User can move the start and the finish points of references now
  • [-] “Cannot turn off Snap to Grid” bug fixed
  • [-] “Cannot turn off Show Grid” bug fixed
  • [-] “Index list out of bounds” rare display bug fixed

MicroOLAP Database Designer meets PostgreSQL 9.5!

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This minor release introduces support for upcoming PostgreSQL 9.5 and provides new SSH tunneling facility out of the box. Several bugs were fixed as well.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.11.0 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 change log:

  • [!] PostgreSQL 9.5 support added
  • [!] Brand new SSH tunneling introduced
  • [!] BRIN indexes support added
  • [!] SPGIST indexes support added
  • [*] “Cannot populate environment settings” message now more descriptive
  • [-] “Default value for domain contains newline character if edited with advanced SQL Editor” bug fixed
  • [-] “Rare Access Violation error during application close” bug fixed
  • [-] “Secutiry type value incorrect in Stored Routine Manager” bug fixed
  • [-] “SSL connection options ignored sometimes” bug fixed
  • [-] “Stored routine Window function option may have incorrect value after reopening model” bug fixed
  • [-] Rare EExternalException errors fixed

MicroOLAP Database Designer for PostgreSQL 1.10.6 available

PgMDD boxThe MicroOLAP team is proud to introduce Database Designer for PostgreSQL, an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ 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 the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

New release introduces enhanced support for Windows 10 and optional anonymous statistics functionality.

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

Full changelog:
[!] Anonymous statistics module added (optional)
[!] Enhanced Windows 10 support by new compiler introduced
[*] Performance optimizations in error logging
[-] “EAccessViolation (Bug B21C0000) after reference deletion” bug fixed
[-] “Range check error in processes information for x64 machines” bug fixed

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