Since many years I use PSU standalone for organiszing my private family foto collection on one single windows installation. My wife is using her own PC without PSU (only windows foto functions) and she is adding the most of the pictures.
The full installation looks like following.
- Windows PC 1 (wife) has full copy of all images on the local hard drive and synchronizes with a Synology NAS mainly for backup.
- Windows PC 2 (myself) with latest 5.6... PSU. PSU standalone database is stored local on the PC 2. PSU catalog points on the NAS Drive images and stores only thumbnails on PC2 within PSU catalog.
- I own an 5-6 year old Synology NAS, not the most powerfull variant though, but plenty of disc space.
- I own a rather new ARM64 linux based home automation server, with docker / portainer pre-installed. I assume this system is faster then the NAS, but very limited in disk space
I am thinking of running PSU server in order to teach and have my wife organising PSU together on her and my PC. We are looking at 25.000 pics + currently
My ideas would be to either use the "nativ" PostgrSQL on Synology or to install a docker version in the home automation server, because it may be faster.
But would that mean that all my images would have to be stored in the postgreSQL-Database within the server and not on the NAS drive folder structure anymore? Or is the database only carying for meta-data and pointing to the picture-directory, which could still be on the NAS?
Would I still be able to do a symple file Sync between the NAS and a PC-harddrive only to have another backup on another location (physically apart from the NAS)?
Will a postgreSQL on a "small" linux based server having enough performance or will it be much slower then my standalone version?
Additionnaly: I am not very fit in Docker / Linux / and so on...but most of the times I get things working after a while.
Or is there any other suggestion on my system setup?
What bothers me most currently, is that the folder checkup in PSU standalone takes ages. And that is what I do to get the latest changes that my wife performed (relocating files in folders / deleting files / adding files).