Virtual Data Access Components (VirtualDAC) 关于

使用 SQL 来同时查询来自不同 RDBMS 或虚拟数据集的数据。

Virtual Data Access Components (VirtualDAC, formerly known as VirtualTable), is a library of components that extends data processing capabilities in Delphi and C++Builder on Windows, Linux, macOS, iOS and Android. VirtualDAC consists of components that allow creating in-memory data storage and executing complex SQL queries to in-memory tables when developing Delphi applications.

Virtual Data Access Components (VirtualDAC) Features

  • VirtualQuery - The TVirtualQuery component is used to retrieve data with SQL queries from sources that are TDataSet descendants. You can build complex SQL queries to in-memory data (data sources are TVirtualTable, TVirtualDataSet or another TVirtualQuery) or to data stored in different RDBMS (data sources can be TUniQuery, TOraQuery, TMSQuery, TMyQuery, etc. at the same time).
  • VirtualTable - The TVirtualTable component represents in-memory data storage that does not have linked to data files. TVirtualTable allows to load data from a XML or CSV file, or from an existing dataset, and then wraps the data in the usual way, as in any TDataSet descendant.
  • VirtualDataSet - The TVirtualDataSet component is data wrapper that doesn't store data in memory and interacts with data using event handlers. It allows to represent arbitrary data (arrays, lists, objects, etc.) as TDataSet descendants and link it with any DB-aware components to display data or modify it.
  • Cross-Platform Solution for Delphi and C++Builder - VirtualDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi and C++Builder on Windows, MacOS, iOS, Android, for both 32-bit and 64-bit platforms. VirtualDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.
  • Advanced Design-Time Editors - VirtualDAC includes various design-time editors, that provide convenient interface and rich facilities for both creating TVirtualTable fields and filling them with data in design-time, that can be saved in dfm or a file afterwards.
  • Mobile - VirtualDAC allows your mobile applications to work with multiple databases as simply as desktop applications do.
  • High-Performance - The components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.

The Standard edition shows off the full power of VirtualDAC, enhancing VirtualDAC Express Edition with TVirtualDataSet and TVirtualQuery functionalities.

You can get Source Access to the VirtualDAC Standard Edition by purchasing special VirtualDAC Standard Edition with Source Code. The Standard edition includes the source code for all component classes.