Data Access Components for MySQL (MyDAC) - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Data Access Components for MySQL (MyDAC) by Devart (formerly Core Lab)

URLs: core-lab-data-access-components-for-mysql-mydac, core lab data access components for mysql mydac, corelabdataaccesscomponentsformysqlmydac, devart

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

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

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

Provide direct high performance access to MySQL.

Pricing: Data Access Components for MySQL (MyDAC) V7.0.1 Standard 1 Developer License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Standard 4 Developer Team License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Standard 1 Site Wide License (Allows Unlimited Developers at a Single Company) - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Developer License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Developer License - Upgrade from Standard - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Developer License - Upgrade from Standard V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Developer License Upgrade from Professional V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 4 Developer Team License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 4 Developer Team License Upgrade from Standard - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 4 Developer Team License Upgrade from Standard V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 4 Developer Team License Upgrade from Professional V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Professional V4.x - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional with Source code 1 Developer License with Source code - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional with Source code 4 Developer Team License with Source code - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Professional with Source code 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) with Source code - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 1 Developer License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 1 Developer License Upgrade from Professional - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 4 Developer Team License - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 4 Developer Team License Upgrade from Professional - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Professional - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer with Source code 1 Developer License with Source code - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer with Source code 1 Developer License Upgrade from Developer - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer with Source code 4 Developer Team License with Source code - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer with Source code 4 Developer Team License Upgrade from Developer - with Subscription, Data Access Components for MySQL (MyDAC) V7.0.1 Developer with Source code 1 Site Wide License (All

Evals & Downloads: Read the Data Access Components for MySQL (MyDAC) Manual - Requires Acrobat Reader, Read the Data Access Components for MySQL (MyDAC) License Agreement, Download the Data Access Components for MySQL (MyDAC) evaluation V7.0.1 on to your computer - Expires After 60 Days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95, Windows NT 3.51

Architecture of Product: 32Bit

Product Type: Component

Component Type: VCL

Compatible Containers: Embarcadero RAD Studio XE, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009, C++Builder XE, C++Builder 2010, C++Builder 2009, C++Builder 2007, C++Builder 2006, C++Builder 6, C++Builder 5, Delphi XE, Delphi 2010, Delphi 2009, Delphi 2007 for Win32, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Delphi 7.0, Delphi 6.0, Delphi 5.0, Kylix 3.0, MySQL 5.0

Product Class: Business Components

Keywords: corelab DAC D A C my sql mydac my dac

crlab corelab

Database DB Connectivity

SQL query language

Part numbers: PC-516254-404404 516254-404404 PC-516254-404412 516254-404412 PC-516254-404414 516254-404414 PC-516254-404406 516254-404406 PC-516254-404408 516254-404408 PC-516254-404410 516254-404410 PC-516254-404476 516254-404476 PC-516254-404416 516254-404416 PC-516254-404468 516254-404468 PC-516254-404472 516254-404472 PC-516254-404478 516254-404478 PC-516254-404418 516254-404418 PC-516254-404470 516254-404470 PC-516254-404474 516254-404474 PC-516254-404480 516254-404480 PC-516254-404420 516254-404420 PC-516254-404422 516254-404422 PC-516254-404424 516254-404424 PC-516254-404426 516254-404426 PC-516254-404482 516254-404482 PC-516254-404428 516254-404428 PC-516254-404484 516254-404484 PC-516254-404430 516254-404430 PC-516254-404486 516254-404486 PC-516254-404432 516254-404432 PC-516254-404488 516254-404488 PC-516254-404434 516254-404434 PC-516254-404490 516254-404490 PC-516254-404436 516254-404436 PC-516254-404492 516254-404492 PC-516254-404438 516254-404438 PC-516254-404440 516254-404440 PC-516254-404442 516254-404442 PC-516254-404444 516254-404444 PC-516254-404446 516254-404446 PC-516254-404448 516254-404448 PC-516254-404450 516254-404450 PC-516254-404452 516254-404452 PC-516254-404454 516254-404454 PC-516254-404456 516254-404456 PC-516254-404458 516254-404458 PC-516254-404460 516254-404460 PC-516254-404462 516254-404462 PC-516254-404464 516254-404464 PC-516254-404466 516254-404466