Connection to PostgreSQL Database From Delphi, C++Builder, and Lazarus

Q: How do I download PgDAC for a free trial?

Click the Download button at the top of the page and select the component that matches your environment. Click Get trial. If you are not signed in, sign in to your Devart account or sign up to create one. Then proceed with downloading PgDAC for a free, fully-functional 60-day trial.

PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. PgDAC is an efficient native alternative to the Borland Database Engine (BDE) and the standard dbExpress driver for PostgreSQL access.

Direct access without other data provider layers
VCL, LCL, FMX support
Standard data access compatibility
Full PostgreSQL technology support
Design-time productivity tools
Disconnected model capabilities

Native connectivity to PostgreSQL

PgDAC-based DB applications are easy to deploy and do not require installation of other data provider layers (such as BDE or ODBC). This makes them faster than those based on standard Delphi data connectivity solutions. Moreover, PgDAC provides an additional benefit of working directly with PostgreSQL via TCP/IP without involving a PostgreSQL client.

PgDAC supports:

PostgreSQL versions from 8.0 through 18.x
Microsoft Azure, Amazon RDS & Aurora, and Google Cloud for PostgreSQL
Protocol 2 and Protocol 3

Features

Secure connection

You can use PgDAC with SecureBridge components to embed SSL, SSH, or HTTP/HTTPS protocols into your application developed in Delphi, C++Builder, Lazarus, and Free Pascal for establishing a secure PostgreSQL database connection.

IDE compatibility

PgDAC works with the latest IDE versions, including Community editions: Embarcadero RAD Studio 13 Florence, Delphi 13 Florence, C++Builder 13 Florence, Lazarus (and FPC), as well as with previous IDE versions since Delphi 6 and C++Builder 6.

Development platforms

PgDAC supports all major GUI frameworks, providing you with all the capabilities you need to develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.

Mobile development support

Our PostgreSQL Data Access Components facilitate and expedite application development for iOS and Android devices by enabling your mobile applications to access and query PostgreSQL databases as easily and efficiently as desktop applications do.

Performance

All our PostgreSQL-optimized components and libraries use advanced data access algorithms and engineering best practices to assist you with writing high-performance, lightweight data access layers.

Data type mapping

If your application requires establishing custom alignment between PostgreSQL and Delphi data types, you can achieve it by using the straightforward and flexible Data Type Mapping engine available in PgDAC.

Monitoring

Use our freeware dbMonitor to monitor and analyze all the database calls made by your application using PgDAC. dbMonitor performs per-component tracing of SQL statement execution, commits, rollbacks, etc.

Support

Whenever you need assistance, you can visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.

PgDAC supports a wide range of PostgreSQL-specific features

SSL Connection
Large Objects
Direct connection

REF Cursors
Composite types
Asynchronous Notification

PostgreSQL sequences
Notices
Interval

Geometric types
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 for both x86 and x64 platforms. PgDAC also provides support for the FireMonkey application development platform, which allows you to develop visually spectacular, high-performance desktop- and mobile-native applications.

PgDAC supports various application development platforms and IDEs

Pricing

PostgreSQL Data Access Components

Starts from

$229_.95

Try the PostgreSQL Components

Key features:

Direct access without BDE/ODBC
VCL, LCL, FMX support
Standard data access compatibility
Full PostgreSQL technology support
Design-time productivity tools
Disconnected model capabilities

Universal Data Access Components

Starts from

$349_.95

Try the Universal Components

Key features:

Universal access to multiple databases
Direct mode without client libraries
VCL, LCL, FMX support
Disconnected mode with failover
Unified database-independent queries
Design-time productivity tools

Advanced ORM support

Entity Developer and EntityDAC enhance PgDAC by adding ORM capabilities on top of its direct PostgreSQL connectivity. EntityDAC uses PgDAC as its underlying data access layer for native, direct PostgreSQL connections without client software. Entity Developer provides a visual designer to create ORM models, generate Delphi entity classes, and support LINQ queries mapped to PostgreSQL via PgDAC.

Key benefits for PgDAC users

Visual ORM modeling: Design database schemas into Delphi classes with inheritance and encapsulation.
LINQ for PostgreSQL queries: Write server-agnostic queries that PgDAC executes efficiently.
Code-first flexibility: Generate or hand-edit entities, leveraging PgDAC's performance features like caching.
Seamless integration: No extra providers needed; PgDAC handles TCP/IP access while EntityDAC abstracts data into objects.

Other Data Access Components for databases

Oracle

SQL Server

Ready to get started?

Get a free 60-day trial now

Download PgDAC for a FREE 60-day trial and enjoy the high performance and new possibilities when working with PostgreSQL.

Get a free trial now

Enjoy bulk discounts

We offer flexible options to meet your budget in the optimal way. You can get bulk discounts for multiple purchases.

Discover now

Need a hand?

If you need any help or have questions about our connectivity solutions or purchasing options, feel free to get in touch.

Contact us

FAQ

What is PgDAC?

PgDAC (PostgreSQL Data Access Components) is a set of data access libraries designed for building applications that connect to PostgreSQL databases from Delphi, C++Builder, Lazarus (Free Pascal), and other RAD Studio environments.

How do I download PgDAC for a free trial?

Click the Download button at the top of the page and select the component that matches your environment. Click Get trial. If you are not signed in, sign in to your Devart account or sign up to create one. Then proceed with downloading PgDAC for a free, fully-functional 60-day trial.

Is a registration or email required to download PgDAC?

Yes. To download PgDAC, you need to sign in to your Devart account or sign up if you don't have one yet.

Where do I find the documentation for PgDAC?

You can find the PgDAC documentation at Devart's documentation portal.

How do I install PgDAC on Windows?

To install PgDAC on Windows, run the installer you downloaded and follow the instructions in the wizard. Note that installing PgDAC requires changes to your environment. For more details, see the documentation.