Tag: pgmdd

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/

MicroOLAP Database Designer maintenance release v1.10.4 is available immediately

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 is maintenance release which fixes slow Reverse Engineering and Modify Database on some models, improves shell association. Some minor bugs were fixed.

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

Full changelog:
[!] Dramatically increased Reverse Engineering speed
[+] “Add object” menu item is available for Domains and Sequences in the Object Tree View
[*] Manager tool bar is enabled automatically after new model created
[-] “Cannot open model (.pdd) file in Explorer if application already launched” bug fixed
[-] Temporal types have no precision specifier in new domains by default from now

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 meets PostgreSQL 9.4!

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 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

MicroOLAP Database Designer for PostgreSQL v1.10.2 released

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 fixes two exasperating bugs with user interface as well as improves Check Diagram functionality. One should consider to upgrade to this release as soon as possible.

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

Full changelog:
[-] “Access Violation error occurs if Run New Database Wizard option is checked in the Generate Database” bug fixed
[-] “Index fields popup editor deselects all previously checked columns” bug fixed
[*] Check Diagram makes Output and Result List visible
[*] Check Diagram doesn’t show index warnings for tables with PK’s or Unique constraints anymore

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

MicrOLAP Database Designer for PostgreSQL v1.10.0 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.

Improved and enhanced long awaited release is available. It introduces support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed.

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

Full changelog:
[!] SQL Executor and Validator support v9.4 grammar now
[!] Support for table inheritance improved dramatically
[+] “Always make PK columns first” option introduced in Diagram Options
[+] Allow CHECK constraints to be declared NOT VALID in Modify script
[+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
[+] Shortcut for “Save As..” and “Export” menu items added
[+] SQL keywords are properly highlighted according to 9.4 version
[*] Comments now shown at Preview tab of Table Editor by default
[*] Handling of incorrect file paths improved in Generate and Modify Database
[*] Merging of reversed user types with existing in model improved during Reverse Engineering
[-] “Changing domain schema doesn’t affect table representation where domain used” bug fixed
[-] “Changing some options in the Model Options doesn’t activate OK & Apply buttons” bug fixed
[-] “Column default values containing backslashes are corrupted after reloading model” bug fixed
[-] “Leak proof option doesn’t shown in the Function editor after reopen” bug fixed
[-] “LEAKPROOF attribute causes syntax error in the SQL Executor” 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 1.9.2 released

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 is mostly maintenance release fixing many bugs in several areas. Everybody should consider upgrading to this version as soon as possible.

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

Full changelog:
[+] Several models may be passed through command line for opening
[+] Support added for Element property of scalar types
[*] Added missing carriage return at the end of tables statements in the Modify Database script
[*] Error messages improved in the SQL Executor
[*] Find Objects result tree now contains proper images for objects found
[*] Object editor may be open pressing Enter in Find Objects dialog
[*] Opening SQL Executor will create empty model if needed
[*] Processing of tables improved in the Modify Database
[*] SQL parser improved to prevent out of range errors
[*] Statement Error dialog opens at the owner window center from now
[*] Subject corrected for exception tracer messages
[*] Tab order fixed in the Generate and Modify dialogs
[-] “ERangeError occurs when mouse selection area leaves model bounds” bug fixed
[-] “Generate and Modify dialogs: Columns Default Values option is enabled even if Create Table unchecked” bug fixed
[-] “Generate and Modify dialogs: Rules option is enabled even if Create View unchecked” bug fixed
[-] “Index out of bounds possible error prevented for views in Database Modify” subj fixed
[-] “Model file passed through command line (double clicked in Explorer) doesn’t open” bug fixed
[-] “Modify Database produce COMMENT statements even if option unchecked” bug fixed
[-] “Modify Database produce TRIGGER statements even if option unchecked” bug fixed
[-] “Range check error when generating SQL with scalars without in\out functions” 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/