PgDAC What's New

>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