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 and C++Builder 5, 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