SQLite LiteDAC experimentals
LiteDAC test application
Update: 2025-01-29
This is a crude SQLite experimental application exploring the features and potentials of SQLite
as implemented with Devart LiteDAC Professional v.6.3.2 and Embarcadero Delphi 10.4.2 Professional.
Application in dynamic development - do not use with critical data.
The application is in a phase of development and is free to download without any responsibility of the author.
Experiments are mainly about how to deal with data typings on the fly.
Optional UNICODE.
The statements of each SQL-tab are stored from session to session in individual UTF-8 encoded text files named <app-name>n.sql according to the SQL-tab number.
Application history
Download: LiteDACtest.zip (vers. 2.7.0.139 + Northwind.db3 sample db).
Specifications: 64-bit Windows application.
LiteDAC version used: v. 6.3.2 professional.
OS: 64- bit Windows including Windows 10 & 11.
DLL linkage mode via INI-file:
[SQLite] DLLembedded = 0 mode: 64-bit sqlite3.dll located in the exe directory
[SQLite] DLLembedded = 1 mode: (embedded mode) = no dependencies at all.
Application design fixed data type MapRules by column names (case insensitive):
"sqlite_version()" |
String(8) String(40) Memo String(40) String(45) String(45) |
See also the Help menu [MapRules].
Transaction responsive state (available since LiteDAC 6.2 of 2024-04-23):
Optionally* enabled ftAutoinc field type sensing:
* Provided the EnableAutoInc property of LiteTable and LiteQuery modules has been set = True (available from LiteDAC vers. 6.3.2).
Niels Knabe