Download Devart PostgreSQL Data Access Components (PgDAC) v7.1.1 Pro with Full Source

Devart PostgreSQL Data Access Components (PgDAC) v7.1.1 Pro with Full Source

Devart PostgreSQL Data Access Components (PgDAC) v7.1.1 Pro with Full Source
Devart PostgreSQL Data Access Components (PgDAC) v7.1.1 Pro with Full Source


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 designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.

PgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client.

Native Connectivity to PostgreSQL
PgDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), and that's why they can work faster than the ones based on standard Delphi data connectivity solutions. Moreover, PgDAC provides an additional opportunity to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client.

Wide Coverage of PostgreSQL Features
PgDAC allows developers to optimize their database applications and harness the full capabilities of PostgreSQL. PgDAC features complete support for fast record insertion, Asynchronous Notification, PostgreSQL sequences, retrieving the last inserted OID value, notices, 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 platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.

Secure Connection
You can use PgDAC with SecureBridge components to embed an 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.

Product 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
Development for iOS and Android mobile devices using PgDAC becomes still easier, as PgDAC allows your mobile applications to work with PostgreSQL database as simply as desktop applications do.

Database Compatibility
Our product supports PostgreSQL server versions from 8.0 to 14, Microsoft Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, Amazon Aurora, and Google Cloud for PostgreSQL.

IDE Compatibility
Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 11 Alexandria, Delphi 11 Alexandria, C++ Builder 11 Alexandria, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.

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
All major GUI frameworks supported: develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.

7.1.1 09-Dec-21

PostgreSQL 14 is supported
OUT parameters in stored procedures for PostgreSQL 14 are added
The PoolId connection pool option is added
Fixed bug with Access Violation on RefreshRecord after connection switching
Fixed bug with application name when connection pooling is used
Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
Fixed bug with processing large OID values
Fixed bug with freezing multiply connection pools in threads
Fixed bug with using the AsDate property when working with fields of the ftDate type
Fixed bug with updating the state of records at applying cached updates


7.0.1 13-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Added demo project for FastReport FMX
Fixed bug with processing UUID fields
Fixed bug with processing large OID values
Fixed bug with the incorrect encoding of error messages
Fixed bug with the incorrect RowsAffected result of the WITH ... statement
Fixed bug with error when setting the "0" value for a currency field
Fixed bug with automatic conversion of null values from SQL subqueries to default values
Fixed bug with processing IDENTITY fields in the PgDump component
Fixed bug with CanModify = False in the Table component when opening a temporary table
Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier
Fixed bug with setting a DateTime value before the year 1800 to TTimeField
Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
Fixed bug with memoty leak on Locate by field with data type mapping
Fixed bug with escaping wildcards in the Filter property of the DataSet component


Only for V.I.P
Warning! You are not allowed to view this text.
  • 59