About PostgreSQL Data Access Components (PgDAC)

Data access components for PostgreSQL.

PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries

PostgreSQL Data Access Components (PgDAC) Features

  • Direct Mode - Allows your application to work with PostgreSQL directly without involving PostgreSQL connectivity solutions, thus significantly facilitating deployment and configuration of your applications.
  • Mobile Development - Develompent for iOS and Android mobile devices using PgDAC is easy. PgDAC allows your mobile applications to work with PostgreSQL database as simply as desktop applications do.
  • DB Compatibility - Supports the latest PostgreSQL server versions. Also provides compatibility with Microsoft Azure Database for PostgreSQL and Google Cloud for PostgreSQL.
  • IDE Compatibility - The product is compatible with the latest IDE versions and editions including Community Edition.
  • Data Type Mapping - If you want to make custom correspondence between PostgreSQL and Delphi data types, you can use a simple and flexible Data Type Mapping engine provided by PgDAC.
  • Development Platforms - Now you can develop not only VCL-based applications in Delphi and LCL-based ones in Lazarus, but also use the FireMonkey application development platform.
  • Performance - All the components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.
  • Monitoring - Use the dbMonitor tool to monitor and analyze all DB calls made by your application using PostgreSQL data access components. dbMonitor performs per­-component tracing of SQL statement execution, commits, rollbacks, etc.

The Standard edition includes the PgDAC basic connectivity components. PgDAC Standard Edition is a cost-effective solution for database application developers who are looking for overall high performance connectivity to PostgreSQL.

The Professional edition shows off the full power of PgDAC, enhancing PgDAC Standard Edition with support for PostgreSQL-specific functionality and advanced dataset management features.

You can get Source Access to the PgDAC Professional Editions by purchasing special PgDAC Professional Edition with Source Code. The Professional edition includes the source code for all component classes. The source codes of DataSet Manager and Migration Wizard are not distributed.