loading...

Where do I get an affordable (or free) RDBMS?

patarapolw profile image Pacharapol Withayasakpunt ・1 min read

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?

Discussion

pic
Editor guide
 

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.

 
 

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 * 30 ain't cheap ($13 / mo). Same can also be said for GCP Cloud SQL. Not to mention "complex pricing system".

 
 

we pay about 50 a month for our heroku db. to much if you ask me. Your going to be paying atleast 10 a month.. Have you thought o docker and running local? or VM.?