PostgreSQL Data Access Components

PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Delphi, C++Builder and Lazarus (Free Pascal). PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.

Advantages of PgDAC Technology

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.

*Wide Coverage of PostgreSQL Features By providing access to the most advanced database functionality, PgDAC allows developers to harness the full capabilities of the PostgreSQL server and optimize their database applications. PgDAC features complete support of fast record insertion, Asynchronous Notification, PostgreSQL sequences, the possibility to retrieve the last inserted OID value, notices, and more. Get a full list of supported SQL Server features in Features.

*Native Connection Options PgDAC does not require PostgreSQL client software installed what heightens its performance. PgDAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions.

*Optimized Code The goal of PgDAC is to enable developers to write efficient and flexible database applications. The PgDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers.

*Compatibility with other Connectivity Methods The PgDAC interface retains compatibility with standard VCL data access components, like BDE. Development and Support

PgDAC is a PostgreSQL connectivity solution that is actively developed and supported. PgDAC comes with full documentation, demo projects, and fast (usually within two business days) technical support by the PgDAC development team. Find out more about getting help or submitting feedback and suggestions to PgDAC Development Team in Getting Support.

A description of the PgDAC components is provided in Component List.