MyDAC

Editions

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.

MyDAC Edition Matrix

Feature Standard Professional

Direct connectivity

Connection without MySQL client library Yes Yes

Desktop Application Development

Windows Yes Yes
macOS No Yes
Linux No Yes

Mobile Application Development

iOS No Yes
Android No Yes

Data Access Components

Base Components:
TMyConnection
TMyQuery
TMyCommand
TMyTable
TMyStoredProc
TMyDataSource
Yes Yes
Script executing
TMyScript
Yes Yes
Fast data loading into the server
TMyLoader
No Yes

MySQL Specific Components

Obtaining metadata about database objects
TMyMetaData
Yes Yes
Connection with Embedded MySQL Server
TMyEmbConnection
No Yes
MySQL server control
TMyServerControl
No Yes
SQL Builder managing for MySQL Add-in
TMyBuilder
No Yes
Storing a database as a script
TMyDump
No Yes
Backup Service
TMyBackup
No Yes

DataBase Activity Monitoring

Monitoring of per-component SQL execution
TMySQLMonitor
Yes Yes

Additional components

Advanced connection dialog
TMyConnectDialog
Yes Yes
Data encryption and decryption
TMyEncryptor
No Yes
Data storing in memory table
TVirtualTable
Yes Yes
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet
Yes Yes
Advanced DBGrid with extended functionality
TCRDBGrid
Yes Yes
Records transferring between datasets
TCRBatchMove
No Yes

Design-Time Features

Enhanced component and property editors Yes Yes
Migration Wizard Yes Yes
DataSet Manager No Yes

Cross IDE Support

Lazarus and Free Pascal Support No Click to view restrictions

1 Available only in Professional Edition with Source Code.

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback