I use digikam, photos live on my NAS which is mounted locally at the OS level, and the db file is fully local but backed up to the NAS. Perhaps not exactly what you're after.