Can't use ~ in dotenv file in Settings

[PrettyWood]

@HenryDashwood The issue here is that you use ~/.env, which is not directly resolved by pathlib.Path.
You could change it to

   class Config:
        env_file = os.path.expanduser('~/.env')

Maybe we could add expanduser directly in the code when env_path is created

Originally posted by @PrettyWood in #1368 (comment)