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

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

PostgresDAC 3.1.3 is released


The MicroOLAP team is proud to announce the release of PostgresDAC v3.1.3 which fixes a bug for dsoRefreshModifiedRecordOnly mode and improves positioning after Post for some queries.

PostgresDAC v3.1.3 is mostly maintenance release.

Full change log:
[*] Local positioning improved for TPSQLQuery with RequestLive after Post
[-] Work with NULL values fixed in dsoRefreshModifiedRecordOnly mode

You’re welcome to download the PostgresDAC v3.1.3 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC meets RAD Studio 10.1 Berlin!

PostgresDAC v3.1.2 with support for RAD Studio 10.1 Berlin (both Delphi and C++ Builder), Lazarus 1.6 and FreePascal 3.x is available immediately!

Full change log:
[!] Support for RAD Studio 10.1 Berlin (Delphi and C++ Builder) introduced
[!] Support for Lazarus 1.6.0 added
[!] Support for FreePascal 3.0.0 added
[+] Ctrl+A functionality added for TPSQLQuery edit form

You’re welcome to download the PostgresDAC v3.1.2 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.1.1 is out


The MicroOLAP team is proud to announce the release of PostgresDAC v3.1.1 which updates client libraries used and fixes some rare bugs.

PostgresDAC v3.1.1 is mostly maintenance release. Most notably this release fixes errors with TPSQLDump and TPSQLRestore components.

Full change log:
[!] v9.5.1 client libraries added
[!] v9.5.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[*] Avoid dump/reload problems when using both plpython2 and plpython3
[*] Make TPSDump mark a view’s triggers to be processed after its rule, to prevent possible failure during parallel restore
[-] “Improper quoting of domain constraint names in TPSQLDump” bug fixed
[-] “TPSQLTable.FindKey fails for two-column unicode varchar index” bug fixed
[-] Assorted corner-case bugs in TPSQLDump’s processing of extension member objects fixed

You’re welcome to download the PostgresDAC v3.1.1 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.1.0 meets PostgreSQL 9.5!

Support for PostgreSQL 9.5 added.

Full change log:
[!] v9.5.0 client libraries added
[!] v9.5.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[+] “EPSQLDatabaseError.ErrrorXXX properties contain old values in some scenarios” bug fixed
[+] doEnableRowSecurity option introduced for TPSQLDump.Options property
[+] doIfExists option introduced for TPSQLDump.Options property
[+] roEnableRowSecurity option introduced for TPSQLRestore.Options property
[+] roIfExists option introduced for TPSQLRestore.Options property
[+] TestSSLConnect case added for TPSQLDatabase unit test
[+] tiSERIALIZABLE option added for TPSQLDatabase.TransIsolation property value
[+] TPgSSHDatabase.AddSSHKeyToSystemCache property added
[+] TPgSSHDatabase.ShowPLinkConsole property added
[+] TPSQLDatabase.Assign implemented
[+] TPSQLDump.Snapshot property introduced
[*] More informative message introduced for TPgSSHDatabase connection errors
[*] PSQLMetadata unit excluded as deprecated
[*] TPSQLStoredProc.RefreshParams now throws exception if connection error occurred
[-] “Error code in TPSQLDatabase.StartTransaction ignored” bug fixed

You’re welcome to download the PostgresDAC v3.1.0 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/