I am working on my first SaaS app and I am confused about database hosting. I have a few options in mind, first is self hosting my database on a VM or a container, other is to use a managed service which might cost more. I am worried about backups and data loss. I am pretty well versed with linux and I think I can manage my own server. Currently I'm thinking of setting up a cron job that periodically backups to S3. Is this a viable approach? What are the things I should consider and any other general tips would be really helpful.
Thanks a lot!