I tried to use an ORM that allows both the generous MongoDB, and local SQLite, but failed (via mikro-orm).
Might be better if I use a real online RDBMS with Prisma or TypeORM, but pricing? free tier? per month? per year?
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (4)
Prices come first; though I know Heroku is free up to 10k rows, but I didn't host my website on Heroku anymore.
RDS? Who care about hourly rate? I care more about monthly rate, and
$0.018 * 24 * 30ain't cheap ($13 / mo). Same can also be said for GCP Cloud SQL. Not to mention "complex pricing system".Affordable is a relative point. Depending on your income and outgoings, so you'd need to have a budget in mind. You've already said that $13 a month isn't cheap. I'd say that, depending on the spec, it is. I pay more than that a month just for a small blog which only gets a couple-hundred views a month.
If you want a free service, you're going to have a huge trade-off in performance, and limited space. There's some cheaper (and free) options I've found on hostingadvice.com/how-to/best-free... but I can't recommend any of them as I've not used them before.
Of course, I always have an option of hosting any database on DigitalOcean starting at 5 USD / mo, but should I do it? Cheaper options?
And, will it be better than Heroku PostGRES
hobby-basic? (Where there may be downtimes, and no backup, and perhaps, spinning up time.)The brilliant part about DigitalOcean is their transparency of pricing. A backup of the Droplet can be done once a week automatically for 20% of the cost of the Droplet. A $5 Droplet will cost $1 a month for backups.
It's worth noting that at times you do get what you pay for. For $5 a month on DigitalOcean, your RAM and CPU are shared resources. You shouldn't rely on those to be performant for production workloads. Move outside of the Basic tier and you pay a lot more (starting at 8x more) but get the dedicated resource to have performance available.
Going cheap and accepting shared resource (like every cheap, shared host I am aware of) is going to have a huge performance trade-off.