What's New

New Features in PgDAC 9.0

Added support for RAD Studio 13 Florence
Added support for Lazarus 4.2
Added support for Bearer Token authentication when connecting through HTTP tunnel
Added support for system proxy settings to the TProxyOptions class for HTTP tunnelling
Added the Pooled function to the TCustomDAConnection component
Added support for ReportBuilder 23 in the demo project
Improved support for array data types
Improved connection opening performance

New Features in PgDAC 8.4

Added support for RAD Studio 12 Athens Release 3
Added support for the RAD Studio 64-bit IDE
Added support for Lazarus 3.8
Added support for PostgreSQL 17
Added support for the COPY ... TO STDOUT statement
Added support for parameters in the Script component
Added support for the TurboPack SynEdit package in component editors
Added support for syntax highlighting in component editors in Lazarus on the Windows platform
Added the IndentFormat argument to the SaveToXML method of the dataset to decrease file size
Added the SaveToJSON method for serializing a dataset to the JSON format
Added the ability to use readonly fields in the SQL Generator at design-time
Added support for password-protected private key for SSL protocol
Improved TPgDump performance
Improved work with design-time editors in the High DPI mode

New Features in PgDAC 8.3

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.6
Improved performance
Added C++Builder demo components for working with SecureBridge
Added the WriteBOM property for TPgDumpOptions
Added support for the pgvector extension
Added the UseGeneratedColumns property for TPgDataSetOptions

New Features in PgDAC 8.2

Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Improved work with generated fields
Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required

New Features in PgDAC 8.1

Lazarus 3.0 is supported
Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries

New Features in PgDAC 8.1

Lazarus 3.0 is supported
Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries

New Features in PgDAC 8.0

Added support for RAD Studio 12
Added support for PostgreSQL 16
Added support for macOS Sonoma
Added support for iOS 17
Added support for Android 13
Added support PREPARE/EXECUTE commands
Added support for nested Macros in SQL queries
Added support Display Format for Aggregate fields
Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption

New Features in PgDAC 7.3

Added support for RAD Studio 11 Alexandria Release 2
Added support for Lazarus 2.2.2
Added support for iOS 15
Added support for Android 12
Added support for PostGIS
Added the CloneCursor method for Query and Table components that allows sharing data between datasets
Improved TimeZoneOffset support for TPgTimeStamp
Improved the Truncate method of the TPgLargeObject class
Improved the performance of exporting to XML
Fixed bug with executing a SELECT statement via the Execute method of the Query component
Fixed bug with the Ping method of the Connection component when the MultipleConnections property is set to False
Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
Fixed bug when a connection string parameter value contains a single quote
Fixed bug with international characters in error messages

New Features in PgDAC 7.2

RAD Studio 11 Alexandria Release 1 is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
The AddDelete property for the Dump component is added
Dumping of stores procedures via the Dump component is added
The SCRAM-SHA-256-PLUS authentication mechanism is supported
"ON CONFLICT" in batch operations is supported
Open connection performance is improved

New Features in PgDAC 7.1

PostgreSQL 14 is supported
OUT parameters in stored procedures for PostgreSQL 14 are supported
The PoolId connection pool option is added

New Features in PgDAC 7.0

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Added demo project for FastReport FMX

New Features in PgDAC 6.4

PostgreSQL 13 is supported
RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
Work in a multi-threaded environment through a single connection is supported
The MultipleConnections option in the Connection component is added
Performance of batch operations is improved
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved

New Features in PgDAC 6.3

Lazarus 2.0.10 and FPC 3.2.0 are supported
Performance of Batch Insert, Update, and Delete operations is improved

New Features in PgDAC 6.2

RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
The Line geometric type is supported

New Features in PgDAC 6.1

Android 64-bit is supported
PostgreSQL 12 is supported
OpenSSL 1.1 library is supported
Now Trial edition for macOS and Linux is fully functional

New Features in PgDAC 6.0

macOS 64-bit is supported
Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
TPgConnectionSSLOptions.IgnoreServerCertificateInsecurity property is added

New Features in PgDAC 5.4

Lazarus 2.0.2 is supported
The pmAuto value for the ProtocolVersion property is added
Now ProtocolVersion is set to pmAuto by default, which significantly improved performance
Possibility to use function calls in batch operations is added
The mVerifyCA and smVerifyFull options for the SSLOptions.Mode property of the TPgConnection component are added
The DefaultSortType property for TVirtualTable is added
Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased

New Features in PgDAC 5.3

RAD Studio 10.3 Rio is supported
PostgreSQL 11 is supported
Support of UPPER and LOWER functions for Unified SQL is added

New Features in PgDAC 5.2

Lazarus 1.8.4 is supported
Performance of batch operations is improved
Support for HTTP/HTTPS tunnel is added
Demo projects for IntraWeb 14 are added

New Features in PgDAC 5.1

SSPI authentication is supported
Processing GUID data type for the TGuidField class is improved

New Features in PgDAC 5.0

RAD Studio 10.2 Tokyo is supported
Linux in RAD Studio 10.2 Tokyo is supported
Lazarus 1.6.4 and Free Pascal 3.0.2 is supported

New Features in PgDAC 4.7

RAD Studio 10.1 Berlin is supported
Lazarus 1.6 and FPC 3.0.0 is supported
PostgreSQL 9.5 is supported
Support for the BETWEEN statement in TDADataSet.Filter is added
A MessageCharset option in connection options is added
Data Type Mapping performance is improved
RepeatableRead and ReadUncommitted transaction isolation levels are added
Performance of TDALoader on loading data from TDataSet is improved

New Features in PgDAC 4.6

RAD Studio 10 Seattle is supported
INSERT, UPDATE and DELETE batch operations are supported
Support of bit and bit varying data types is improved
Now Trial for Win64 is a fully functional Professional Edition

New Features in PgDAC 4.5

RAD Studio XE8 is supported
AppMethod is supported
PostgreSQL 9.4 is supported

New Features in PgDAC 4.4

RAD Studio XE7 is supported
Lazarus 1.2.4 is supported
Demo projects for FastReport 5 are added
The TCustomDADataSet.GetKeyFieldNames method is added
The ConstraintColumns metadata kind for the TDAMetadata component is added

New Features in PgDAC 4.3

Delphi XE6 is supported
Android in C++Builder XE6 is supported
Lazarus 1.2.2 and FPC 2.6.4 is supported
SmartFetch mode for TDataSet descendants is added
Now update queries inside TDataSet descendants have correct owner
The TPgDataSetOptions.MasterDetailNullable property is added

New Features in PgDAC 4.2

iOS in C++Builder XE5 is supported
RAD Studio XE5 Update 2 is now required
Now .obj and .o files are supplied for C++Builder
A list of available Charsets in TPgConnection at design-time is added
Default charset detecting for Windows is added
Compatibility of migrating floating-point fields from other components is improved

New Features in PgDAC 4.1

RAD Studio XE5 is supported
Application development for Android is supported
Lazarus 1.0.12 is supported
Performance is improved
Automatic checking for new versions is added
Flexible management of conditions in the WHERE clause is added
The possibility to use conditions is added
PostgreSQL 9.3 is supported
IPv6 protocol support is added
Support of the IN keyword in the TDataSet.Filter property is added
Like operator behaviour when used in the Filter property is now similar to TClientDataSet
The possibility to use ranges is added
The Ping method for the Connection component is added
The AllowImplicitConnect option for the Connection component is added
The SQLRecCount property for the Query and StoredProc components is added
The ScanParams property for the Script component is added
The RowsAffected property for the Script component is added
The EnableDomains option is added for TPgConnection
ConnectionTimeout is now used when disconnecting after connection loss
The TPgTable.TableName and TPgStoredProc.StoredProcName property editors are improved

New Features in PgDAC 4.0

Rad Studio XE4 is supported
NEXTGEN compiler is supported
Application development for iOS is supported
FPC 2.6.2 and Lazarus 1.0.8 are supported
Connection string support is added
Possibility to encrypt entire tables and datasets is added
Possibility to determine if data in a field is encrypted is added
Support of TimeStamp, Single and Extended fields in VirtualTable is added
Support for custom mapping of numeric fields with BCD and FmtBCD types is added

New Features in PgDAC 3.6

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported

New Features in PgDAC 3.5

Rad Studio XE3 is supported
Windows 8 is supported

New Features in PgDAC 3.1

Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Mac OS X and iOS in RAD Studio XE2 is supported
FireMonkey support is improved
Lazarus 0.9.30.2 and FPC 2.4.4 are supported
Mac OS X in Lazarus is supported
Linux x64 in Lazarus is supported
FreeBSD in Lazarus is supported
PostgreSQL 9.1 is supported

New Features in PostgreSQL Data Access Components 3.00

Embarcadero RAD Studio XE2 is supported
Application development for 64-bit Windows is supported
FireMonkey application development platform is supported
Support of master/detail relationship for TVirtualTable is added
OnProgress event in TVirtualTable is added
TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added

New Features in PostgreSQL Data Access Components 2.20

Lazarus 0.9.30 and FPC 2.4.2 is supported
Application Name connection option is supported
Payload parameter for PostgreSQL notification is supported (TPgNotificationEvent changed: EventMessage parameter is added)

New Features in PostgreSQL Data Access Components 2.10

PostgreSQL 9.0 supported
Improved performance
Improved table names detecting inside SQL queries for the UpdatingTable property
Case sensitive schema name
Checking that dataset is open on calling the TDataSet.Locate method

New Features in PostgreSQL Data Access Components 2.00

Embarcadero RAD Studio XE suppored
Support of ONLY lexeme in the FROM statement
Support for dbMonitor 3
Added OnStart, OnCommit, OnRollback events to TDATransaction
Ability to lock records in the CachedUpdate mode
Ability to send call stack information to the dbMonitor component
Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
CursorWithHold option for TCustomPgDataSet to use FetchAll=False mode without transaction
Now Required flag is set for UpdatingTable fields only
Now the AssignConnect method copies transaction state

New Features in PostgreSQL Data Access Components 1.20

Embarcadero RAD Studio 2010 supported
Support for automatic starting a transaction when FetchAll=False
FullRefresh option for TCustomPgDataSet
The Disconnected property to TCustomDADataSet
Distinction between empty string and null value when saving/loading string fields in TVirtualTable
The UseParamTypes option used to disable automatic detection of parameter types
Now the value from the master dataset has priority over the DefaultExpression value

New Features in PostgreSQL Data Access Components 1.10

Free Pascal under Linux supported
DMLRefresh supported
Added NoPreconnect property to TPgScript for executing CONNECT and CREATE DATABASE commands

Request Support

DAC Forum

Provide Feedback