Also worried about pictures of the little ones. My solution was for the LR database to live on local SSD, and the library/catalog on an SMB share on a ZFS serv

Also worried about pictures of the little ones. My solution was for the LR database to live on local SSD, and the library/catalog on an SMB share on a ZFS server, with weekly backup to AWS Glacier. Other than having to reconnect anytime I wake up the machine from sleep, it works pretty well, and I never have worried about corruption. Only flaw in the plan AFAICT is that if a bug in LR or the Mac introduce corruption XFS will happily store the checksummed corrupted file. I should probably add ZFS snapshots.