About MySQL Data Access Components
MySQL Data Access Components is a data access software from Devart designed for Delphi, C++Builder, and Lazarus. It provides native connectivity to MySQL, wide coverage of MySQL features, and cross-platform components for multiple operating systems, facilitating data management. With support for Windows, macOS, Linux, iOS, and Android, it allows developers to build applications that work across various platforms. The components also support secure connections using SSL, ensuring data integrity and confidentiality. Key capabilities: Shopping cart Contact Sales Hamburger SSL connection Row-level and table-level-locking Best for: developers needing reliable MySQL data access solutions in diverse application environments.
MySQL Data Access Components (MyDAC) by Devart is a highly robust and versatile data access library built for developers working with MySQL and MariaDB databases. Tailored for use in Delphi, C++Builder, and Lazarus (Free Pascal), MyDAC serves as a powerful alternative to traditional MySQL connectors and legacy tools like the Borland Database Engine (BDE). One of its key advantages is the ability to connect in both direct and client-based modes, with the direct mode bypassing the MySQL client library entirely. This significantly simplifies deployment and enhances performance, making MyDAC a suitable choice for developers building applications across Windows, macOS, Linux, iOS, and Android platforms—supporting both 32-bit and 64-bit systems. The user interface is thoughtfully designed for developers embedded in IDEs such as RAD Studio, Delphi, and Lazarus. Through seamless integration with these environments, MyDAC provides an intuitive development experience via component palettes and design-time editors. Common components like TMyConnection, TMyQuery, and TMyTable are easily accessible and manageable, allowing developers to configure properties through familiar property inspector tools.
Pros & Cons
- +1. It trivializes MySQL operations similar to other database engine components.
- +2. It is easy to use.
- +3. It has very helpful components.
- +4. It provides very fast data handling.
- −1. Some operations, like totaling fields, are lacking.
- −2. The documentation is very poor.
- −3. Database integration in Delphi is not possible or known according to the user.
Features
Key features
- 1. Native Connectivity to MySQL
- MyDAC provides direct access to MySQL and MariaDB without requiring additional data provider layers like BDE or ODBC, resulting in faster application performance.
- 2. Direct Mode
- This feature allows applications to connect directly to the MySQL server without relying on the MySQL client library, simplifying deployment and configuration.
- 3. Cross-Platform Support
- MyDAC components are compatible with multiple IDEs (RAD Studio, Delphi, C++Builder, Lazarus) and operating systems (Windows, Linux, macOS, iOS, Android, FreeBSD), offering developers flexibility in their choice of development environment.
- 4. Wide Coverage of MySQL Features
- The software supports a broad range of advanced MySQL server functionalities, enabling developers to fully utilize the capabilities of the database.
- 5. Mobile Development Support
- MyDAC simplifies the development of mobile applications for iOS and Android that need to interact with MySQL databases.
- 6. Secure Connection
- MyDAC can be used with SecureBridge to establish secure connections to MySQL servers using SSL, SSH, or HTTP/HTTPS protocols.
Additional features
- 1. Native Connectivity to MySQL
- Provides direct access to MySQL and MariaDB, eliminating the need for extra layers and improving speed.
- 2. Wide Coverage of MySQL Features
- Supports advanced database functionality to leverage the full potential of the MySQL server.
- 3. Cross-Platform Components for Delphi, C++Builder, and Lazarus
- Works with various IDEs and is compatible across Windows, macOS, Linux, iOS, and Android.
- 4. Secure Connection
- Enables the embedding of SSL, SSH, or HTTP/HTTPS protocols for secure communication with the MySQL server using SecureBridge.
- 5. Direct Mode
- Allows connecting to MySQL directly without the MySQL client library, simplifying deployment.
- 6. Mobile Development
- Facilitates connecting mobile applications on iOS and Android to MySQL databases.
- 7. Database Compatibility
- Supports MySQL server versions up to 8.0, MariaDB server versions up to 11.x, Microsoft Azure Database for MySQL, Amazon RDS for MySQL, Amazon Aurora, and Google Cloud for MySQL.
- 8. IDE Compatibility
- Compatible with the latest IDE versions including Community Edition (Embarcadero RAD Studio 12 Athens, Delphi 12 Athens, C++ Builder 12 Athens, Lazarus) and older versions back to Delphi 6 and C++Builder 6.
- 9. Data Type Mapping
- Offers a flexible engine for customizing the correspondence between MySQL Server and Delphi data types.
- 10. Development Platforms
- Supports major GUI frameworks like VCL for Windows, FMX for cross-platform applications, and LCL for Windows, macOS, or Linux in Lazarus.
- 11. Performance
- Designed with advanced data access algorithms and optimization techniques for high-performance data access layers.
- 12. Monitoring
- Includes the freeware dbMonitor tool to track and analyze all database calls made by applications using MyDAC.
- 13. SSL connection
- Supports establishing secure connections using SSL protocol.
- 14. Row-level and table-level locking
- Provides control over data concurrency using different locking mechanisms.
- 15. Embedded Server
- Offers complete support for the MySQL Embedded server.
Pricing
Monthly plans
Standard
USD 229.95
Professional
USD 349.95
Countries & Languages
Available in
Interface languages
Billing currencies
No reviews yet
Be the first to drop a review
Alternatives to MySQL Data Access Components
MAISY Database
MAISY Database is a utility customer data platform from Jackson Associates that supports block-level distribution…
AITable
AITable.ai is a visual database and workflow automation platform that functions like a spreadsheet but…
NCache
NCache is an Open Source Distributed Cache software from AlachiSoft that supports data caching and…
OSqlEdit
OSqlEdit is a database management software from OwnData that provides tools for editing and executing…
About MySQL Data Access Components
MySQL Data Access Components is a data access software from Devart designed for Delphi, C++Builder, and Lazarus. It provides native connectivity to MySQL, wide coverage of MySQL features, and cross-platform components for multiple operating systems, facilitating data management. With support for Windows, macOS, Linux, iOS, and Android, it allows developers to build applications that work across various platforms. The components also support secure connections using SSL, ensuring data integrity and confidentiality. Key capabilities: Shopping cart Contact Sales Hamburger SSL connection Row-level and table-level-locking Best for: developers needing reliable MySQL data access solutions in diverse application environments.
MySQL Data Access Components Details
MySQL Data Access Components's In-App Market Place
Does MySQL Data Access Components have an in-app market place?
Yes
How many Mini-Apps in the marketplace?
1
Mini Apps
N/A
Pricing Options
Plans
Monthly plans
Standard
USD 229.95
Professional
USD 349.95
Accepted Payment Currencies
USD ($)
Pros & Cons
- 1. It trivializes MySQL operations similar to other database engine components.
- 2. It is easy to use.
- 3. It has very helpful components.
- 4. It provides very fast data handling.
- 1. Some operations, like totaling fields, are lacking.
- 2. The documentation is very poor.
- 3. Database integration in Delphi is not possible or known according to the user.
MySQL Data Access Components's Support Options
Email Address
support@devart.comDocumentation
https://docs.devart.com/mydac/overview.htmCommunity Forums
https://support.devart.com/portal/en/communityMySQL Data Access Components's Alternatives
MAISY Database
MAISY Database is a utility customer data platform from Jackson Associates that supports block-level distribution…
AITable
AITable.ai is a visual database and workflow automation platform that functions like a spreadsheet but…
NCache
NCache is an Open Source Distributed Cache software from AlachiSoft that supports data caching and…
OSqlEdit
OSqlEdit is a database management software from OwnData that provides tools for editing and executing…
