MyDAC

Overview

MySQL Data Access Components (MyDAC) is a library of components that provides direct access to MySQL database servers from Delphi, C++Builder, and Lazarus (Free Pascal). 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.

The MyDAC library is actively developed and supported by the Devart Team. If you have any questions about MyDAC, email the developers at mydac@devart.com or visit MyDAC online at http://www.devart.com/mydac/.

Advantages of MyDAC Technology

MyDAC is a direct database connectivity wrapper built specifically for the MySQL server. MyDAC offers wide coverage of the MySQL feature set, supports both client and direct connection modes, and emphasizes optimized data access strategies.

Wide Coverage of MySQL Features

By providing access to the most advanced database functionality, MyDAC allows developers to harness the full capabilities of the MySQL server and optimize their database applications. MyDAC provides a complete support of MySQL Embedded Server, row-level locking, using HANDLER statements, MySQL administration tasks. Get a full list of supported MySQL features in the Features topic.

Native Connection Options

MyDAC offers two connection modes to the MySQL server: Direct connection and connection through the standard MySQL Client in Client mode. MyDAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions. See the How does MyDAC work section.

Optimized Code

The goal of MyDAC is to enable developers to write efficient and flexible database applications. The MyDAC library is implemented using optimized code and advanced data access algorithms. Component interfaces undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers. Find out more about how to use MyDAC to optimize your database applications in Increasing Performance.

Compatibility with other Connectivity Methods

The MyDAC interface retains compatibility with standard VCL data access components BDE. Existing BDE-based applications can be easily migrated to MyDAC and enhanced to take advantage of MySQL-specific features. Migration of a Delphi project can be automated with the BDE Migration Wizard. Find out more about Migration Wizard in the Migration from BDE topic.

Development and Support

MyDAC is a MySQL connectivity solution that is actively developed and supported. MyDAC comes with full documentation, demo projects, and fast (usually within one business day) technical support by the MyDAC development team. Find out more about how to get help or submit feedback and suggestions to the MyDAC Development Team in the Getting Support topic.

A description of the MyDAC components is provided in the Component List.

Key Features

The full list of MyDAC features are available in the Features topic.

How does MyDAC work?

MyDAC allows you to connect to MySQL in two ways: in Client mode, using MySQL Client software, or in Direct mode. The chosen connection mode is regulated by the Direct option.

In Direct mode, MyDAC connects to MySQL directly without using MySQL client software.

In Client mode, MyDAC connects to MySQL through the MySQL client library. MySQL client library is supplied with MySQL server.

In comparison, the Borland Database Engine (BDE) uses several layers to access MySQL, and requires additional data access software to be installed on client machines.

The BDE data transfer protocol is shown below.

BDEFlow

BDE Connection Protocol

MyDAC works directly through native MySQL interface. It allows to avoid using BDE and ODBC:

Schema

MyDAC Connection Flow

© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback