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
Advertisements

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/

Meet the MicroOLAP Database Designer for PostgreSQL v1.9.1!

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 provides new functionality as well as improves existing one. Materialized views support added. Modify Database engine improved. User interface tuned up.

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

Full changelog:
[+] Case insensitive name comparing option added to Modify Database
[+] Materialized views support added
[+] Recursive views support added
[+] Width and Height properties displayed for the selected object in the status bar from now
[*] Calculations for objects width improved
[*] Comparison of function parameters improved in the Modify Database
[*] Generate and Modify dialogs now allow change file name if it’s already exist after confirmation cancelling
[*] Modify Database shows “No modification found” dialog now instead of empty “Execute SQL Query” dialog
[*] Processing of views improved in the Modify Database
[-] “Cannot create objects with the same name but different text case” bug fixed
[-] “Column Manager may change fields order if list column was sorted” bug fixed
[-] “Modify Database doesn’t produce DROP VIEW statements even if option is selected” bug fixed
[-] “Schema and name separator is missing in ALTER TABLE RENAME statements in Modify scrpits” bug fixed
[-] “Select\Deselect All buttons don’t work for Stored Routines list in the Database Generation and Modify dialog” 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/

MicrOLAP Database Designer for PostgreSQL v1.9.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 internal and architectural improvements. New compiler used as well as new exception tracer implemented. Some little changes and bug fixes are present too.

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

Full changelog:
[!] New compiler used in development
[!] New exception tracer tool used
[-] “Designer doesn’t restore itself to maximized state after restart” bug fixed
[-] “Modify Database ignores output script character case option” bug fixed
[-] “Reverse Engineer warns that diagram is not empty even though it clearly is” 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 v1.9.0 Beta is out!

PgMDD boxDatabase Designer for PostgreSQL is an easy CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ.

This release does not introduce any new functionality. A huge amount of internal and architecture tasks were done instead. New compiler version used as well as new exception tracer implemented. Some little changes, not worthy of mention, are also present, e.g. standard Color Dialog etc.

There are two new major features in this release as compared to previous:

  • [!] New compiler used in development
  • [!] New exception tracer tool used

Please test v1.9.0-Beta thoroughly. We depend on your bug reports and feedback in order to proceed to final release.

The more testing you do, the sooner 1.9.0 will be available.

If you have some spare time to help us with testing, please visit MicroOLAP Database Designer for PostgreSQL Download page at
http://microolap.com/products/database/postgresql-designer/download/.

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

P.S. Beta releases should never be used in production; they are for testing purposes only.