PgDAC能完全替代標(biāo)準(zhǔn)的PostgreSQL連接解決方案，并提供了一個(gè)高效的可替代通過Borland數(shù)據(jù)庫引擎訪問PostgreSQL的方案。

普通特性

• 直接存取服務(wù)器數(shù)據(jù)。不需要安裝其他數(shù)據(jù)驅(qū)動(例如BDE和ODBC)

• 兼容標(biāo)準(zhǔn)數(shù)據(jù)存取方法接口，例如BDE和ADO

• 可用于VCL,VCL for .NET庫

• 獨(dú)立的運(yùn)行時(shí)和GUI特定部分允許你創(chuàng)建如CGI一樣完美的控制臺應(yīng)用程序

• 支持Unicode和national字符

網(wǎng)絡(luò)和連通性

• 不需要PostgreSQL客戶端軟件并直接通過TCP/IP工作

• 具備自動連線功能的斷開連接模型可以處理離線數(shù)據(jù)

• 失效切換功能可為鏈接失效或其他需重新執(zhí)行的某些操作提供本地切換

• 連接超時(shí)和命令行超時(shí)管理

• SSL連接加密支持OpenSSL和Devart SecureBridge

• 具有在本地網(wǎng)絡(luò)中搜索已安裝的PostgreSQL Server數(shù)據(jù)庫的功能

兼容性

• 完全支持PostgreSQL的最新版本

• 支持所有PostgreSQL數(shù)據(jù)類型

• 兼容從Delphi6,C++Builder6開始所有后續(xù)版本以及Free Pascal,除了Delphi8

• 包括UniDAC Standard Edition驅(qū)動

• 支持大多數(shù)的報(bào)表控件，包括了InfoPower,ReportBuilder,FastReport

• 支持所有標(biāo)準(zhǔn)控件和第三方可視化的數(shù)據(jù)感知控件

• 您可以使用Delphi和C++ Builder Professional Edition來開發(fā)C/S應(yīng)用程序

PostgreSQL Server技術(shù)支持

• 支持使用TPgLoader組件快速插入記錄

• 支持使用TPgAlerter組件的PostgreSQL異步通知

• 支持PostgreSQL序列

• 支持重新找回最后插入的OID值的可能

• 支持差錯(cuò)控制技術(shù)

• 支持PostgreSQL通知

PostgreSQL數(shù)據(jù)類型

• 支持PostgreSQL復(fù)合類型

• 完全支持DATE,TIME,TIMESTAMP以及INTERVAL數(shù)據(jù)類型

• 支持高級LARGE OBJECT

• 具有REFCURSOR類型的高級支持

• 具有支持geometic類型的外覆類別

性能

• 具有強(qiáng)大而全面的性能

• 快速的海量數(shù)據(jù)塊獲取控制

• 最優(yōu)串?dāng)?shù)據(jù)存儲

• 先進(jìn)的連接池

• 高性能的批量申請高速緩沖更新

• 計(jì)算字段和查找字段的緩存

• 在分類數(shù)據(jù)集中可快速定位

• 制作用戶自定義更新語句

本地?cái)?shù)據(jù)存儲操作

• 使用TVirtualTable組件進(jìn)行數(shù)據(jù)庫無關(guān)的數(shù)據(jù)存儲

• 高速緩沖更新操作模式

• 本地排序和過濾，包括通過計(jì)算字段和查找字段

• 本地主從關(guān)系

• 高速緩沖更新模式中的主從關(guān)系

數(shù)據(jù)訪問和數(shù)據(jù)管理自動化

• 使用TPgQuery, TPgTable和TPgStoredProc組件進(jìn)行自動數(shù)據(jù)更新

• 自動記錄刷新

• 自動查詢準(zhǔn)備

• 自動檢測其他用戶對行進(jìn)行的修改

• 支持在Delphi2006以及更高版本中使用ftWideMemo字段類型

豐富的數(shù)據(jù)訪問功能

• 用于執(zhí)行SQL語句的獨(dú)立組件

• 使用TPgTable組件可以簡單的訪問表數(shù)據(jù)

• 使用TPgMetaData組件可以找回元數(shù)據(jù)信息

• 支持BLOB壓縮

• 支持在SQL中使用宏命令

• 支持FmtBCD字段

• 可以通過添加外部組件來為TPgUpdateSQL對象定制更新命令

• 可以從存儲過程和函數(shù)中找檢索出參數(shù)

• 自動檢索默認(rèn)字段的值

• 可在主從關(guān)系里延遲子數(shù)據(jù)集的刷新

• 支持MIDAS技術(shù)

• 為WinForms和ASP.NET應(yīng)用程序而打造的PgDataAdapter組件

數(shù)據(jù)交換

• 使用TCRBatchMove組件在各種類型的TDataSet的繼承之間傳遞數(shù)據(jù)

• 可以從XML中輸入數(shù)據(jù)并且可以輸出到XML中(ADO格式)

• 可以在不同的數(shù)據(jù)集合之間同步位置

• 使用TPgDump組件擴(kuò)展數(shù)據(jù)管理

腳本執(zhí)行

• TPgScript組件具有先進(jìn)的腳本執(zhí)行特性

• 支持在腳本中執(zhí)行單獨(dú)的語句

• 支持動態(tài)加載來執(zhí)行無限大的腳本存儲文件

• 可以中指一個(gè)長時(shí)間查詢的執(zhí)行

SQL執(zhí)行監(jiān)測

• TPgSQLMonitor組件和DBMonitor提供了強(qiáng)大的SQL追蹤功能

• 支持Borland SQL Monitor

• 具有在應(yīng)用程序中任何位置向DBMonitor發(fā)送消息的功能

• 可以找回最后執(zhí)行的查詢的相關(guān)信息

可視化擴(kuò)展

• 包括了強(qiáng)大的TCRDBGrid數(shù)據(jù)感知網(wǎng)格控件的資源代碼

• 自定義連接對話框

• 在非阻塞執(zhí)行期間的指針變化

設(shè)計(jì)時(shí)加強(qiáng)

• 數(shù)據(jù)集管理工具用于控制工程中的數(shù)據(jù)集實(shí)例

• 先進(jìn)的設(shè)計(jì)時(shí)組件和屬性編輯器

• 自動的設(shè)計(jì)時(shí)組件連接

• 使用遷移向?qū)Э梢暂p松的從BDE中遷移

• 許多簡便的數(shù)據(jù)資源與TPgDataSource組件一同安裝

• 設(shè)計(jì)時(shí)編輯器擁有語法高亮標(biāo)記

產(chǎn)品透析

• 成套的文檔

• 可打印的PDF文檔

• 大量的示例程序

授權(quán)和支持

• 包括享受PgDA優(yōu)先支持的年金方式

• 可無限制的授權(quán)給每個(gè)開發(fā)者，每個(gè)開發(fā)團(tuán)隊(duì)或每個(gè)站點(diǎn)

PgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to PostgreSQL.

General usability

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• Interface compatible with standard data access methods, such as BDE and ADO
• VCL, VCL for .NET of library available
• Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
• Unicode and national charset support

Network and connectivity

• Does not require PostgreSQL client software and works directly through TCP/IP
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• Connection timeout and command timeout management
• SSL encrypted connection support with OpenSSL and Devart SecureBridge
• Ability to search for installed PostgreSQL Server databases in a local network

Compatibility

• Full support of the latest versions of PostgreSQL
• Support for all PostgreSQL data types
• Compatible with all IDE versions starting with Delphi 6, C++Builder 6, except Delphi 8, and with Free Pascal
• Includes provider for UniDAC Standard Edition
• Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
• Support of all standard and third-party visual data-aware controls
• Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications

PostgreSQL Server technology support

• Support for fast record insertion with the TPgLoader component
• Support for PostgreSQL Asynchronous Notification with the TPgAlerter component
• PostgreSQL sequences support
• Supports the possibility of retrieving last inserted OID value
• Advanced errors support
• Support for the PostgreSQL notices

PostgreSQL Data Types

• PostgreSQL Composite types support
• Full support of the DATE, TIME, TIMESTAMP, and INTERVAL data types
• Advanced LARGE OBJECT support
• Advanced support of the REFCURSOR type
• Wrapper classes for geometic types supported

Performance

• High overall performance
• Fast controlled fetch of large data blocks
• Optimized string data storing
• Advanced connection pooling
• High performance of applying cached updates with batches
• Caching of calculated and lookup fields
• Fast Locate in a sorted DataSet
• Preparing of user-defined update statements

Local data storage operations

• Database-independent data storage with TVirtualTable component
• CachedUpdates operation mode
• Local sorting and filtering, including by calculated and lookup fields
• Local master/detail relationship
• Master/detail relationship in CachedUpdates mode

Data access and data management automation

• Automatic data updating with TPgQuery, TPgTable and TPgStoredProc components
• Automatic record refreshing
• Automatic query preparing
• Automatic checking for row modifications by another user
• Support for ftWideMemo field type in Delphi 2006 and higher

Extended data access functionality

• Separate component for executing SQL statements
• Simplified access to table data with TPgTable component
• Ability to retrieve metadata information with TPgMetaData component
• BLOB compression support
• Support for using macros in SQL
• FmtBCD fields support
• Ability to customize update commands by attaching external components to TPgUpdateSQL objects
• Retrieval of output parameters from stored procedures and functions
• Automatic retrieval of default field values
• Deferred detail DataSet refresh in master/detail relationships
• MIDAS technology support
• PgDataAdapter component for WinForms and ASP.NET applications

Data exchange

• Transferring data between all types of TDataSet descendants with TCRBatchMove component
• Data export and import to/from XML (ADO format)
• Ability to synchronize positions in different DataSets
• Extended data management with TPgDump components

Script execution

• Advanced script execution features with TPgScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Ability to break long-running query execution

SQL Execution monitoring

• Extended SQL tracing capabilities provided by TPgSQLMonitor component and DBMonitor
• Borland SQL Monitor support
• Ability to send messages to DBMonitor from any point in your program
• Ability to retrieve information about the last query execution

Visual extensions

• Includes source code of enhanced TCRDBGrid data-aware grid control
• Customizable connection dialog
• Cursor changes during non-blocking execution

Design-time enhancements

• DataSet Manager tool to control DataSet instances in the project
• Advanced design-time component and property editors
• Automatic design-time component linking
• Easy migration from BDE with Migration Wizard
• More convenient data source setup with the TPgDataSource component
• Syntax highlighting in design-time editors

Product clarity

• Complete documentation sets
• Printable documentation in PDF format
• A large amount of helpful demo projects

Licensing and support

• Included annual PgDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site