LiteDAC Overview

SQLite Data Access Components (LiteDAC) is a library of components that provides direct access to SQLite databases from Delphi, C++Builder and Lazarus (FPC). LiteDAC directly uses SQLite client software to connect to database. LiteDAC is designed to help programmers develop really lightweight, faster and cleaner SQLite database applications

The LiteDAC library is actively developed and supported by the Devart Team. If you have questions about LiteDAC, email the developers at [email protected] or visit LiteDAC online at https://www.devart.com/litedac/.

Advantages of LiteDAC Technology

LiteDAC is a direct connectivity database wrapper built specifically for SQLite. LiteDAC offers wide coverage of the SQLite feature set and emphasizes optimized data access strategies.

Wide Coverage of SQLite Features

By providing access to the most advanced database functionality, LiteDAC allows developers to harness the full capabilities of SQLite and optimize their database applications. View the full list of supported SQLite features in Features.

Native Connection Options

LiteDAC provides direct access to SQLite databases without envolving SQLite client software that heightens its performance. LiteDAC-based database applications are easy to deploy, do not require installation of other data provider layers (such as BDE), and tend to be faster than those that use standard data connectivity solutions.

Optimized Code

The goal of LiteDAC is to enable developers to write efficient and flexible database applications. The LiteDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers.

Compatibility with other Connectivity Methods

The LiteDAC interface retains compatibility with standard VCL data access components, like BDE.

Development and Support

LiteDAC is a SQLite connectivity solution that is actively developed and supported. LiteDAC comes with full documentation, demo projects, and fast (usually within two business days) technical support by the LiteDAC development team. Find out more about getting help or submitting feedback and suggestions to LiteDAC Development Team in Getting Support.

A description of the LiteDAC components is provided in the Component List.

Key Features

The following list describes the main features of SQLite Data Access Components.

• Direct access to database data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)
• Full support of the latest versions of SQLite
• Support for all SQLite data types
• Disconnected Model with automatic connection control for working with data offline
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TLiteQuery and TLiteTable components.
• Unicode and national charset support.
• Supports many SQLite-specific features, such as user-defined functions.
• Advanced script execution functionality with the TLiteScript component.
• Support for using macros in SQL
• Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications.
• Includes annual LiteDAC Subscription with Priority Support.
• Licensed royalty-free per developer, per team, or per site

The full list of LiteDAC features can be found in Features.

How does LiteDAC work?