MySQL連接解決方案工具,有效替代Borland的MySQL數據庫引擎。
Data Access Components for MySQL (MyDAC) 是一個數據訪問組件的組件庫,它提供了對MySQL數據庫服務器的直接訪問。MyDAC可以直接連接到MySQL服務器或MySQL客戶端庫。MyDAC用來幫助程序員開發更快和更簡潔的MySQL數據庫應用程序。
Data Access Components for MySQL (MyDAC) is a library of components that provides direct access to MySQL database servers from Delphi, Delphi for .NET, C++Builder and Kylix. MyDAC can connect directly to MySQL server or work through the MySQL client library. The MyDAC library is designed to help programmers develop faster and cleaner MySQL database applications.
MyDAC is a complete replacement for standard MySQL connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to MySQL.
MySQL Data Access Components
MySQL數據訪問組件(MyDAC)是一個組件庫,可以從Delphi和C ++ Builder(包括Community Edition)以及Windows,Linux,macOS,iOS和Windows上的Lazarus(和Free Pascal)直接訪問MySQL和MariaDB。適用于32位和64位平臺的Android?;贛yDAC的應用程序可以直接連接到MySQL服務器或通過MySQL客戶端庫工作。 MyDAC旨在幫助程序員開發更快,更清潔的MySQL數據庫應用程序。
MyDAC是標準MySQL連接解決方案的完全替代品,是用于訪問MySQL的Borland數據庫引擎(BDE)和標準dbExpress驅動程序的有效替代品。
與MySQL的本地連接
基于MyDAC的數據庫應用程序易于部署,不需要安裝其他數據提供程序層(如BDE或ODBC),這就是為什么它們比基于標準Delphi數據連接解決方案的工作速度更快的原因。此外,MyDAC提供了一個直接使用MySQL而無需涉及MySQL客戶端庫的額外機會。
廣泛的MySQL功能
通過提供對最高級數據庫功能的訪問,MyDAC允許開發人員利用MySQL服務器的全部功能并優化其數據庫應用程序。 MyDAC完全支持嵌入式服務器,安全連接和MySQL管理任務。
Delphi、C ++ Builder和Lazarus的跨平臺解決方案
MyDAC是一個跨平臺的解決方案,用于使用各種IDE開發應用程序:適用于x86和x64平臺的Windows,macOS,Linux,iOS,Android和FreeBSD上的RAD Studio,Delphi,C ++ Builder,Lazarus(和FPC)。 MyDAC還為FireMonkey平臺提供支持,該平臺允許用戶開發視覺上引人注目的高性能桌面和移動本機應用程序。
通過MyDAC實現高開發生產力
我們提供各種GUI工具,可以提高用戶的工作效率:dbMonitor允許監控數據庫應用程序的活動,數據集管理器簡化了數據集和數據庫控件的調整,dbForge Fusion for MySQL提供了一種更簡單的方法來探索和維護現有的數據庫,設計復合SQL語句和查詢 ,以及操縱數據。
主要特點
直接模式
允許用戶的應用程序直接使用MySQL而不涉及MySQL客戶端庫,從而顯著促進應用程序的部署和配置。
移動開發
使用MyDAC的iOS和Android移動設備的開發人員變得更加容易,因為MyDAC允許用戶的移動應用程序像桌面應用程序一樣使用MySQL數據庫。
DB兼容性
支持最高8.0的MySQL服務器,最高10.x的MariaDB服務器版本,還提供與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版本兼容。
數據類型映射
如果要在MySQL Server和Delphi數據類型之間建立自定義對應關系,可以使用MyDAC提供的簡單靈活的數據類型映射引擎。
開發平臺
現在,用戶不僅可以在Laphius中開發基于VCL的Delphi應用程序和基于LCL的應用程序,還可以使用最新的FireMonkey應用程序開發平臺。
性能
所有的組件和庫都旨在幫助用戶編寫高性能,輕量級的數據訪問層,因此它們使用高級數據訪問算法和優化技術。
監控
使用免費軟件dbMonitor工具來監控和分析用戶的應用程序使用MyDAC進行的所有數據庫調用。 dbMonitor執行SQL語句執行、提交、回滾等的組件跟蹤。
支持
訪問我們的支持頁面,獲得經驗豐富的專業人員的即時支持,快速和詳細的響應,用戶參與和互動,頻繁構建和錯誤修復等等。
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