Hey guys, for a long time I've been wanting to learn how to create/manage SQL databases and I was wanting some advice. I run a Proxmox server with TrueNAS Core internally installed with the hard drives passed through. For pretty much everything I use that requires external storage (i.e Jellyfin, Qbittorrent), I went the route of making independent datasets, then created NFS shares afterwards. This method for mass media has been mostly perfect, but I've been told NFS is frowned upon for SQL databases out of it's issues with file locking, which makes sense I've had this issue inside Jellyfin in the past.

If that's the case, what do you think is the most efficient way of hosting a SQL database with Proxmox and TrueNAS Core being passed through? All of the ideas I have in mind seem to have their own issues. My other ideas included making an iscsi share inside trueNAS, but that makes me worry about scalability since from what I understand you have to manually specify the drives and partition space. The next idea was to just install sql directly from the TrueNAS plugins section, but apparently that is extremely outdated and not recommended.

I feel like this issue has been giving me trivial results online out of the plentiful ways of doing this, so I figured I might as well ask. It seems like a common issue and I'm not looking up the correct terms.