Of course, I don't mean about Heroku free tier.
What if I go beyond 10k rows? What if sleeping time and dyno size matters? What is the starting price, and how does it escalate? What about related services, like Hasura or Scalegrid?
IMO, with JOIN and INDEX, I can easily exceed 10k rows.
What I want beyond relational data would be full-text-search and automatic backup.
Top comments (2)
I know your question is heroku specific, but have you considered using a VPS?
A $5 VPS from either DigitalOcean or Linode would make managing your costs a lot more predictable not to talk of cheaper.
AFAICT nothing prevents you from using Heroku for your code and a VPS for your database
Installing postgres on an Ubuntu server is a s simple as
Creating the database
And so on.
My appologies if I've somehow missed the obvious, but if your project requirements/limitations do not bind you to using Heroku for your entire stack, perhaps you might want to consider this alternative
I do consider that, but I am not sure if I am ready for sysadmin job.
Other than the database itself, I will need,
I will consider it later, after I exceed the limit.