Data Access Components for MySQL History

This page lists the functionality added in each version of Data Access Components for MySQL. To view the full changelog including bug fixes, consult the MyDAC revision history.

23-Oct-08 New Features in MyDAC 5.70

  • Delphi 2009 and C++Builder 2009 supported
  • Extended Unicode support for Delphi 2007 added (special Unicode build)
  • Free Pascal 2.2 supported
  • Powerful design-time editors implemented in Lazarus
  • Completed with more comprehensive structured Help

21-Aug-08 New Features in MyDAC 5.55

  • dbForge Fusion for MySQL support added

23-May-08 New Features in MyDAC 5.50

  • Added compatibility with UniDAC
  • Improved support of default field values
  • The new component for metadata receiving added
  • Added ability to specify key fields for a dataset
  • Added support of automatic records locking

27-Sep-07 New Features in MyDAC 5.20

  • CodeGear RAD Studio 2007 supported
  • Added the OnProgress event in TMyLoader

15-Jun-07 New Features in MyDAC 5.10

  • C++Builder 2007 supported

22-Mar-07 New features in MyDAC 5.00

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

28-Aug-06 New features in MyDAC 4.40

  • Optimized TDALoader.CreateColumns method
  • Support for Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ added
  • Added support for macros names in which first symbol is digit
  • Added capability to use quoted field names in IndexFieldNames property

18-May-06 New features in MyDAC 4.30.1

  • MyDAC is now compatible with InterBase Data Access Components
  • Modifying FieldDefs in TVirtualTable component accelerated
  • Performance of SaveToFile and LoadFromFile functions in TVirtualTable improved

26-Jan-06 New features in MyDAC 4.30

  • Support for Delphi 2006 added
  • BIT fields of MySQL 5.0 and above are now represented as TLargeintField
  • FastReport 3.20 support added
  • Added server version checking on Prepare method
  • Added capability to close DataSet quicker when FetchAll property is False
  • Improved performance of updating recordsets with multiple fields
  • TCustomDADataSet.Locate now centers position in DBGrid
  • Added support for MIDAS TDataSet.PSExecuteStatement ResultSet parameter

07-Dec-05 New features in MyDAC 4.00.2

  • Added 'delimiter' keyword support in TMyScript
  • TCustomDADataSet.FindKey, TCustomDADataSet.FindNearest methods added for BDE compatibility
  • Added BIT and INTEGER types support in parameters of stored procedures

02-Sep-05 New features in MyDAC 4.00.1

  • Deferred detail dataset refresh feature with TCustomDADataSet.Options.DetailDelay property added
  • TCustomMyConnection.Ping behavior in case connection loss improved
  • FieldDefs.Update behavior in case of temporary tables improved
  • Added capability to prevent simultaneous access of several MyEmbConnection instances to single data folder

29-Jul-05 New features in MyDAC 4.00

  • Unicode support added
  • Enhanced support for MySQL Embedded Server with TMyEmbConnection component added
  • Binary protocol support for MySQL 4.1 and above added
  • Encrypted SSL connections support with OpenSSL added
  • Enhanced support for national charsets added with TMyConnectionOptions.Charset property
  • BLOB compression support added
  • RefreshQuick for TCustomMyDataSet added
  • Retrieve field's default value added with TCustomMyDataSet.Options.DefaultValues property
  • Large amount of data support for TMyDump added
  • Server start/stop ability for TMyServerControl added
  • TMyBuilder component added for easy using MySQLBuilder at run-time
  • Optimized macros processing
  • FAQ added
  • Tested with MySQL server 5.0.9

30-May-05 New features in MyDAC 3.55

  • MySQL 5.0.3 BIT type support added
  • Optimized MySQLMonitor BLOB parameters processing
  • Ability of automatic preparing query with TCustomDADataSet.Options.AutoPrepare property added
  • Ability to synchronize position at different DataSets with TCustomDADataSet.GotoCurrent method added

21-Jan-05 New features in MyDAC 3.50

  • Support for Delphi 2005 added
  • TMySQLMonitor.OnSQL can return statement encoded to an escaped SQL string
  • Support for ConnectionTimeout in TMyConnection.ExecSQL added
  • CommandTimeout default value set to 0 (infinite)
  • Lock Demo added
  • DECIMAL column type in MySQL 5.0.3 support added
  • Update Pack 3 is required for Delphi 8

21-Oct-04 New features in MyDAC 3.30

  • Full support for all current authentication protocols added
  • Generating update SQL for tables from other database added
  • TCustomMyDataSet.Options.EnableBoolean property added
  • TMyConnection.ThreadId property added
  • lxPartialCompare option for DataSet.LocateEx added
  • FastReport3 engine and demo added
  • Ability to store only a part of data in TMyDump.BackupQuery added
  • Creating additional connection for TMyDump disabled
  • TCustomMyDataSet.CommandTimeout property added
  • "True" value for boolean fields and parameters stored as "1"

10-Sep-04 New features in MyDAC 3.10.2

  • Common class DADataAdapter isolated to CoreLab.Dac.AdoNet.dll library

22-Jul-04 New features in MyDAC 3.10.1

  • Assembly CoreLab.MyDac.Data renamed to CoreLab.MyDac.AdoNet
  • Fatal errors processing improved
  • TINYINT(1) fields now represented as TBooleanField

08-Jul-04 New features in MyDAC 3.10

  • Local sorting ability with TMemDataSet.IndexFieldNames added
  • TCustomMyTable.IndexDefs property added
  • TMyConnection.Options.NumericType property added
  • TMyStoredProc component added
  • MyDataAdapter component added

29-Apr-04 New features in MyDAC 3.00.1

  • TCustomMyDataSet.Options.LongStrings property added
  • TMyLoader.OnPutData event published again
  • Trial version IDE warning disabled
  • TCRColumn.TotalValue property added

09-Apr-04 New features in MyDAC 3.00

  • Support for Delphi 8 added
  • Connection pooling support
  • Performance improved
  • TMyLoader performance greatly improved
  • TCRGrid sources in Standard edition
  • .NET Windows Forms demo project added
  • ASP.NET demo project added
  • Global variable MySQLClientLibrary added
  • New time trial limitation

05-Feb-04 New features in MyDAC 2.00.3

  • SELECT '' support added
  • Method TMyConnection.Ping added
  • Method TMyConnection.GetExecuteInfo added
  • Mouse wheel support added to CRDBGrid
  • MySQL Embedded server Demo added
  • ConnectDialog Demo added

30-Dec-03 New features in MyDAC 2.00.2

  • BDE Migration Wizard algorithm optimized
  • Limited MySQL server 4.1.1 support added
  • If libmysql.dll not found then raise EOSError (instead of Exception)
  • Property TCustomMyDataSet.InsertId: int64 added
  • timestamp support added for CheckRowVersion = True

24-Nov-03 New features in MyDAC 2.00.1

  • BDE Migration Wizard algorithm optimized
  • Limited MySQL server 4.1.1 support added
  • If libmysql.dll not found then raise EOSError (instead of Exception)
  • Property TCustomMyDataSet.InsertId: int64 added
  • timestamp support added for CheckRowVersion = True

02-Oct-03 New features in MyDAC 2.00

  • Access to MySQL without client library using DirectMySQLObjects by Cristian Nicola
  • Prepare support and new parameter binding schema for MySQL 4.1 added
  • Supports working with MySQL server and Embedded server at the same time
  • BDE migration wizard
  • TMyDump component to store a database or its parts as a script
  • TMyBackup component for backup coping specified tables on the server
  • TMyServerControl component to manage the server and standard service tasks execution
  • TMyLoader component for fast loading data to the server
  • New options of TMyConnection such as Compress, Protocol, Direct and Embedded added
  • New properties ClientVersion, ServerVersion were added to TMyConnection
  • Method ExecSQL in TMyConnection added
  • Methods GetTableNames and GetDatabaseNames in TMyConnection added
  • Property TMyConnection.Charset added
  • Property TMyConnection.IsolationLevel added
  • Methods LockTable and UnlockTable added to TCustomMyDataset
  • Properties Limit and Offset added to TCustomMyTable
  • Method TCustomMyTable.EmptyTable added
  • FetchAll set to True by default
  • Large SQL (INSERT/UPDATE BLOB's) executing performance greatly improved

06-Jun-03 New features in MyDAC 1.50

  • MySQL Embedded Server support added
  • MySQL Server 4.1 limited support added
  • Properties Port and Database in ConnectForm added
  • RefreshRecord performance improved
  • InfoPower demos added
  • 'Explain query...' added to design-time MyQuery menu
  • 'Show CREATE...' added to design-time MyQuery and MyTable menus
  • SQL Generator improved - support for complicated statements added
  • SQL Generator improved - "Quote names" checkbox added
  • Complex keys support added
  • Design-time SQL Generator was simplified
  • TParam -> TDAParam
  • MySQL Embedded Server support added for Kylix
  • Check for datadir present added
  • Changed behavior on calculating affected rows count

04-Apr-03 New features in MyDAC 1.30.2

  • Unit MySQLAccess renamed to MyClasses
  • Property TMyDataSetOptions.LongStrings removed
  • Parameters parsing improved. Symbol ':' in string literals is ignored
  • Search algorithm for 'libmysqlclient.so' under Linux improved

24-Feb-03 New features in MyDAC 1.30.1

  • Refresh improved - current record is restored after Refresh call
  • Property MyConnection.Options.KeepDesignConnected added
  • Property MyConnectDialog.StoreLogInfo published
  • Property MyScript.DataSet was published
  • Property TMyCommand.InsertId: int64 added
  • TINYTEXT -> TMemoField, TINYBLOB -> TBlobField
  • Support for TIMESTAMP (10), TIMESTAMP (4), TIMESTAMP (2) added
  • Support for LIKE expressions in Filter property added

30-Jan-03 New features in MyDAC 1.30

  • MySQL v4.0 support added
  • Dataset 'with many fields' update performance improved
  • Improved performance for opening queries with lot of parameters

26-Dec-02 New features in MyDAC 1.20

  • Kylix2 and Kylix3 support
  • ReportBuilder demos added
  • DBMonitor client implementation moved to COM server
  • Fetch performance improved for DataSet.FetchAll = True
  • 'Connection Lost' error processing improved

08-Oct-02 New features in MyDAC 1.10

  • Delphi 7 support
  • New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on large tables fetch. Controlled by FlatBuffers dataset option
  • Support for blob fields in CachedUpdates mode

26-Aug-01 First release of MyDAC 1.00