MySQL Data Access Components comes in two editions: Standard and Professional.
The Standard edition includes the MyDAC basic connectivity components and MyDAC Migration Wizard. MyDAC Standard Edition is a cost-effective solution for database application developers who are looking for high-performance connectivity to MySQL for secure, reliable, and high-speed data transmission.
The Professional edition shows off the full power of MyDAC, enhancing MyDAC Standard Edition with support for MySQL-specific functionality and advanced dataset management features.
You can get Source Access to the implementation of all the component classes in MyDAC by purchasing a special MyDAC Professional Edition with Source Code. The source code of DataSet Manager and Migration Wizard is not distributed.
The matrix below compares the features of MyDAC editions. See Features for the detailed list of MyDAC features.
Feature | Standard | Professional | |
---|---|---|---|
Direct connectivity |
|||
Connection without MySQL client library | |||
Desktop Application Development |
|||
Windows | |||
macOS | |||
Linux | |||
Mobile Application Development |
|||
iOS | |||
Android | |||
Data Access Components |
|||
Base Components:
TMyConnection TMyQuery TMyCommand TMyTable TMyStoredProc TMyDataSource |
|||
Script executing
TMyScript | |||
Fast data loading into the server
TMyLoader | |||
MySQL Specific Components |
|||
Obtaining metadata about database objects
TMyMetaData |
|||
Connection with Embedded MySQL Server
TMyEmbConnection |
|||
MySQL server control
TMyServerControl |
|||
SQL Builder managing for MySQL Add-in
TMyBuilder |
|||
Storing a database as a script
TMyDump |
|||
Backup Service
TMyBackup |
|||
DataBase Activity Monitoring |
|||
Monitoring of per-component SQL execution
TMySQLMonitor |
|||
Additional components |
|||
Advanced connection dialog
TMyConnectDialog |
|||
Data encryption and decryption
TMyEncryptor |
|||
Data storing in memory table
TVirtualTable |
|||
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet |
|||
Advanced DBGrid with extended functionality
TCRDBGrid |
|||
Records transferring between datasets
TCRBatchMove |
|||
Design-Time Features |
|||
Enhanced component and property editors | |||
Migration Wizard | |||
DataSet Manager | |||
Cross IDE Support |
|||
Lazarus and Free Pascal Support |
1 Available only in Professional Edition with Source Code.