Use Debian or anything stable.
Your passion might wear off. Don’t make it your full time job if you want to preserve it.
I think the 1gb ram of my Raspberry Pi is enough for that.
Just used the default sqlite3 database. Was it slow because of the database?
Nextcloud on Pi was really slow for me.
He looked older at 20