PostgreSQL Data Access Component (PgDAC) is a component library that provides local connectivity for 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 connection solution and provides an effective alternative to the Borland Database Engine (BDE) and standard dbExpress driver for accessing PostgreSQL. It provides direct access to PostgreSQL without the need for a PostgreSQL client.

Local Connection in PostgreSQL

Database applications based on PgDAC 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 PostgreSQL directly with TCP/IP without involving the PostgreSQL client.

PostgreSQL has a wide range of functions

PgDAC allows developers to optimize their database applications and leverage all the features of PostgreSQL. PgDAC fully supports fast record insertion, asynchronous notifications, PostgreSQL sequences, retrieving the last inserted OID value, notifications, and more.

1. SSL connection
2. Large objects
3. Direct connection
4. Composite type
5. REF cursor
6. Transparent application failover
7. a notice
8. interval
9. Geometric type
10. 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 on Windows, Linux, macOS, iOS, Android, and FreeBSD, Delphi, C++Builder, Lazarus (and FPC) (for x86 and x64 platforms). PgDAC also provides support for the FireMonkey platform, which allows you to develop visually striking high-performance desktop and mobile native applications.

Secure Connection

You can use the SecureBridge component together 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

1. Direct mode

Allowing your application to directly use PostgreSQL without the need to connect to a PostgreSQL solution greatly simplifies application deployment and configuration.

1. Mobile development

Developing for iOS and Android mobile devices has become easier with PgDAC, as it allows your mobile applications to use PostgreSQL databases just like desktop applications.

1. Database compatibility

Our product supports PostgreSQL server versions (from 8.0 to 13), Microsoft Azure database for PostgreSQL, Amazon RDS for PostgreSQL, Amazon Aurora, and Google Cloud for PostgreSQL.

1. IDE compatibility

Our product is compatible with the latest IDE versions, including the Community Edition: 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.

1. Data type mapping

If you want to customize the correspondence between PostgreSQL and Delphi data types, you can use the simple and flexible data type mapping engine provided by PgDAC.

1. Development Platform

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.

1. performance

All of our components and libraries are designed to help you write high-performance, lightweight data access layers, utilizing advanced data access algorithms and optimization techniques.

1. Monitoring method

Use our free software dbMonitor tool to monitor and analyze all database calls made by your application using PostgreSQL data access components. DbMonitor tracks SQL statement execution, commit, rollback, and other operations by component.

1. support

Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.