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)

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 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

PartNumbers: PC-516254-113720 516254-113720 PC-516254-113725 516254-113725 PC-516254-113726 516254-113726 PC-516254-113721 516254-113721 PC-516254-113723 516254-113723 PC-516254-113722 516254-113722 PC-516254-113727 516254-113727 PC-516254-113728 516254-113728 PC-516254-113993 516254-113993 PC-516254-113994 516254-113994 PC-516254-114001 516254-114001 PC-516254-114002 516254-114002 PC-516254-114003 516254-114003 PC-516254-114004 516254-114004 PC-516254-114005 516254-114005 PC-516254-114006 516254-114006 PC-516254-114007 516254-114007 PC-516254-136288 516254-136288 PC-516254-136289 516254-136289 PC-516254-136290 516254-136290 PC-516254-136291 516254-136291 PC-516254-136292 516254-136292 PC-516254-136293 516254-136293 PC-516254-136294 516254-136294 PC-516254-136295 516254-136295 PC-516254-136296 516254-136296 PC-516254-136297 516254-136297 PC-516254-136298 516254-136298 PC-516254-136299 516254-136299 PC-516254-136300 516254-136300 PC-516254-136301 516254-136301 PC-516254-136302 516254-136302

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

Resources: 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 on to your computer - Expires After 60 Days

Operating System for Deployment: 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: C++Builder 6, C++Builder 5, 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

Search Items: New Product Aug 05

Keywords: crlab corelab SQL query language Database DB Connectivity Author corelab DAC D A C my sql mydac my dac