New Release of Delphi Data Access Components Adds Support for Latest IDEs and Databases

We are thrilled to announce a new release of our Delphi Data Access Components product line. This update delivers broader platform compatibility, enhanced security, and extended support for modern database technologies across multiple providers.

In this release

• Cross-provider highlights
  • IDE and platform support updates
  • Feature and usability improvements
• Provider-specific highlights
  • Oracle-specific updates
  • MySQL-specific updates
  • PostgreSQL-specific updates
  • SQL Server-specific updates
  • InterBase and Firebird-specific updates
  • SQLite-specific updates
• Other improvements

IDE and platform support updates

The latest release expands IDE and platform support with a strong focus on compatibility, performance, and developer productivity across the Delphi ecosystem. It adds support for RAD Studio 13 Florence Release 1 and Lazarus 4.6, while also introducing support for the Arm64EC target platform on Windows.

Support for the Arm64EC target platform on Windows allows developers to build hybrid applications that run natively on ARM64 while remaining compatible with existing x64 code and libraries. This approach enables gradual migration to ARM architecture, where performance-critical components can be compiled for ARM64, and legacy modules can continue to operate without modification. As a result, applications benefit from improved performance and power efficiency on modern ARM-based Windows devices, while maintaining stability and compatibility with established dependencies and development workflows.

Feature and usability improvements

The update introduces key enhancements that improve usability and security.

• Installation option for current user or all users
• Password masking in connection components to prevent plain-text storage in memory
• New dataset capabilities for SQL customization:
  • GetWhere
  • DeleteOrderBy
• Advanced dataset configuration:
  • RangeFieldCount
  • AutoClose

These changes simplify development workflows and strengthen application security.

Oracle-specific updates

This release brings several updates to ODAC v15.0 and the Oracle provider in UniDAC v12.0.

• Support for Oracle 26ai
• Support for JSON data type in Oracle 21c and later
• Faster detection of installed Oracle clients

MySQL-specific updates

This release brings the following updates to MyDAC v14.0 and the MySQL provider in UniDAC v12.0.

• Support for MySQL 9.6
• Improved dump functionality:
  • Support for read-only fields in INSERT statements
  • Custom delimiter configuration for stored procedures and triggers

PostgreSQL-specific updates

The following updates apply to PgDAC v10.0 and the PostgreSQL provider in UniDAC v12.0.

• Support for PostgreSQL 18 and protocol 3.2
• Support for:
  • Virtual generated columns
  • OAUTHBEARER authentication
• New connection options:
  • CurrentTimeZone
  • ExactTimeZone
  • UseSystemLocale
• Improved support for:
  • PostGIS
  • PgArray
  • PgInet

SQL Server-specific updates

This release brings the following updates to SDAC v13.0 and the SQL Server provider in UniDAC v12.0.

• Added the CommandTimeout option to TMSConnection
• Added the CommandTimeout option to SQL Server-specific settings in TUniConnection

InterBase and Firebird-specific updates

This release brings the following updates to IBDAC v11.0 and the InterBase/Firebird providers in UniDAC v12.0.

• Support for Firebird 3 functions
• Support for:
  • GENERATED BY DEFAULT AS IDENTITY
  • Extended transaction and database parameters (TPB, DPB, SPB)
• New connection options:
  • FloatAsSingle
  • UseReadConsistency
  • ConnectionConfigOverrides
• Improved performance and handling of database configuration blocks

SQLite-specific updates

The following updates apply to LiteDAC v8.0 and the SQLite provider in UniDAC v12.0.

• Support for vector extensions (sqlite-vec, sqlite-vector)
• New connection limits:
  • LimitLength
  • LimitExprDepth

Additional enhancements across providers

• Improved performance of VirtualQuery and VirtualDAC components
• Support for parameter type detection in ASE
• New connection and behavior options for:
  • NexusDB
  • DBF (ReadOnly mode)
  • Access (shared mode support)
  • Excel (CREATE RANGE support, exact field length control)
  • BigQuery (Service Account authentication via JSON)

Try the new Delphi Data Access Components

Download the latest Delphi Data Access Components release and see how the new updates can improve your development workflow.