PostgreSQL Data Access Components Alternatives

PostgreSQL Data Access Components

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.

Key Features:
- RAD Studio 10.4 Sydney is supported
- Direct Mode
- AppMethod support
- 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