PostgresDAC 3.4.0 is out! #BlackFriday

Microolap Technologies is pleased to announce the availability of PostgresDAC 3.4.0.

Take a 30% discount on any of our products and subscriptions!
Just use #BlackFriday code on any order page.

This new minor version introduces support for the latest PostgreSQL and OpenSSL libraries. Support for NEXTGEN and Lazarus (FreePascal) compilers improved.

Full change log:
[!] v10.1 client libraries added
[!] v10.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[!] Lazarus 1.6.4 support introduced
[!] OpenSSL 1.1.0g support added
[*] Improved ARC support for NEXTGEN compilers
[+] dsoNumericAsFloat option added to TPSQLDataset options
[-] “TPSQLDatabase.KeepConnection set to False may leave active connections on Android” bug fixed

You’re welcome to download the PostgresDAC v3.4.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/

Advertisements

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

Serial-Identity mix

Serial-identity
Serial-identity
As you probably know PostgreSQL 10 introduced IDENTITY columns. They are pretty much like serial columns from the first sight. To learn about differences one may refer to the perfect blog post by Peter Eisentraut.

So I was wondering what if I mix some serial with some identity. So I executed such simple query:

CREATE TABLE foo(
id SERIAL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
);

Of course, I got an error:

ERROR: both default and identity specified for column "id" of table "foo"
SQL state: 42601

“SQL state: 42601” stands for a syntax error. But the interesting thing is that SERIAL, as you know, converted to CREATE SEQUENCE and SET DEFAULT.

So now I know what exactly the reason of error. You cannot have both DEFAULT and IDENTITY for a column.

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

PostgresDAC 3.3.0 meets PostgreSQL 10!

Microolap Technologies is pleased to announce the availability of PostgresDAC 3.3.0.

PostgresDAC 3.3.0 introduces support for PostgreSQL 10 – a major new version of the world’s most advanced Open Source database.

Full change log:
[!] v10.0 client libraries added
[!] v10.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[!] PostgresDAC components are enabled on IDE Component pallette for all platforms from now
[+] doNoPublications option added to TPSQLDump.Options
[+] doNoSubscriptions option added to TPSQLDump.Options
[+] doNoSync option added to TPSQLDump.Options
[+] roNoPublications option added to TPSQLRestore.Options
[+] roNoSubscriptions option added to TPSQLRestore.Options
[-] Сrash fixed in TPSQLRestore when using parallel mode and using a list file to select a subset of items

You’re welcome to download the PostgresDAC v3.3.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/

PostgresDAC 3.2.2 meets RAD Studio 10.2 Tokyo!


The MicroOLAP team is proud to announce the release of PostgresDAC v3.2.2 which includes RAD Studio 10.2 Tokyo and Linux target platform support and several bug fixes and improvements.

Full change log:
[!] RAD Studio 10.2 Tokyo (Delphi and C++ Builder) support introduced
[!] Linux target platform support added
[*] Additional check added for TPSQLDatabase global list existence in finalization

You’re welcome to download the PostgresDAC v3.2.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.2.1 is out


The MicroOLAP team is proud to announce the release of PostgresDAC v3.2.1 which contains the latest PostgreSQL 9.6.1 client libraries as well as fixes rare bug.

Full change log:
[!] v9.6.1 client libraries added
[!] v9.6.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[+] TPSQLDatabase.LibraryVersionAsInt property added
[-] Fixed the “End of table” error which appeared after Refresh call for empty result sets

You’re welcome to download the PostgresDAC v3.2.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/