PostgreSQL Data Access Components (PgDAC)

by Devart (formerly Core Lab) - Product Type: Component / VCL

Screenshot of PostgreSQL Data Access Components (PgDAC) - VCL - V3.0.1

Zoom [+]

Data access components for PostgreSQL. PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Delphi, Delphi for .NET, and C++Builder. PostgreSQL Data Access Components (PgDAC) offers a wide coverage of the PostgreSQL feature set and provides a flexible way to develop lightwieight and fast PostgreSQL database applications.

Our regular prices are shown below. Please logon to see your discounted prices.

PostgreSQL Data Access Components (PgDAC) Standard Edition V3.0.1

Add to Cart	$ 127.35	1 Developer License - with 1 Year Subscription	Download (39.7 MB)
Add to Cart	$ 293.95	4 Developer Team License - with 1 Year Subscription	Download (39.7 MB)
Add to Cart	$ 538.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription	Download (39.7 MB)

PostgreSQL Data Access Components (PgDAC) Professional Edition V3.0.1

Add to Cart	$ 195.95	1 Developer License - with 1 Year Subscription		Download (41.1 MB)
Add to Cart	$ 489.95	4 Developer Team License - with 1 Year Subscription		Download (41.1 MB)
Add to Cart	$ 881.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (41.1 MB)
Add to Cart	$ 68.56	1 Developer License Upgrade from Standard - with 1 Year Subscription	Verify	Download (41.1 MB)
Add to Cart	$ 195.95	4 Developer Team License Upgrade from Standard - with 1 Year Subscription	Verify	Download (41.1 MB)
Add to Cart	$ 342.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard - with 1 Year Subscription	Verify	Download (41.1 MB)

PostgreSQL Data Access Components (PgDAC) Professional Edition with Source code V3.0.1

Add to Cart	$ 293.95	1 Developer License - with 1 Year Subscription		Download (44.2 MB)
Add to Cart	$ 685.95	4 Developer Team License - with 1 Year Subscription		Download (44.2 MB)
Add to Cart	$ 1,273.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (44.2 MB)
Add to Cart	$ 97.95	1 Developer License Upgrade from Professional - with 1 Year Subscription	Verify	Download (44.2 MB)
Add to Cart	$ 195.95	4 Developer Team License Upgrade from Professional - with 1 Year Subscription	Verify	Download (44.2 MB)
Add to Cart	$ 391.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Professional - with 1 Year Subscription	Verify	Download (44.2 MB)

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's new in PostgreSQL Data Access Components (PgDAC) V3.0.1?

Embarcadero RAD Studio XE2 supported
Application development for 64-bit Windows supported
FireMonkey application development platform supported
Support of master/detail relationship for TVirtualTable added
OnProgress event in TVirtualTable added
TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
Problem with working in the pooling mode is fixed
Bug with SQL query following an empty SQL query is fixed

What's new in PostgreSQL Data Access Components (PgDAC) V2.20?

Lazarus 0.9.30 and Free Pascal 2.4.2 support
Application Name connection option is now supported
Payload parameter for PostgreSQL notification is now supported
Bug parsing SQL that contains escape sequences is now fixed
Bug showing backup progress is now fixed
Bug in bookmark validity check is now fixed

What's new in PostgreSQL Data Access Components (PgDAC) V2.10?

Improved performance
Fixed bug with triggers backup in TPgDump
Fixed bug with FetchAll=False

What's new in PostgreSQL Data Access Components (PgDAC) V2.00?

Embarcadero RAD Studio XE supported

What's new in PostgreSQL Data Access Components (PgDAC) V1.20?

Embarcadero RAD Studio 2010 now supported
Now the subdetail is refreshed before the AfterRefresh event of the detail is called
ConnectionTimeout is now used when resolving the host name

PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Delphi, Delphi for .NET, and C++Builder. 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 for access to PostgreSQL.

Advantages of PgDAC Technology - PgDAC works directly through the TCP/IP protocol and does not use the PostgreSQL client library. As data is transferred from socket to storage without additional buffers, PgDAC performance is kept on the highest level. Such technology helps to avoid restrictions of the pqlib library and the ability to use features of the PostgreSQL backend protocol that are not implemented in it. Also Devart PgDAC offers wide coverage of the PostgreSQL feature set and emphasizes optimized data access strategies.

Wide Coverage of PostgreSQL Features - By providing access to the most advanced database functionality, PgDAC allows developers to harness the full capabilities of the PostgreSQL server and optimize their database applications. PgDAC features complete support of fast record insertion, Asynchronous Notification, PostgreSQL sequences, the possibility to retrieve the last inserted OID value, notices, and more.

Native Connection Options - PgDAC does not require PostgreSQL client software installed. PgDAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions.

Optimized Code - The goal of PgDAC is to enable developers to write efficient and flexible database applications. The PgDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers.

Compatibility with Standard Data Access Components - The PgDAC interface retains compatibility with standard VCL data access components, like BDE. Existing BDE-based applications can be easily migrated to PgDAC and enhanced to take advantage of PostgreSQL-specific features. Project migration can be automated with BDE Migration Wizard.

Standard Edition includes:

Base Components (TPgConnection, TPgQuery, TPgSQL, TPgTable, TPgStoredProc, TPgUpdateSQL, TPgConnectDialog, TPgSQLMonitor, TPgScript, TPgDataSource, TVirtualTable, TCRDBGrid, PgDataAdapter)
Design-time features, including component editors and property editors
Migration Wizard

Professional Edition additionally includes: