[supriyo-biswas]

Btw this concern also applies to other databases, although probably it manifests in the worst way in SQLite. Essentially, you’re doing a WAL over the file systems’ own WAL-like recovery mechanism.

[zaarn]

I've not observed other databases locking up on ZFS, Postgres and MySQL both function just fine, without needing to modify any settings.