SQLite on ZFS needs the Fsync behaviour to be off, otherwise SQLite will randomly hang the application as the fsync will wait for the txg to commit. This can take a minute or two, in my experience.

Btrfs is a better choice for SQLite.

▲ supriyo-biswas 2 days ago | parent | next [-]

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 a day ago \| parent [-]
		I've not observed other databases locking up on ZFS, Postgres and MySQL both function just fine, without needing to modify any settings.

▲ throw0101b 2 days ago | parent | prev [-]

> SQLite on ZFS needs the Fsync behaviour to be off […]

    zfs set sync=disabled mydata/mydb001

* https://openzfs.github.io/openzfs-docs/man/master/7/zfsprops...

	▲	zaarn a day ago \| parent [-]
		As noted in a sibling comment, this causes corruption on power failure.