SQLite Data Access Components Editions
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. The detailed list of all LiteDAC features can be found on the features page.
| Features | 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 |
|
|
|
| Single License Price | $169.95 | $279.95 | |
1 Available only in editions with source code.