PostgreSQL Data Access Components

PgDAC is a VCL/VCL.NET component library for fast direct access to PostgreSQL from Delphi, C++Builder, and FreePascal. PgDAC offers wide coverage of the PostgreSQL feature set and emphasizes optimized data access strategies.

Features: PostgreSQL Data Access Components (PgDAC) is a library of components. This provides you direct access to PostgreSQL database servers. Use these connections from within development environments like Delphi, Delphi for .NET, and C++Builder etc. PgDAC will help programmers develop PostgreSQL database applications without deploying any additional libraries. It replaces standard PostgreSQL connectivity solutions. This can an alternative to the Borland Database Engine for access to PostgreSQL.PgDAC works directly through TCP/IP protocol and does not use the PostgreSQL client library. Data is transferred from socket to storage directly and thus the PgDAC performance is high. It also offers wide coverage of the PostgreSQL feature set.

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. PostgreSQL client is not required. PgDAC-based database applications are easy to deploy. There is no need to install other data provider laThe Pgyers. That makes it faster usually. The goal of PgDAC is to enable developers to write efficient and flexible database applications. This implements algorithms and optimization techniques to help you write high-performance, lightweight data access layers. The library 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. Compatibility: Embarcadero RAD Studio 2010, Delphi 6 and higher (except Delphi 8),C++Builder 6 and higher, FreePascal, Turbo Delphi; PostgreSQL server versions since 7.1 up to 8.3.

Overall: A nice set of tools for development work.

PostgreSQL Data Access Components (PgDAC) is a library of components that provides direct access to PostgreSQL database servers from Embarcadero RAD Studio XE8/XE7/XE6/XE5/XE4/XE3/XE2/XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo Delphi for .NET Professional, Turbo C++ Professional, Borland Delphi 2005, Borland Delphi 7/6, Borland C++Builder 6, Lazarus 1.2.4 and Free Pascal 2.6.4 for Windows, Linux, Mac OS X, iOS, FreeBSD for 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. The capability to develop applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64, Mac OS, iOS, and now - Android. PgDAC gives its users an opportunity to establish Direct Connection and get the fastest data access to databases.
Key Features:
- RAD Studio XE7 is supported
- Android application development support
- iOS development support
- NEXTGEN compiler support
- Mac OS X development support
- Win64 development support
- Direct access to server data. Does not require installation of other data provider layers
- Full support of the latest versions of PostgreSQL Server and all PostgreSQL Server data types
- VCL, LCL and FMX versions of library available
- Disconnected Model with automatic connection control for working with data offline
- Local Failover for detecting connection loss and implicit re-execution of certain operations
- All types of local sorting and filtering, including by calculated and lookup fields
- Automatic data updating with TPgQuery, TPgTable, and TPgStoredProc components
- Unicode and national charset support
- Supports many PostgreSQL-specific features, such as notifications, notices, and sequences