What's new

Supported target platforms

  • Windows 32-bit and 64-bit
  • macOS 64-bit
  • Mac ARM
  • iOS 64-bit
  • Android 32-bit and 64-bit
  • Linux 32-bit and 64-bit

General usability

  • Direct access to database. 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, FMX, LCL development platforms are 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

  • In Direct mode does not require the SQLite client software (it will be linked in an application statically) and works with a database directly
  • Disconnected Model with automatic connection control for working with data offline
  • Local Failover for detecting connection loss and implicitly reexecuting certain operations

Compatibility

  • Support for the latest versions of SQLite
  • Support for Direct mode (Windows x32 and x64, macOS, iOS and Android)
  • Support for all SQLite data types
  • Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 12 Athens
  • Support for Lazarus 3.0 and Free Pascal 3.2.2
  • Support for Unix and Julian date and time formats
  • Includes provider for UniDAC Express Edition
  • Support for reporting components, including InfoPower, ReportBuilder, FastReport
  • Support for all standard and third-party visual data-aware controls
  • Support for Professional Edition of Delphi and C++Builder for developing client/server applications

SQLite technology support

  • SQLite database encryption in Direct mode using different encryption algorithms
  • Data Type Mapping
  • Support for automatic database creation on connect
  • Support for Shared-Cache mode
  • Support for SQLite user-defined functions
  • Support for SQLite user-defined collations
  • Support for SQLite extensions loaing
  • Support for SQLite R*Tree module
  • Support for SQLite FTS3 and FTS4 extensions
  • Support for autoincrement fields
  • Support for multi-SQL statements executing
  • Fast record insertion with the TLiteLoader component
  • Support for database backup using SQLite Online Backup API with the TLiteBackup component

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 TLiteQuery and TLiteTable components
  • Automatic record refreshing
  • Automatic query preparing
  • Support for ftWideMemo field type in Delphi 2006 and higher

Extended data access functionality

  • Data Encryption in a client application
  • Separate component for executing SQL statements
  • Simplified access to table data with TLiteTable component
  • Ability to retrieve metadata information with TLiteMetaData component
  • Support for using macros in SQL
  • FmtBCD fields support
  • Ability to customize update commands by attaching external components to TLiteUpdateSQL objects
  • Automatic retrieval of default field values
  • Deferred detail DataSet refresh in master/detail relationships
  • LiteDataAdapter 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 TLiteDump components

Script execution

  • Advanced script execution features with TLiteScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

  • Extended SQL tracing capabilities provided by TLiteSQLMonitor 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
  • Automatic design-time component linking
  • More convenient data source setup with the TLiteDataSource component
  • Syntax highlighting in design-time editors

Resources

  • Code documentation and guides in the CHM, PDF, and HXS formats
  • Many helpful demo projects

Licensing and support

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