Release notes for ODBC Driver for PostgreSQL

Version 5.0

  • Added a graphical interface for configuring the driver on macOS and Linux.
  • Added support for PostgreSQL 18.
  • Added support for the Bearer Token authentication when using the HTTP tunnel.
  • Improved performance of opening connections.
  • Improved compatibility with Node.js.
  • Improved compatibility with Tableau.
  • Improved compatibility with Vectorworks.

Version 4.7

  • Added support for password-protected private keys for the SSL protocol.
  • Improved compatibility with Microsoft Query.

Version 4.6

  • Added support for PostgreSQL 17.
  • Added support for the pgvector extension.
  • Added the read-only mode for the connection.

Version 4.5

  • Fixed connection timeout setting before opening a connection.
  • Improved compatibility with FileMaker Server on Ubuntu.
  • Improved compatibility with FileMaker Server on MacOS.
  • Added support for PostGIS.
  • Added support for the SQL_ATTR_MAX_ROWS attribute.
  • Improved compatibility with Visual Basic in Visual Studio.
  • Improved compatibility with 4D on macOS.

Version 4.3

  • Added support for PostgreSQL 15.
  • Added support for macOS 13 Ventura.
  • Added support for the SCRAM-SHA-256-PLUS authentication mechanism.
  • Improved compatibility with Tableau Prep Builder.
  • Improved compatibility with Crystal Reports.
  • Improved the SSH connection establishment.

Version 4.2

  • Added support for Windows 11.
  • Added support for PostgreSQL 14.
  • Added support for OUT parameters in stored procedures in PostgreSQL 14.
  • Improved compatibility with PostgreSQL 8.1 and 8.2.
  • Improved compatibility with FICO Mosel.
  • Improved compatibility with FileMaker.
  • Improved compatibility with JMP on macOS.
  • Improved support for an ODBC installer on Windows 2000.

Version 4.1

  • Added MSI installer for deployment via Group Policy (GPO).

Version 4.0

  • Added support for Apple Silicon M1.
  • Improved compatibility with macOS Big Sur.

Version 3.4

  • Add support for PostgreSQL 13.
  • Improved compatibility with Clarion Enterprise.

Version 3.3

  • Added support for materialized views.
  • Improved compatibility with Power Pivot.
  • Improved compatibility with Visual Basic.
  • Improved compatibility with RStudio.

Version 3.2

  • Added support for PostgreSQL 12.

Version 3.1

  • Added support for Amazon RDS for PostgreSQL.
  • Added support for password-protected private keys for the SSH protocol.
  • Added the possibility of activation of the ODBC driver without administrator privileges.
  • Improved compatibility with sandboxed applications on macOS.
  • Improved support for connection pooling.

Version 3.0

  • Added macOS distribution of the ODBC driver as a PKG package.
  • Added Linux distribution of the ODBC driver as DEB and RPM packages.
  • Added the possibility of forcing the ODBC 2.x behavior.

Version 2.3

  • Improved performance of batch operations.
  • Added the SSHStoragePath connection parameter.
  • Added support for the use of “?”, “?|” and “?&” JSON operators in SQL statements by escaping the question mark character (“\?”, “\?|” and “\?&” respectively).

Version 2.2

  • Added support for PostgreSQL.
  • Added support for Azure Database for PostgreSQL.
  • Improved compatibility with SAS JMP.
  • Improved compatibility with MS Power Query.
  • Added support for the OUTER JOIN macros in SQL queries.
  • Added support for the DateTime macros in SQL queries.
  • Added support for the Scalar function macros in SQL queries.

Version 2.1

  • Added compatibility with MS Visual Studio.
  • Improved compatibility with MS FoxPro.
  • Improved compatibility with MapInfo.
  • Improved compatibility with Libre Office.
  • Improved compatibility with Qlik.
  • Improved compatibility with Delphi & C++Builder.
  • Improved support for MS Access linked tables.
  • Added support for the SELECT ... FOR UPDATE statement.

Version 2.0

  • Added support for Linux.
  • Added support for macOS.
  • Improved support for stored procedures and functions.
  • Improved backward compatibility of SQLExecDirect with ODBC 2.x.
  • Improved compatibility with MS Excel.
  • Improved compatibility with ODBC 2.x.
  • Fixed the Trial expiration in Microsoft SQL Server Management Studio.
  • Improved support for server versions 7.3-8.3.
  • Fixed fetching a large amount of data.

Version 1.3

  • Added support for the connection via the SSL protocol.
  • Added connection via the SSH protocol.
  • Added connection via the HTTP tunnel.
  • Improved compatibility with Power BI Desktop.
  • Improved compatibility with Microsoft Visual FoxPro.

Version 1.2

  • Improved compatibility with Microsoft Visual Studio.
  • Improved compatibility with Microsoft Office.
  • Improved compatibility with Microsoft SQL Server Management Studio.
  • Improved compatibility with Crystal Reports.
  • Improved compatibility with ClikView.

Version 1.1

  • Improved performance.

Version 1.0

  • First release of Devart ODBC Driver for PostgreSQL.
  • Added support for:
    • Windows 32-bit
    • Windows 64-bit