Data Access Components for MySQL Features

General usability

• Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)
• Interface compatible with standard data access methods, such as BDE and ADO
• VCL, VCL for .NET, and CLX versions of library available
• Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
• Unicode and national charset support

Network and connectivity

• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• Support for all existing MySQL protocols including the prepared statement (binary) protocol
• SSH and SSL encrypted connection support with Devart SecureBridge
• Full support for all current authentication protocols
• Ability to search for installed MySQL servers in a local network
• Connection timeout and command timeout management

Compatibility

• Full support of the latest versions of MySQL
• Support for Embedded MySQL server
• Support for all MySQL Server data types
• Compatible with all IDE versions starting with Delphi 5, C++Builder 5, and Kylix 2, except Delphi 8, and with Free Pascal [New]
• Includes provider for UniDAC Standard Edition [New]
• Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
• Wide support of all standard Borland and third-party visual data-aware controls
• Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications

MySQL Server technology support

• Fast record insertion with TMyLoader component
• HANDLER syntax support
• Transaction isolation level support
• Possibility to retrieve last auto-incremented value
• Session identifer retrieval
• Server object information retrieval
• Row-level and table-level locking support

Performance

• High overall performance
• Fast controlled fetch of large data blocks
• Optimized string data storing
• Advanced connection pooling
• High performance of applying cached updates with batches
• Caching of calculated and lookup fields
• Fast Locate in a sorted DataSet
• Preparing of user-defined update statements

Local data storage operations

• Database-independent data storage with TVirtualTable component
• CachedUpdates operation mode
• Local sorting and filtering, including by calculated and lookup fields
• Local master/detail relationship
• Master/detail relationship in CachedUpdates mode

Data access and data management automation

• Automatic data updating with TMyQuery, TMyTable and TMyStoredProc components
• Automatic record refreshing
• Automatic query preparing
• Automatic checking for row modifications by another user
• Support for ftWideMemo field type in Delphi 2006 and higher

Extended data access functionality

• Separate component for executing SQL statements
• Simplified access to table data with TMyTable component
• Ability to retrieve metadata information with TMyMetaData component [New]
• BLOB compression support
• Support for using macros in SQL
• FmtBCD fields support
• Ability to customize update commands by attaching external components to TMyUpdateSQL objects
• Ability to perform MySQL administration tasks with the TMyServerControl component
• Value range retrieval for ENUM and SET fields
• Retrieval of output parameters from stored procedures and functions
• Automatic retrieval of default field values
• Deferred detail DataSet refresh in master/detail relationships
• MIDAS technology support
• MyDataAdapter component for WinForms and ASP.NET applications

Data exchange

• Transferring data between all types of TDataSet descendants with TCRBatchMove component
• Data export and import to/from XML (ADO format)
• Ability to synchronize positions in different DataSets
• Extended data management with TMyDump, TMyBackup components

Script execution

• Advanced script execution features with TMyScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Optimized multi-statement script execution
• Ability to use standard MySQL client tool syntax in scripts
• Ability to break long-running query execution

SQL Execution monitoring

• Extended SQL tracing capabilities provided by TMySQLMonitor component and dbMonitor
• Borland SQL Monitor support
• Ability to send messages to dbMonitor from any point in your program
• Ability to retrieve information about the last query execution

Visual extensions

• Includes source code of enhanced TCRDBGrid data-aware grid control
• Customizable connection dialog
• Cursor changes during non-blocking execution

Design-time enhancements

• DataSet Manager tool to control DataSet instances in the project
• Advanced design-time component and property editors
• Integration with dbForge Fusion for MySQL to provide browsing of database schemas, manipulating of database objects, and visual building of queries
• Automatic design-time component linking
• Easy migration from BDE with Migration Wizard
• More convenient data source setup with the TMyDataSource component
• Syntax highlighting in design-time editors

dbForge Fusion for MySQL main features

• Integration with MyDAC for enhanced component designers and drag and drop features
• Stored routines and SQL script debugger
• SQL code completion and navigation
• Visual query builder
• Database Explorer
• Visual object editors
• Database search engine
• Code template library
• Security Manager
• Session Manager
• Export/Import Wizards

Product clarity

• Complete documentation sets
• A large amount of helpful demo projects

Licensing and support

• Included annual MyDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site