MySQL Data Access Components

MySQL數(shù)據(jù)訪問組件（MyDAC）是一個組件庫，可以從Delphi和C ++ Builder（包括Community Edition）以及Windows，Linux，macOS，iOS和Windows上的Lazarus（和Free Pascal）直接訪問MySQL和MariaDB。適用于32位和64位平臺的Android?；贛yDAC的應(yīng)用程序可以直接連接到MySQL服務(wù)器或通過MySQL客戶端庫工作。 MyDAC旨在幫助程序員開發(fā)更快，更清潔的MySQL數(shù)據(jù)庫應(yīng)用程序。

MyDAC是標(biāo)準(zhǔn)MySQL連接解決方案的完全替代品，是用于訪問MySQL的Borland數(shù)據(jù)庫引擎（BDE）和標(biāo)準(zhǔn)dbExpress驅(qū)動程序的有效替代品。

與MySQL的本地連接

基于MyDAC的數(shù)據(jù)庫應(yīng)用程序易于部署，不需要安裝其他數(shù)據(jù)提供程序?qū)樱ㄈ鏐DE或ODBC），這就是為什么它們比基于標(biāo)準(zhǔn)Delphi數(shù)據(jù)連接解決方案的工作速度更快的原因。此外，MyDAC提供了一個直接使用MySQL而無需涉及MySQL客戶端庫的額外機(jī)會。

廣泛的MySQL功能

通過提供對最高級數(shù)據(jù)庫功能的訪問，MyDAC允許開發(fā)人員利用MySQL服務(wù)器的全部功能并優(yōu)化其數(shù)據(jù)庫應(yīng)用程序。 MyDAC完全支持嵌入式服務(wù)器，安全連接和MySQL管理任務(wù)。

Delphi、C ++ Builder和Lazarus的跨平臺解決方案

MyDAC是一個跨平臺的解決方案，用于使用各種IDE開發(fā)應(yīng)用程序：適用于x86和x64平臺的Windows，macOS，Linux，iOS，Android和FreeBSD上的RAD Studio，Delphi，C ++ Builder，Lazarus（和FPC）。 MyDAC還為FireMonkey平臺提供支持，該平臺允許用戶開發(fā)視覺上引人注目的高性能桌面和移動本機(jī)應(yīng)用程序。

通過MyDAC實現(xiàn)高開發(fā)生產(chǎn)力

我們提供各種GUI工具，可以提高用戶的工作效率：dbMonitor允許監(jiān)控數(shù)據(jù)庫應(yīng)用程序的活動，數(shù)據(jù)集管理器簡化了數(shù)據(jù)集和數(shù)據(jù)庫控件的調(diào)整，dbForge Fusion for MySQL提供了一種更簡單的方法來探索和維護(hù)現(xiàn)有的數(shù)據(jù)庫，設(shè)計復(fù)合SQL語句和查詢 ，以及操縱數(shù)據(jù)。

主要特點(diǎn)

直接模式

允許用戶的應(yīng)用程序直接使用MySQL而不涉及MySQL客戶端庫，從而顯著促進(jìn)應(yīng)用程序的部署和配置。

移動開發(fā)

使用MyDAC的iOS和Android移動設(shè)備的開發(fā)人員變得更加容易，因為MyDAC允許用戶的移動應(yīng)用程序像桌面應(yīng)用程序一樣使用MySQL數(shù)據(jù)庫。

DB兼容性

支持最高8.0的MySQL服務(wù)器，最高10.x的MariaDB服務(wù)器版本，還提供與Microsoft Azure Database for MySQL和Google Cloud for MySQL的兼容性。

IDE兼容性

兼容最新的IDE版本和版本，包括Community Edition：Embarcadero RAD Studio 10.3 Rio，Delphi 10.3 Rio，C ++ Builder 10.3 Rio，Lazarus（和FPC）。它還與Delphi 6和C ++ Builder 6之后的IDE版本兼容。

數(shù)據(jù)類型映射

如果要在MySQL Server和Delphi數(shù)據(jù)類型之間建立自定義對應(yīng)關(guān)系，可以使用MyDAC提供的簡單靈活的數(shù)據(jù)類型映射引擎。

開發(fā)平臺

現(xiàn)在，用戶不僅可以在Laphius中開發(fā)基于VCL的Delphi應(yīng)用程序和基于LCL的應(yīng)用程序，還可以使用最新的FireMonkey應(yīng)用程序開發(fā)平臺。

性能

所有的組件和庫都旨在幫助用戶編寫高性能，輕量級的數(shù)據(jù)訪問層，因此它們使用高級數(shù)據(jù)訪問算法和優(yōu)化技術(shù)。

監(jiān)控

使用免費(fèi)軟件dbMonitor工具來監(jiān)控和分析用戶的應(yīng)用程序使用MyDAC進(jìn)行的所有數(shù)據(jù)庫調(diào)用。 dbMonitor執(zhí)行SQL語句執(zhí)行、提交、回滾等的組件跟蹤。

支持

訪問我們的支持頁面，獲得經(jīng)驗豐富的專業(yè)人員的即時支持，快速和詳細(xì)的響應(yīng)，用戶參與和互動，頻繁構(gòu)建和錯誤修復(fù)等等。

Components
All editions of MyDAC include the following basic components:

• TMyConnection - lets you set up and control connections to MySQL database server
• TMyQuery - uses SQL statements to retrieve data from MySQL table or tables and supply it to one or more data-aware components through a TDataSource component and provides flexible data update functionality
• TMyTable - allows to retrieve and update data single table without writing SQL statement
• TMyStoredProc - executes stored procedures and functions
• TMyCommand - executes SQL statements and stored procedures, which do not return rowsets
• TMyScript - executes sequence of SQL statements
• TMyUpdateSQL - lets you tune update operations for a DataSet component
• TMyDataSource - provides an interface between a MyDAC dataset components and data-aware controls on a form
• TMySQLMonitor - allows to monitor dynamic SQL executing in MyDAC based applications
• TMyConnectDialog - allows you to build custom prompts for usernames, passwords, and servers
• TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search
• TVirtualTable - provides dataset functionality for data that has no real database connection
• MyDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet
• MyDAC Professional Edition and MyDAC Developer Edition include the following additional components:
• TMyLoader - provides quick loading data to MySQL database
• TMyDump - serves to store a database or its parts as a script and also to restore database from received script
• TMyBackup - serves for backup copying specified tables on the server
• TMyServerControl - serves to control the server and execution of standard service tasks
• TMyEmbConnection - is used to establish connection to MySQL Embedded server
• TMyBuilder - serves to manage SQL Builder for MySQL Add-in
• TMyMetaData - retrieves metadata on specified SQL object
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
The following list describes the main features of Data Access Components for MySQL.

• Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest versions of MySQL Server
• Support for all MySQL Server data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TMyQuery, TMyTable, and TMyStoredProc components
• Unicode and national charset support
• Supports many MySQL-specific features, such as locking, SET and ENUM types
• Advanced script execution functionality with TMyScript component
• Support for using macros in SQL
• Integration with MyDeveloper Tools for performing advanced database development and administration tasks
• Easy migration from BDE with Migration Wizard
• Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications
• Includes annual MyDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site