SQLite LiteDAC vs. FireDAC

The sample SQL scripts

LiteDAC test application

This is a crude SQLite experimental application exploring the features and potentials of SQLite
as implemented with Devart LiteDAC Professional v.6.1.0 and Embarcadero Delphi 10.4.2 Professional.

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.

Download: LiteDACtest.zip (build 69 + chinook.db3 sample db).
Specifications: 64-bit Windows application.
LiteDAC version used: v. 6.1.0 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):

"tables"
"tbl_name"
"sqlite_version()"
"sql"		 String(40)
String(40)
String(8)
Memo
See also the Help menu [MapRules].

FireDAC test application (for comparison)

The comparable FireDAC version.
Download: FireDacSQLite.zip (build 45 + sqlite3.dll).
Specifications: 64-bit Windows application.
Build 44: Added auto ROLLBACK in case of TRANSACTION execution error, and added BeforeRefresh.Abort in case of unterminated transaction.
Data MapRules: None used.
Transaction responsive state:

Best Regards,
Niels Knabe