SQLite Data Access Components comes in two editions: Standard and Professional.
The Standard edition includes the LiteDAC basic connectivity components. LiteDAC Standard Edition is a cost-effective solution for database application developers who are looking for high-performance connectivity to SQLite for secure, reliable, and high-speed data transmission.
The Professional edition shows off the full power of LiteDAC, enhancing LiteDAC Standard Edition with support for SQLite-specific functionality, such as access to SQLite in the Direct mode using static linking of the SQLite library in an application, database encryption, and advanced dataset management features.
You can get Source Access to LiteDAC Professional Edition by purchasing a special LiteDAC Professional Edition with Source Code, which includes the source code of all component classes. The source code of DataSet Manager is not distributed. The source code of the Direct mode for SQLite is distributed as precompiled packages.
The matrix below compares the features of LiteDAC editions. See Features for the detailed list of LiteDAC features.
Feature | Standard | Professional | |
---|---|---|---|
Direct Mode |
|||
Direct access to SQLite by static linking of the SQLite library | |||
Desktop Application Development |
|||
Windows | |||
macOS | |||
Linux | |||
Mobile Application Development |
|||
iOS | |||
Android | |||
Database Encryption |
|||
SQLite database encryption in Direct mode | |||
Data Access Components |
|||
Base Components:
TLiteConnection TLiteQuery TLiteSQL TLiteTable TLiteUpdateSQL TLiteDataSource |
|||
Script executing
TLiteScript | |||
Fast data loading into the server
TLiteLoader | |||
SQLite Specific Components |
|||
Working with user-defined collations
TLiteUserCollation |
|||
Declaration and execution of user-defined functions
TLiteUserFunction |
|||
Obtaining metadata about database objects
TLiteMetaData |
|||
Storing a database as a script
TLiteDump |
|||
Implements SQLite Online Backup API functionality
TLiteBackup |
|||
DataBase Activity Monitoring |
|||
Monitoring of per-component SQL execution
TLiteSQLMonitor |
|||
Additional components |
|||
Advanced connection dialog
TLiteConnectDialog |
|||
Data encryption and decryption
TLiteEncryptor |
|||
Data storing in memory table
TVirtualTable |
|||
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet |
|||
Advanced DBGrid with extended functionality
TCRDBGrid |
|||
Records transferring between datasets
TCRBatchMove |
|||
Design-Time Features |
|||
Enhanced component and property editors | |||
DataSet Manager | |||
Cross IDE Support |
|||
Lazarus and Free Pascal Support |
1 Available only in Professional Edition with Source Code.