[russellthehippo]

Respectfully (thanks haha) - yeah probably right. Original intent was to use inotify type thing but i avoided per-platform differences at the outset. this was definitely a for fun project that blew up unintentionally and am working to harden/improve.

Love Fly.

[ncruces]

One of the things people seem to forget is that SQLite itself polls every millisecond or so to grab a lock.

So yes, don't use this in a mobile device, or a server if you want to let the CPU enter a low power state.

Otherwise, a single thread doing this in an otherwise idle server, doesn't seem that terrible. And if it's not idle, inotify won't help you (need to query what changed afterwards).

[russellthehippo]

Appreciated your input on the original thread as well. Maybe I should note this recommendation in the docs or something.