New in Delphi Data Access Components: Lazarus 3.0, FireBird 5, and More

We are glad to announce the latest update for Devart’s DAC Data Providers.

This update features official Lazarus version 3.0 support for most Delphi Data Access Components, along with numerous quality-of-life improvements and bug fixes.

IBDAC and UniDAC received a significant update — support for Firebird version 5, which brings parallel operations, partial indices, enhanced SQL support, PSQL and SQL profiler, improved data compression, and more. IBDAC has received support for parallel operations in TIBCBackupService, TIBCRestoreService, and TIBCValidationService, minor ODS upgrade in TIBCValidationService, and multiple rows being returned by DML with the RETURNING clause.

Compatibility of UniDAC with MS Access has also greatly improved: it now supports the Direct Mode, broadening compatibility with platforms beyond Windows.

Other notable changes include, but are not limited to:

• The RealAsDouble option has been implemented for the Connection component for SQLite.
• You can now connect to servers with enabled Security Banners in Direct Mode for Oracle.
• Improved the error message about a non-existent database object in another schema for Oracle.
• Multiple performance improvements with column default values, RefreshRecord queries, and arrays in queries in PostgreSQL.
• In DB2 we’ve added UTF-8 encoding, support for tables with duplicate column names, and the long-awaited SSL connection support.
• Support of NexusDB 4.75.01 has been added.

But what exactly does the Lazarus, version 3.0 entail, you may ask. Here are the highlights:

Support for more platforms: Lazarus 3.0 expanded its support to additional platforms, enhancing its cross-platform capabilities. This includes improvements for macOS, Linux, and Windows, making it easier for developers to target multiple operating systems with their applications.

Enhanced IDE: The Lazarus Integrated Development Environment (IDE) received various enhancements, including improvements to the code editor, debugger, and project management features. These improvements aim to streamline the development process and provide developers with a more efficient and user-friendly environment.

Updated component library: Lazarus 3.0 introduced updates and additions to its component library, providing developers with a wider range of tools and components to use in their applications. This includes improvements to existing components as well as the addition of new ones, allowing developers to create more feature-rich and visually appealing applications.

Improved compatibility: Lazarus 3.0 focused on improving compatibility with Delphi, making it easier for developers to port their existing Delphi projects to Lazarus. This includes better support for Delphi language features, components, and libraries, reducing the effort required to migrate projects between the two environments.

Performance optimization: Lazarus 3.0 included various performance tweaks aimed at improving the speed and responsiveness of the IDE and compiled applications. These optimizations help developers work more efficiently and deliver faster and more responsive applications to end-users.

Additional enhancements in this update:

Please refer to the revision histories provided in the table below for a comprehensive list of all the changes made.