Tag: PostgreSQL

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/

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

PostgresDAC 3.0.4 is immediately available


The MicroOLAP team is proud to announce the release of PostgresDAC v3.0.4. This release introduces support for latest PostgreSQL version, extends payload by adding new TPgSSHDatabase implementation, improves dump and restore machinery, fixes all known bugs.

Full change log:
[!] TPgSSHDatabase supports plink.exe binary for creating tunnel from now
[!] v9.4.5 client libraries added
[!] v9.4.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[*] libpq’s handling of out-of-memory conditions improved
[*] More informative error message introduced if login prompt absent
[*] Support for shell types (not fully defined) to TPSQLDump added
[*] Temporary files created during a TPSQLDump run with tar-format output are not world-readable now
[*] TPSQLDump handles inherited NOT VALID check constraints correctly
[*] TPSQLDump handles object privileges sanely when dumping from a server too old to have a particular privilege type
[*] TPSQLDump supports cases where the postgres or template1 database is in a non-default tablespace
[*] Unit PSQLGeomTypes implicitly included into package warning eliminated for pre-Delphi12 compilers
[*] Win64 platform added to RAD Studio 10 Seattle package
[-] “Setting bookmark on the last row may corrupt result set after reopening dataset” bug fixed
[-] Assorted minor memory leaks in TPSQLDump fixed
[-] EIntOverflow error eliminated if dsoUseGUIDField included in dataset options
[-] Selection of default zlib compression level in TPSQLDump’s directory output format fixed

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

Easy PostgreSQL docs for Sublime Text

I’m using this perfect tool called Sublime Text 3 for a bunch of tasks. One of them is viewing SQL scripts from time to time. ST3 has perfect SQL highlighting, but what I miss the most is the context help functionality, e.g. I select “LEFT JOIN” and hit F1 hot key. But that’s not problem since ST3 has a lot of packages. To solve my problem I need GotoDocumentation package and some tuning. Here is my settings for GotoDocumentation:

{
"docs": {
// obj containing the docs for each scope
// these are merged with the default ones
// the key value pair represent scope -> doc url
// supported placeholders:
// - %(query)s the selected text/word
// - %(scope)s the current scope
"sql": "http://www.postgresql.org/search/?q=%(query)s"

"pascal": "http://docwiki.embarcadero.com/Libraries/Seattle/en/Special:Search/%(query)s",
},
// if we have no docs for the current scope
// we will try using the fallback one,
// to disable set to false
"fallback_scope": "google"
}

ST3 context help  for pg sql
ST3 context help for pg sql

Creating titles from text (SQL)

Task: get title (or excerpt) from given text (body)
Solution:

SELECT
left(body, 29) ||
COALESCE( substring( substr( body, 30 ) from '(.+?)(\,| )' ), '' ) as title,

Details: Take the first 29 characters, concatenate them with substring started from the 30-th character till the first occurrence of comma or space. Or concatenate with empty string, if pattern doesn’t match (COALESCE).

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/

PostgresDAC 3.0.3 meets RAD Studio 10 Seattle!

Full changelog:

[!] Package for RX10 Seattle added
[-] Incompatibilities of C++ Builder and geometrical types fixed
[-] “Not a valid timestamp error when using ClientDataset/AppServer” bug fixed
[-] “Underscore in stored routine name is treated as wildcard symbol and break Overload property value” bug fixedmetrical types fixed.

You’re welcome to download the latest release 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/