If just for yourself, get an Apple Dev account and use TestFlight

Or just build and deploy to your iPhone from XCode. No need for TestFlight or paying money for a dev account.

Do I need to upload a new build of the app every 90 days? I’d prefer the app to just work forever without thinking about it.

You need a paid dev account for that. I think self signed installs can run for a year.