I have been contemplating postgres hosted by AWS vs locally using SQLite with my Django app. I have low volume in my app, low concurrent traffic. I may have joins in future since the data is highly relational.
I still chose postgres managed by AWS mainly to reduce the operational overhead, I keep thinking if I should have just gone with sqlite3 though
I host my stuff on railway and while I love SQLite, I usually go with their Postgres offering instead. It's actually less work for me and although I haven't tested this scientifically, it's hard too imagine the SQlite way would save me serious money.
I still chose postgres managed by AWS mainly to reduce the operational overhead, I keep thinking if I should have just gone with sqlite3 though