ZFS encryption works fine but AFAIK it’s complicated to do full disk encryption (for the OS drive) - this is easy to do with with luks. ZFS is not complicated and just works - at least that was my experience. There is also a lot of help available online.
postgresql db (e.g. in Docker) + Dbeaver as GUI client