SQL Object - PostgreSQL Data Access Components (PgDAC)

Specification:   Base components Script Executing Fast data loading into the server   Database Activity Monitoring     Monitoring of per-component SQL execution   PostgreSQL Specific Components     Messaging between ... sessions and applications Obtaining metainformation about database objects Storing a database as a script   Additional Components     Advanced connection dialog Data encryption and decryption Data storing ...

Release Notes: Adds support for PostGIS plus improves 'TimeZoneOffset' support. Added support for Embarcadero RAD Studio 11 Alexandria Release 2. Added support for Lazarus 2.2.2. Added support for Apple iOS 15. Added support for Android 12. Added support for PostGIS. Query and Table components add

Release Notes: Added support for Lazarus 3.0. Improved working with column default values. Improved working with RefreshRecord queries. Improved working with arrays in queries. Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block.". Fixed bug with

Release Notes: for PREPARE/EXECUTE commands. Added support for nested macros in SQL queries. Added Display Format for Aggregate fields. Added support for SHA-2 (SHA-256, SHA-512) in hash encryption algorithms. Fixed bug ...

Release Notes: Adds support for PostgreSQL 15 and improves process of getting extended field info. Added support for Embarcadero RAD Studio 11 Alexandria Release 3. Added support for Apple iOS Simulator target platform. Added support for Lazarus 2.2.6. Added support for PostgreSQL 15. Added support for YEAR, ...

Description: using PostgreSQL data access components. dbMonitor performs per­-component tracing of SQL statement execution, commits, rollbacks, etc. The Standard edition includes the PgDAC basic connectivity ...

Release Notes: Adds support for SCRAM-SHA-256-PLUS authentication mechanism. Added support for Embarcadero RAD Studio 11.1 Alexandria. Added support for Lazarus 2.2.0. Added support for Microsoft Windows 11. Added support for Apple macOS Monterey. Added support for SCRAM-SHA-256-PLUS authentication mechanism. ...

Release Notes: Adds support for PostgreSQL 14 along with PoolId connection option. Added support for PostgreSQL 14. Added stored procedure OUT parameters in PostgreSQL 14. Added PoolId connection option. Fixed bug with Access Violation on RefreshRecord after connection switching. Fixed bug with application name ...

Release Notes: with error when setting the "0" value for a currency field. Fixed bug with automatic conversion of null values from SQL subqueries to default values. Fixed bug with processing IDENTITY fields ...

Release Notes: Adds support for TFieldOptions. Added support for TFieldOptions. Fixed bug with executing a stored procedure when ProtocolVersion = pvAuto. Fixed bug with executing a "SELECT FROM..." statement. Fixed bug with a "Range check error" exception when executing a statement with ...

Release Notes: Demo compatibility with new a version of SecureBridge has been fixed. Fixed bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True. Fixed bug with reading server messages. ...

Release Notes: opening a form containing a SQL component. Fixed a bug with LockMode = lmPessimistic. Fixed a bug with the ConvertEOL connection option. Fixed a bug with AV in applications using DBMonitor. Fixed a bug ...

Release Notes: a "SELECT FROM..." statement. Fixed bug with AV when executing a batch operation via the SQL component. Fixed bug with incorrect encoding of error messages. Fixed bug with reading BLOBs on mobile ...

Release Notes: Release 1 is now required for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney and C++Builder 10.4 Sydney. Fixed the incompatibility of DatasetManager with RAD Studio 10.4 Release 1. ...

Release Notes: Adds support for Lazarus 2.0.10 and Free Pascal Compiler (FPC) 3.2.0. Added support for Lazarus 2.0.10 and Free Pascal Compiler (FPC) 3.2.0. Improved the performance of Batch Insert, Update and Delete operations. ...

Licensing Fact Sheet:   ...

Release Notes: Adds support for RAD Studio 10.4 Sydney. Added support for RAD Studio 10.4 Sydney. Added support for Lazarus 2.0.8. Added support for macOS 64-bit in Lazarus. Added support for line geometric type. ...

Release Notes: the Alerter component. Fixed bug with an incorrect value of the RowsAffected property when executing an INSERT... RETURNING statement. Fixed bug with SQL statements that contain fields with the same name from ... different tables. Fixed bug executing SQL statements that contain comments using the Script component. Fixed bug resetting the value of the parameter after adding a new TDACondition. Fixed bug reading a field ...

Release Notes: Adds support for 64-bit Android app development and PostgreSQL 12. Support for Android 64-bit. Support for Lazarus 2.0.6. Support for PostgreSQL 12. Support for OpenSSL 1.1 library. ...

Release Notes: Adds support for macOS 64-bit. Added support for macOS 64-bit. Added TPgConnectionSSLOptions.IgnoreServerCertificateInsecurity property. ...