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@example.com or visit LiteDAC online at https://www.devart.com/litedac/.
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.
By providing access to the most advanced database functionality, LiteDAC allows developers to harness the full capabilities of SQLite and optimize their database applications. Get a full list of supported SQLitefeatures in the Features topic.
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.
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.
The LiteDAC interface retains compatibility with standard VCL data access components, like BDE.
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 the Getting Support topic.
A description of the LiteDAC components is provided in the Component List.
The following list describes the main features of SQLite Data Access Components.
The full list of LiteDAC features can be found in the Features topic.
LiteDAC connects to SQLite either using SQLite client software, or directly without using client software.
In comparison, the Borland Database Engine (BDE) uses several layers to access SQLite, and requires additional data access software to be installed on client machines.
LiteDAC works directly through native SQLite interface. It allows to avoid using BDE or ODBC: