Data Access Components for MySQL (MyDAC)

What’s new in Data Access Components for MySQL (MyDAC) V7.0.1?

• Embarcadero RAD Studio XE2 now supported
• Application development for 64-bit Windows now supported
• FireMonkey application development platform now supported
• Support of master/detail relationship for TVirtualTable added
• OnProgress event in TVirtualTable added
• TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string added
• Bug with refreshing record when using master/detail relationship is fixed
• Bug with detection of original field name for query with aliases is fixed
• Bug with AV failure on droping down tables list of TMyTable in design time when DisconnectedMode = True is fixed

What’s new in Data Access Components for MySQL (MyDAC) V6.10?

• Lazarus 0.9.30 and Free Pascal 2.4.2 support
• The BreakExec method now works when getting record count if QueryRecCount=True
• Bug in bookmark validity check has been fixed

What’s new in Data Access Components for MySQL (MyDAC) V6.00?

• Embarcadero RAD Studio XE supported

What’s new in Data Access Components for MySQL (MyDAC) V5.90?

• Embarcadero RAD Studio 2010 now supported
• Now the subdetail is refreshed before the "AfterRefresh" event of the detail is called
• ConnectionTimeout is now used when resolving the host name
• Fixed bug in the OpenNext method
• Fixed bug in the RefreshQuick method when using master/detail relationship
• Fixed bug with quoting of fields containing the dot(.) char in the name

What’s new in Data Access Components for MySQL (MyDAC) V5.80?

• Added support for Free Pascal under Linux
• Added NoPreconnect property to TMyScript for executing CONNECT and CREATE DATABASE commands
• Fixed bug with DetailDelay and refreshing closed dataset
• Fixed bug with not calling UnregisterClient for internal command of dataset
• Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate
• Fixed bug with detecting DBMonitor on 64-bit Windows
• Fixed bug with processing parameters when using East Asian languages
• Fixed bug with executing ApplyUpdates when LockMode = lmOptimistic in the CachedUpdates mode

What’s new in Data Access Components for MySQL (MyDAC) V5.70?

• Delphi 2009 and C++Builder 2009 supported
• Extended Unicode support for Delphi 2007 added (special Unicode build)
• Free Pascal 2.2 supported
• Powerful design-time editors implemented in Lazarus
• Completed with more comprehensive structured Help

What’s new in V5x?

New functionality:

• Delphi 2007 for Win32 supported
• Disconnected model for working offline and automatically connecting and disconnecting supported
• Local failover for detecting connection loss and implicitly reexecuting some operations supported
• SSH protocol supported via CryptoLibrary component set
• Added DataSet Manager to control project datasets
• Integration with MySQL Developer Tools 2.00 added
• New component for transferring data between all types of TDataSets descendants added
• Output parameters from stored procedures and functions retrieval supported
• Data export and import to/from XML supported
• WideMemo field type in Delphi 2006 supported
• AutoRefresh mode support added
• Option to break long-duration query execution added
• Ability to search for installed MySQL servers on the network added
• Support for sending messages to DBMonitor from any point of your program added

Support for more MySQL server functionality:

• HANDLER syntax support in TMyTable added
• Enumeration values retrieval for the ENUM and SET fields added

Extensions and improvements to existing functionality:

• General performance improved
• Master/detail functionality extensions:
  • Local master/detail relationship support added
  • Master/detail relationship in CachedUpdates mode support added
• TMyScript component improvements:
  • Support for executing individual statements in scripts added
  • Support for executing huge scripts stored in files with dynamic loading added
  • Ability to use standard MySQL client tool syntax added
• Working with calculated and lookup fields improvements:
  • Local sorting and filtering added
  • Record location speed increased
  • Improved working with lookup fields
• Greatly increased performance of applying updates in CachedUpdates mode
• Connection pool functionality improvements:
  • Efficiency significantly improved
  • API for draining the connection pool added
• Option to ignore or replace records with duplicated key values in TMyLoader added
• Enhanced TMyServerControl functionality for working with server values
• Ability to customize update commands by attaching external components to TMyUpdateQuery objects added

Usability improvements:

• Syntax highlighting in design-time editors added
• Demo projects became better organized and clearer

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

Developer

• 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
• My Developer Tools