SQLite - WAL journal mode

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
w.weiss
Posts: 3
Joined: Wed 20 Feb 2019 14:11

SQLite - WAL journal mode

Post by w.weiss » Wed 20 Feb 2019 14:21

Hello!

How can I set the WAL journal mode in SQLite?
I wanted to use it in direct mode for any platform.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: SQLite - WAL journal mode

Post by MaximG » Thu 21 Feb 2019 16:10

The required parameter can be set in UniDAC using a special command SQLite PRAGMA : https://www.sqlite.org/pragma.html#pragma_journal_mode . For example :

Code: Select all

 UniConnection.ExecSQL('PRAGMA journal_mode=WAL');

Post Reply