not detecting changes to SQLite in WAL mode

[malhal]

On OS X 10.11.6 with fswatch 1.9.2

$fswatch Untitled.sqlite-wal

Make a change to the database (e.g. add a row) and no file changes are reported despite the file having actually changed, timestamp updated. Reporting this issue because the Readme said there are no known issues with FSEvents method. On the other hand, the poll_monitor method does report the changes correctly.

$fswatch -m poll_monitor Untitled.sqlite-wal
path_to/Untitled.sqlite-wal

Recreate this using Base first creating the new Untitled.sqlite then in options under journal_mode select 'wal'. Click the + add a table name Event and click plus and enter Name title and Type TEXT. Then on the Table, Data tab use the plus to add the rows to the database to make the changes.

The wal file might be being written to in a way that doesn't trigger an FS event. Finder doesn't detect the change either.

[emcrisostomo]

Hi @malhal,

I've just tried to replicate it and I confirm that the FSEvents API does not return an event in the situation you describe. If I'm mistaken about something, I don't know what it is. The fact that Finder doesn't detect the change either is a strong indicator that FSEvents is incapable of detecting it.

This issue is worth some research time.

[holyspidoo]

Exact same problem I ran into :)

Any hope for this issue? Or is there a better way altogether to monitor sqlite files for changes (instead of monitoring files changes)?

[nicad]

Also ran into this while looking at sqlite files from iCloud

[hepcat72]

Yup. +1. I wrote a script to process reminders changes and thought using fswatch might be an efficient means of deciding when it should run...

I guess it shouldn't be too bad to use -m poll_monitor for my use case with a single file.