PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Delphi, Delphi for .NET, and C++Builder. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries. PgDAC works directly through TCP/IP protocol and does not use the PostgreSQL client library. As data is transferred from socket to storage without additional buffers, the PgDAC performance is kept on the highest level. Such technology helps to avoid restrictions and slips of the pqlib library, use features of PostgreSQL backend protocol that are not implemented in it. Also Devart PgDAC offers wide coverage of the PostgreSQL feature set and emphasizes optimized data access strategies.

Key Features:

- Direct access to server data without using client library.

- Does not require installation of other data provider layers (such as BDE and ODBC)

- Full support of the latest versions of PostgreSQL Server

- Support for all PostgreSQL Server data types

- Disconnected Model with automatic connection control for working with data offline

- Local Failover for detecting connection loss and implicitly reexecuting certain operations

- All types of local sorting and filtering, including by calculated and lookup fields

- Automatic data updating with TPgQuery, TPgTable, and TPgStoredProc components

- Unicode and national charset support

- Supports many PostgreSQL-specific features, such as notifications, notices, and sequences

- Advanced script execution functionality with the TPgScript component

- Support for using macros in SQL - Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications

- Includes annual PgDAC Subscription with Priority Support

Compatibility: Delphi 6 and higher (except Delphi 8),C++Builder 6 and higher, FreePascal, Turbo Delphi; PostgreSQL server versions since 7.1 up to 8.3.