I need a hosted database for a project that will probably stay very small. My requirements are:

• Ideally free if the usage is low. I'm only expecting a few hundred form submissions.

• It needs to stay active. Supabase's free tier should be more than enough for me, however they pause the database after a week of activity. This could make the site break.

• Can scale up automatically to handle more traffic. I'm not expecting anything crazy and happy to pay if the usage increases, but this needs to happen automatically so the site doesn't have any downtime.

• My first choice would be Postgres, then another SQL, but Mongo would also be OK.

I have a personal site. In it I have my own CMS for my posts, I have a journal app, an RSS reader, etc. I'm currently using Railway with MySql because they have a $5 credit per month so my bill comes out to about $1 a month.

However, I'd really like to keep my data within AWS for security, replicability, and ease of use reasons.

BUT I have problems with RDS and DynamoDB:

RDS: Free tier is very limited, seems very easy to go into non-free tier territory which is super expensive. Cheapest non-free tier is $15/month (too pricey for my use case)

DynamoDB: Proprietary and no-SQL. I've used DynamoDB a ton before, but I still like SQL databases for querying.

I would love it if there was a simple SQLite database option. I can't do that since my app is running inside a Docker container.

I don't think S3 Table Buckets are really fully developed yet so I want to hold off on those. And using S3 as a DB technically works but querying content is a nightmare.