Features

In this topic you will find the complete LiteDAC feature list sorted by categories.

Supported target platforms

• Windows 32-bit and 64-bit
• macOS 64-bit
• Mac ARM
• iOS 64-bit
• iOS Simulator ARM 64-bit
• Android 32-bit and 64-bit
• Linux 32-bit (only in Lazarus and Free Pascal) 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

• Full support of the latest versions of SQLite
• Direct mode support for Windows x32 and x64, MacOS, iOS and Android
• Support for all SQLite data types
• Support for Unix and Julian date and time formats
• Compatible with all IDE versions starting with Delphi 6, C++Builder 6, except Delphi 8, and with Free Pascal
• Includes provider for UniDAC Express Edition
• Wide reporting component support, including support for InfoPower, ReportBuilder, FastReport
• Support of all standard and third-party visual data-aware controls
• Allows you to use Professional Edition of Delphi and C++Builder to develop 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 loading
• 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