Skip to main content
Question

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

  • July 31, 2025
  • 1 reply
  • 14 views
benoitda
Contributor
Forum|alt.badge.img+2

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 ? 

danilo_fme

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+64
  • hkingsburyCelebrity
  • Celebrity
  • July 31, 2025

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;

 

Community Stats

32,128
Posts
121,966
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.