| |
Connection to MySQL Database from Delphi, C++Builder, and Lazarus MySQL Data Access Components (MyDAC) is a library of components that provides direct access to MySQL and MariaDB 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. Applications based on MyDAC can connect directly to MySQL server or work through the MySQL client library. MySQL Data Access Components are designed to help programmers develop MySQL database applications faster and easier.
MyDAC is a complete replacement for standard MySQL connectors and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to MySQL.
|
|
|
Features
|
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
|
|
|
|
|
TMyUpdateSQL
|
|
|
|
|
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
|
|
ⅴ
|
|
|
