New Features in LiteDAC 6.1
- Lazarus 3.0 is supported
- The RealAsDouble option for the Connection component is added
New Features in LiteDAC 6.0
- Now the Direct mode is based on version 3.42.0 of the SQLite engine
- Added support for RAD Studio 12
- Added support for macOS Sonoma
- Added support for iOS 17
- Added support for Android 13
- Added support for nested Macros in SQL queries
- Added support Display Format for Aggregate fields
- Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
New Features in LiteDAC 5.3
- Added support for RAD Studio 11 Alexandria Release 3
- Added support for iOS Simulator ARM 64-bit target platform
- Added support for Lazarus 2.2.6
- Added support for GUID fields stored in binary format
- Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
- Added support for the mathematical operations in TDADataSet.Filter
- Added support for Aggregate Fields and InternalCalc Fields
- Added ability to restore from file with TEncoding via the Dump component
- Improved reading fields of the BLOB family
- Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
New Features in LiteDAC 5.2
- Now the Direct mode is based on version 3.39.2 of the SQLite engine
- Added support for RAD Studio 11 Alexandria Release 2
- Added support for Lazarus 2.2.2
- Added support for iOS 15
- Added support for Android 12
- Added the CloneCursor method for Query and Table components that allows sharing data between datasets
- Improved the performance of exporting to XML
- Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
- Fixed bug with mapping table columns of integer types to string fields
- Fixed bug when a connection string parameter value contains a single quote
New Features in LiteDAC 5.1
- RAD Studio 11 Alexandria Release 1 is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- macOS Monterey is supported
- Now the Direct mode is based on version 3.37.2 of the SQLite engine
New Features in LiteDAC 5.0
- RAD Studio 11 Alexandria is supported
- macOS ARM is supported
- Added demo project for FastReport FMX
- Added the IntegerAsLargeInt option for the Connection component
New Features in LiteDAC 4.4
- RAD Studio 10.4.2 Sydney is supported
- macOS 11 Big Sur is supported
- iOS 14 is supported
- Android 11 is supported
- The JournalMode option in the Connection component is added
- The LockingMode option in the Connection component is added
- The Synchronous option in the Connection component is added
- Performance with default values of the new options is significantly improved
- Performance of batch operations is improved
- Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
New Features in LiteDAC 4.3
- Lazarus 2.0.10 and FPC 3.2.0 are supported
- Performance of Batch Insert, Update, and Delete operations is improved
New Features in LiteDAC 4.2
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
New Features in LiteDAC 4.1
- Android 64-bit is supported
- Lazarus 2.0.6 is supported
- Now Trial edition for macOS and Linux is fully functional
New Features in LiteDAC 4.0
- macOS 64-bit is supported
- Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
New Features in LiteDAC 3.5
- Lazarus 2.0.2 is supported
- Now the Direct mode is based on the version 3.27.2 of the SQLite engine
- Multi-threading support is improved
- The DefaultSortType property for TVirtualTable is added
- Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
New Features in LiteDAC 3.4
- RAD Studio 10.3 Rio is supported
- Support for the BreakExec method in the Query component is added
- Support of UPPER and LOWER functions for Unified SQL is added
New Features in LiteDAC 3.3
- Lazarus 1.8.4 is supported
- Performance of batch operations is improved
- Demo projects for IntraWeb 14 are added
- WAL in the Direct Mode for non-Windows platforms is supported
New Features in LiteDAC 3.2
- Direct Mode in Lazarus is supported
- Lazarus 1.8 and FPC 3.0.4 are supported
- BIT type is supported
- Support for custom constraints is added
- The UseBlankValues property for the Loader component is added
- The TLiteDataSetOptions.UnknownAsString property that allows mapping fields of unknown type as ftString instead of ftMemo is added
- The TLiteDataSetOptions.AdvancedTypeDetection property that allows describing columns having data of different types is added
New Features in LiteDAC 3.1
- Now the Direct mode is based on the SQLite engine version 3.20.0
- Custom SQL aggregate functions are supported
New Features in LiteDAC 3.0
- RAD Studio 10.2 Tokyo is supported
- Linux in RAD Studio 10.2 Tokyo is supported
- Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
- Now the Direct mode is based on the SQLite engine version 3.17.0
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
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
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
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
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
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
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
- Flexible management of conditions in the WHERE clause 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.
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
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
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
New Features in SQLite Data Access Components 1.0.1