SQLite Data Access Components History

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

25-Apr-16 New Features in LiteDAC 2.7:

  • RAD Studio 10.1 Berlin is supported
  • Lazarus 1.6 and FPC 3.0.0 is supported
  • Support for the BETWEEN statement in TDADataSet.Filter is added
  • Now the Direct mode is based on the SQLite engine version 3.12.0
  • Support for URI filenames is added
  • Data Type Mapping performance is improved
  • Performance of TDALoader on loading data from TDataSet is improved

09-Sep-15 New Features in LiteDAC 2.6:

  • RAD Studio 10 Seattle is supported
  • INSERT, UPDATE and DELETE batch operations are supported
  • Now Trial for Win64 is a fully functional Professional Edition
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Now the Direct mode is based on the SQLite engine version 3.8.11.1
  • The EnableSharedCache option of the Connection component for non-Windows platforms is added

14-Apr-15 New Features in LiteDAC 2.5:

  • RAD Studio XE8 is supported
  • AppMethod is supported
  • Direct mode for Mac OS X, iOS and Android platforms is supported
  • Database encryption for Mac OS X, iOS and Android platforms is supported
  • Now the Direct mode is based on the SQLite engine version 3.8.9
  • The TLiteConnection.Options.ConnectMode property is added
  • The TLiteConnection.ReleaseDatabaseMemory method is added
  • The TLiteConnection.IsDatabaseReadOnly method is added
  • Converter from liteNull data formats to ftExtended is added

15-Sep-14 New Features in LiteDAC 2.4:

  • RAD Studio XE7 is supported
  • Lazarus 1.2.4 is supported
  • Demo projects for FastReport 5 are added
  • The TCustomDADataSet.GetKeyFieldNames method is added
  • The ConstraintColumns metadata kind for the TDAMetadata component is added
  • Now the Direct mode is based on the SQLite engine version 3.8.6
  • TLiteBackup component is added

29-Apr-14 New Features in LiteDAC 2.3:

  • RAD Studio XE6 is supported
  • Android in C++Builder XE6 is supported
  • Lazarus 1.2.2 and FPC 2.6.4 is supported
  • SmartFetch mode for TDataSet descendants is added
  • The TLiteDataSetOptions.MasterFieldsNullable property is added
  • Now the Direct mode is based on the SQLite engine version 3.8.4.3
  • The EnableLoadExtension option is added for the Connection component
  • Now update queries inside TDataSet descendants have correct owner

25-Dec-13 New Features in LiteDAC 2.2:

  • iOS in C++Builder XE5 is supported
  • Direct mode for x64 platform is supported
  • Now the Direct mode is based on the SQLite engine version 3.8.2
  • RAD Studio XE5 Update 2 is now required
  • Now .obj and .o files are supplied for C++Builder
  • Compatibility of migrating floating-point fields from other components is improved

19-Sep-13 New Features in LiteDAC 2.1:

  • RAD Studio XE5 is supported
  • Application development for Android is supported
  • Lazarus 1.0.12 is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • The possibility to use conditions is added
  • Now the Direct mode is based on the SQLite engine version 3.8.0.2
  • The TLiteUserCollation component is added
  • Support of the IN keyword in the TDataSet.Filter property is added
  • Like operator behaviour when used in the Filter property is now similar to TClientDataSet
  • The possibility to use ranges is added
  • The Ping method for the Connection component is added
  • The AllowImplicitConnect option for the Connection component is added
  • The SQLRecCount property for the Query and StoredProc components is added
  • The ScanParams property for the Script component is added
  • The RowsAffected property for the Script component is added
  • The 'True' Boolean value is now saved in the database as 1
  • Conversion from the liteText type to all the supported types is added.

25-Apr-13 New Features in LiteDAC 2.0:

  • RAD Studio XE4 is supported
  • NEXTGEN compiler is supported
  • Application development for iOS is supported
  • FPC 2.6.2 and Lazarus 1.0.8 are supported
  • Connection string support is added
  • Possibility to encrypt entire tables and datasets is added
  • Possibility to determine if data in a field is encrypted is added
  • Support of TimeStamp, Single and Extended fields in VirtualTable is added
  • Now the Direct mode is based on the SQLite engine version 3.7.16.2
  • Now SQLite string data type without length is mapped as ftMemo instead of ftString
  • Converter from Unix and Julian date formats to ftDateTime is added

17-Dec-12 New Features in LiteDAC 1.6

  • RAD Studio XE3 Update 1 is now required
  • C++Builder 64-bit for Windows is supported
  • LastInsertId property for TLiteSQL and TLiteQuery is added

10-Sep-12 New Features in LiteDAC 1.5:

  • RAD Studio XE3 is supported
  • Windows 8 is supported
  • Now the Direct mode is based on the SQLite engine version 3.7.13
  • Extended error codes support is added
  • Components for FastReport 4.0 are added

01-Aug-12 First release of LiteDAC 1.0