> SQLite on ZFS needs the Fsync behaviour to be off […]
zfs set sync=disabled mydata/mydb001
As noted in a sibling comment, this causes corruption on power failure.