About MySQL Data Access Components (MyDAC)

Provide direct high performance access to MySQL.

Data Access Components for MySQL (MyDAC) is a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. It provides direct high performance access to MySQL and is an alternative to the standard way of accessing databases using BDE or dbExpress. MyDAC provides the ability to work with a MySQL server without the client library and access to an embedded server. Working without the client, MyDAC uses native MySQL protocol and requires only TCP/IP. MyDAC supports new MySQL server versions and all available data types.

Overview
Data Access Components for MySQL (MyDAC) library offers a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. They provide access to MySQL database and are an alternative to a standard way of accessing databases using Borland Database Engine (BDE) or dbExpress.

MyDAC can work using MySQL client or native MySQL network protocol. In case of using MySQL protocol directly MyDAC doesn't require client library and requires only TCP/IP protocol. This feature allows you to build really thin database application. MyDAC can work in managed environment and supports .NET Framework.

Following the main features of Data Access Components for MySQL (MyDAC):

  • Direct access to MySQL data. No distributing, installing and configuring the BDE and ODBC
  • Doesn't require MySQL's software on the client side with Direct option and works directly through TCP/IP
  • Supports the latest versions of MySQL server
  • All MySQL data types supported
  • Supports MySQL specific features
  • High performance controlled fetching of large data blocks
  • Optimized string and binary data storing
  • Automatic data updating with TMyQuery and TMyTable components
  • Automatic record refreshing
  • MySQL Embedded server support
  • Connection pooling feature
  • Stored procedures support
  • Support for compression protocol
  • Unicode and national charsets support
  • Encrypted SSL connections support
  • BLOB compression support added
  • TMyScript component to execute scripts
  • TMyLoader component for fast loading data
  • Separated run-time and GUI specific parts allow to create pure console applications such as CGI
  • Advanced design-time editors
  • MySQLBuilder Add-in extends design-time capabilities by set of tools to build and check queries
  • Extended SQL tracing capabilities provided by the TMySQLMonitor component and the DBMonitor application
  • Includes source code of TCRDBGrid enhance data-aware grid control
  • Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport
  • Easy migration from BDE with Migration Wizard
  • Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications

MyDAC Editions

My Data Access Components comes in three editions: MyDAC Standard Edition, MyDAC Professional Edition and MyDAC Developer Edition. MyDAC Standard Edition includes the MyDAC basic connectivity components and the MyDAC Migration Wizard. MyDAC Professional Edition includes additional components and DataSet Manager. MyDAC Developer Edition is a bundle package of MyDAC Professional Edition with MySQL Developer Tools, an advanced add-in for MySQL database development and administration.

Standard

  • Base Components - (TMyConnection, TMyQuery, TMyCommand, TMyTable, TMyStoredProc, TMyUpdateSQL, TMyConnectDialog, TMySQLMonitor, TMyScript, TMyDataSource, TVirtualTable, TCRDBGrid, MyDataAdapter
  • Design-time features, including component editors and property editors
  • Migration Wizard

Professional

  • Base Components  - (TMyConnection, TMyQuery, TMyCommand, TMyTable, TMyStoredProc, TMyUpdateSQL, TMyConnectDialog, TMySQLMonitor, TMyScript, TMyDataSource, TVirtualTable, TCRDBGrid, MyDataAdapter
  • Additional Components - (TMyLoader, TMyDump, TMyBackup, TMyServerControl, TMyEmbConnection, TMyBuilder, TCRBatchMove)
  • Design-time features, including component editors and property editors
  • DataSet Manager
  • Migration Wizard