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 Connectivity

Direct Mode

Direct access to SQLite by static linking of the SQLite library No Yes
DAC

Desktop Application Development

Windows Yes Yes
macOS No Yes
Linux No Yes
DAC

Mobile Application Development

iOS Yes Yes
Android No Yes
Direct Connectivity

Database Encryption

SQLite database encryption in Direct mode No Yes
DAC

Data Access Components

Base components
  TLiteConnection
  TLiteQuery
  TLiteSQL
  TLiteTable
  TLiteUpdateSQL
  TLiteDataSource
Yes Yes
Script executing
  TLiteScript
Yes Yes
Fast data loading into the server
  TLiteLoader
No Yes
SQLite Specific Components

SQLite Specific Components

Working with user-defined collations
  TLiteUserCollation
No Yes
Declaration and execution of User-Defined functions
  TLiteUserFunction
No Yes
Obtaining metadata about database objects
  TLiteMetaData
No Yes
Storing a database as a script
  TLiteDump
No Yes
Implements SQLite Online Backup API functionality
  TLiteBackup
No Yes
DataBase Activity Monitoring

DataBase Activity Monitoring

Monitoring of per-component SQL execution
  TLiteSQLMonitor
Yes Yes
Additional Components

Additional Components

Advanced connection dialog
  TLiteConnectDialog
Yes Yes
Data encryption and decryption
  TLiteEncryptor
No Yes
Data storing in memory table
  TVirtualTable
Yes Yes
Dataset that wraps arbitrary non-tabular data
  TVirtualDataSet
Yes Yes
Advanced DBGrid with extended functionality
  TCRDBGrid
Yes Yes
Records transferring between datasets
  TCRBatchMove
No Yes
Design-Time Features

Design-Time Features

Enhanced component and property editors Yes Yes
DataSet Manager No Yes
Cross IDE Support

Cross IDE Support

Lazarus and Free Pascal support No    Click to view restrictions
Single License Price $179.95 $319.95

1 Available only in editions with source code.