PostgreSQL Data Access Component (PgDAC) is a component library that provides local connectivity to PostgreSQL through Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android. 32-bit and 64 bit platforms. PgDAC is designed to help programmers develop truly lightweight, faster, and cleaner PostgreSQL database applications without the need to deploy any other libraries.
PgDAC completely replaces the standard PostgreSQL connectivity solution and provides an effective alternative to the Borland Database Engine (BDE) and standard dbExpress driver to access PostgreSQL. It provides direct access to PostgreSQL without the need for a PostgreSQL client.
Local connection for PostgreSQL
PgDAC based database applications are easy to deploy and do not require the installation of other data provider layers (such as BDE or ODBC), which is why they can be faster than applications based on standard Delphi data connectivity solutions. In addition, PgDAC provides an additional opportunity to use it directly with PostgreSQL over TCP/IP without involving the PostgreSQL client.
PostgreSQL has a wide range of functions
PgDAC allows developers to optimize their database applications and leverage the full functionality of PostgreSQL. PgDAC fully supports fast record insertion, asynchronous notifications, PostgreSQL sequences, retrieval of the last inserted OID value, notifications, and more.
- SSL connection
- Large objects
- Direct connection
- Composite data type
- REF cursor
- Transparent application failover
- a notice
- interval
- Geometric type
- And more
Cross platform solution for Delphi, C++Builder, and Lazarus
PgDAC is a cross platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Linux, macOS, iOS, Android, and FreeBSD (suitable for x86 and x64 platforms). PgDAC also provides support for the FireMonkey platform, which allows you to develop visually appealing high-performance desktop and mobile native applications.
Secure connection
You can use the SecureBridge component with the data access component to embed SSL, SSH, or HTTP/HTTPS clients into your application to establish a secure connection with the server.
Product Features
Allowing your application to directly use PostgreSQL without the need for a PostgreSQL connection solution greatly simplifies application deployment and configuration.
Developing for iOS and Android mobile devices using PgDAC has become easier, as PgDAC allows your mobile applications to use PostgreSQL databases like desktop applications.
Our product supports PostgreSQL server versions (from 8.0 to 13), including Microsoft Azure databases for PostgreSQL, Amazon RDS for PostgreSQL, Amazon Aurora, and Google Cloud for PostgreSQL.
Our product is compatible with the latest IDE versions, including community versions: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with early IDE versions starting from Delphi 6 and C++Builder 6.
If you want to customize the mapping between PostgreSQL and Delphi data types, you can use the simple and flexible data type mapping engine provided by PgDAC.
Support all major GUI frameworks: develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.
All our components and libraries are designed to help you write a high-performance, lightweight data access layer, so they use advanced data access algorithms and optimization techniques.
Use our freeware dbMonitor tool to monitor and analyze all database calls made by your application using PostgreSQL data access components. DbMonitor executes SQL statement execution, submission, rollback, and other component based tracking.
Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.
