Woailizhi Since I would like to build something pretty custom, I want to start working on my community on my own computer, so not to buy the server or hosting prematurely. Can I then migrate the forum seamlessly by just copying files and recreating the database's schema on a target computer?
Yes you can. In case php versions mismatch, run composer update on the server after uploading.
Woailizhi How is flarum with CDN networks? My community will host many audio files posted by users. How can I make it so to minimize the load and load the data fast?
fof/upload supports block storage/cdn's out of the box like s3/linode etc
Woailizhi If I have some other stuff besides the forum on the website (most probably hosted on Wordpress although I might use Vapor for building my backend), can I integrate it so that the account on the website will integrate with the forum, so that users don't have to have two accounts?
fof/oauth offers oauth interaction, but you can also write some code to more closely integrate by sending underwater calls between flarum and website so that your users don't experience the logging in/out and signing up with flarum (or website)
Woailizhi Is there ap lugin for SSO with Apple or I will need to write my own?
https://next.flarum.org/extension/blomstra/oauth-apple
