MySQL Data Access Component (MyDAC) is a component library that allows direct access to MySQL and MariaDB from Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Windows. Suitable for Android on 32-bit and 64 bit platforms.

Applications based on MyDAC can directly connect to MySQL servers or work through MySQL client libraries. MyDAC aims to assist programmers in developing faster and cleaner MySQL database applications.

MyDAC is a complete alternative to the standard MySQL connection solution and provides an effective alternative to the Borland Database Engine (BDE) and standard dbExpress driver for accessing MySQL.

Local connection to MySQL

Database applications based on MyDAC are easy to deploy and do not require the installation of other data provider layers (such as BDE or ODBC), which is why they can run faster than applications based on standard Delphi data connectivity solutions. Moreover, MyDAC provides an additional opportunity to directly use MySQL without involving MySQL client libraries.

MySQL has a wide range of functions

By providing access to the highest level database functionality, MyDAC enables developers to leverage the full capabilities of MySQL servers and optimize their database applications. MyDAC provides comprehensive support for embedded servers, secure connections, and MySQL management tasks.

1. SSL connection
2. Row level and table level locking
3. Embedded server
4. Service Task
5. Batch data loading
6. Direct connection
7. HTTP Tunnel
8. Transparent application failover
9. Server Management
10. And more

Cross platform solution for Delphi, C++Builder, and Lazarus

MyDAC is a cross platform solution for developing applications using various IDEs: RAD Studio, Lazarus (and FPC) for x86 and x64 platforms on Delphi, C++Builder, Windows, macOS, Linux, iOS, Android, and FreeBSD. MyDAC also provides support for the FireMonkey platform, which allows you to develop visually striking high-performance desktop and mobile native applications.

Secure Connection

You can use the SecureBridge component together with the data access component to embed SSL, SSH, or HTTP/HTTPS clients into your application to establish a secure connection with the server.

Product Features

1. Direct mode

Allowing your application to work directly with MySQL without involving MySQL client libraries greatly simplifies application deployment and configuration.

Mobile development using MyDAC for iOS and Android mobile devices has become easier, as MyDAC allows your mobile applications to use MySQL databases just like desktop applications.

1. Database compatibility

Our product supports MySQL server versions up to 8.0, MariaDB server versions up to 10. x, Microsoft Azure databases for MySQL, Amazon RDS for MySQL, Amazon Aurora, and Google Cloud for MySQL.

1. IDE compatibility

Our product is compatible with the latest IDE versions, including the Community Edition: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with early IDE versions starting from Delphi 6 and C++Builder 6.

1. Data type mapping

If you want to customize the correspondence between MySQL Server and Delphi data types, you can use the simple and flexible data type mapping engine provided by MyDAC.

1. Development Platform

Support all major GUI frameworks: Develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.

1. performance

All of our components and libraries are designed to help you write high-performance, lightweight data access layers, utilizing advanced data access algorithms and optimization techniques.

1. Monitoring method

Use our free software dbMonitor tool to monitor and analyze all database calls made by your application using MyDAC. DbMonitor tracks SQL statement execution, commit, rollback, and other operations by component.

1. support

Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.