Enabling WAL (Write-Ahead Logging) in FeatureWriter for Geopackage | Community

I’m using FME 2021.
WAL is possible pour SQLite since 2010, Geopackage is based on SQLite. I didn’t find any way to activate WAL on a Geopackage FeatureWriter in order to avoid lock problems.

How can I use WAL on Geopackage ? Is it available in later release ?

Page 1 / 1

I don’t think you can do it in the writer, but you could use a SQLExecutor to set that before you start writing data

PRAGMA journal_mode = WAL;

then revert to default after writing

PRAGMA journal_mode = delete;