SQLite Data Access Components (SQLiteDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQLite database from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based applications connect to SQLite database directly through the SQLite.Net, which is an ADO.NET provider for SQLite. SQLiteDAC is designed to help programmers develop faster and cleaner SQLite database applications with no need to deploy any additional libraries. SQLiteDAC is lightweight and performs well because it is optimized to access SQLite databases directly without adding an OLE DB or Open Database Connectivity (ODBC) layer. SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions. Features: - Direct access to SQLite database. Does not require installation of other data provider layers (such as BDE). - Interface compatible with standard data access methods, such as BDE and ADO. - Full support of the latest versions of SQLite. - Support for all SQLite data types. - Transmission is via XML format, therefore can pass through firewalls. - High overall performance. - Fast controlled fetch of large data blocks. - High performance of applying cached updates with batches. This is controlled by UpdateOptions.UpdateBatchSize property. - High performance batch processing. - Intelligent fetch block size control. - Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property. - Automatic data updating. - Fast data retrieval with TSQLiteDataReader component or using Server CursorKind property of the TCustomClrDataSet. - Data export and import to/from XML.
Tags: Access , Ado , Bde , Data , Dataset , Db , Delphi , Firedac , Net , Odbc