TSQLiteConnection feature request

[Wuping_Xin]

Can we add features to allow a(dvanced) user to specify LockingMode and SynchromousMode:

Pragma statements supported by SQLite

Pragma statements supported by SQLite

Either add them to the existing Params property, or, add a NEW PRAGMAs property, so user can add SQLite pragmas to be executed at TSQLiteConnection.Create.
Thank you.

[wlandgraf (Wagner Landgraf)]

You can simply execute them as SQL statements:

TSqliteDatabase connection configuration

SharedCache false and LockingMode normal are the default values for SQLite and thus for TMS Aurelius native adapter. But all of them can be configured directly according to SQLite documentation. For LockingMode and Synchronous, for example, you can simply execute pragma statements directly:  var Statement: IDBStatement; begin Statement := Connection.CreateStatement; Statement.SetSQLCommand('pragma synchronous = normal'); Statement.Execute; Statement := Connection.CreateStatement; …