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.

MicrOLAP Database Designer with PostgreSQL 9.2 support is out!

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

In this release we focused on changes in the 9.2 version of the PostgreSQL server:

  • Support for new JSON, SMALLSERIAL and range types introduced.
  • Internal SQL parser improved a lot and is fully compatible with PostgreSQL SQL dialect.
  • Collation support for tables introduced as well.
  • LEAKPROOF stored routine specification is supported from now, as well as security_barrier option added for views.
  • And of course all known bugs are fixed.
    Download

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

    Full changelog:

    [!] Color Palette customization ability added
    [!] User Type and Domain selection tab added to reverse Engineering dialog
    [+] COLLATION support for table columns added
    [+] COMMENT clauses now proccessed by SQL Reverse Engineering
    [+] JSON type support added
    [+] Support for built-in range types added (INT4RANGE, INT8RANGE, NUMRANGE etc.)
    [+] LEAKPROOF function specification added
    [+] security_barrier option added for views
    [+] SMALLSERIAL data type added
    [*] “Import from SQL Script” dialog allows to edit script if error occured
    [-] “SQL Reverse Engineering cannot import function with argument of anyelement type” bug fixed
    [-] “SQL Reverse Engineering cannot import function with name Op” bug fixed
    [-] Random “List index out of bounds” error fixed during Reverse Engineering of enum types
    [-] “Cannot clear CHECK clause for DOMAIN in the UDT Editor” bug fixed
    [-] “Drag-and-drop multiple selected items causes all to go in top left hand corner” bug fixed
    [-] “Reverse Engineering of tablespaces broken in PostgreSQL 9.2” bug fixed
    [-] “Temporary property of views is not saved” 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 with PostgreSQL 9.1 support 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 introduces new functionality as well as several bug fixes. Support for PostgreSQL 9.1 added, new Create HTML Report functionality present, unlogged tables support added, Database Generation and
Modification dialogs improved.

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

Full changelog:

[+] Name patterns for newly created objects supported
[+] Object selection added to Create HTML Report dialog
[+] Support for unlogged tables using the UNLOGGED option added
[*] Additional checks added for dependent composite types during model loading
[*] Improved processing for fields deletion with referenced foreign keys in Modify engine
[*] Syntax highlighting improved for base types
[-] “Access violation on Privilege Manager Add button click” bug fixed
[-] “Cannot cast type text[] to text error during Reverse Engineering on pre-8.2 servers” bug fixed
[-] “EInvalidCast error occurs during deletion of domain in Domain & UDT Manager” bug fixed
[-] “Relation ‘pg_users’ does not exist during Reverse Engineering on pre-8.1 servers” bug fixed
[-] “Some sequences may not be generated using Generate Database dialog” bug fixed
[-] “Stamp colors are not saved” bug fixed
[-] “Stored Routine Editor disallows non-Latin character in routine name” 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/