What kind of a database would you recommend for storing assets? Did you have a chance to test and compare the efficiency of different ones and how do they manage to handle repositories which contain hundreds of gigabytes of data?
I think with SQLite you will be fine. The size GB or TB, doesn't matter at all. What matters is the amount of commits and the file count. But with a decent machine you should be good to go.
That might be not enough, because then the connection would be insecure. You may need to look into ssl certificates as well for an https connection. The other thing is that you need a static IP address.
You don't need to. The problem with the build in Unreal Git plugin is, that it's not supporting LFS and will slow you down each time when you do a save. It's better to submit with the Git client.