Where can I host postgreSQL databases at affordable rates

Where can i host my databases at affordable rates?

hetzner, one provider

Assclown said:

Where can i host my databases at affordable rates?

Click to expand...

Does it have to be Postgres, or can you migrate to mysql? What are the number of reads and writes do you anticipate? Do you want to self host?

If you are ok with managed databases, look into planet scale and amazon aurora.

If you are looking to self host, perhaps install something like vitess on some kubernetes cluster. This option will probably be cheaper if you have a large db. For smaller dbs with not much writes, I personally wouldn't bother with self hosting vitess. I will just spin up a mysql/postgres docker container and use it instead.

Are you looking to self-host, or are you okay with using managed services? If your dataset has like 10's of thousands of rows and handles many queries, then I think you might find Planet Scale to be quite expensive considering the fact that you pay for every single row that queries search through. Personally, I think Oracle Cloud free tier is ideal since their compute and networking are top-notch for the price. They also give you 10 TB of free transfer per month and have bandwidth alliances with multiple CDNs.

If you don't have to use PostgreSQL, or it's not required for every query, you can use Aerospike as a secondary store for insanely fast lookups. In benchmarks, Aerospike on disk outperforms Redis and all other caching servers by a large margin, and the free version come with very generous use abilities.

ClickHouse might also be a faster alternative to PostgreSQL, but required a lot more to setup and isn't as straightforward. But it should allow you to use less compute while performing better than PostgreSQL.

I also think that Planet Scale and SingleStore both have backward compatibility issues, so you could really screw yourself over by using them, then deciding to move to a different database and/or provider.

Anyways, if you want managed, here are some database providers that I know of that have serverless pay-go options:
https://www.cockroachlabs.com/pricing/
https://planetscale.com/pricing
https://www.pingcap.com/tidb-serverless-pricing-details/
https://neon.tech/pricing

I mean there are more, but I can only personally vouch for Planet Scale.

Gogol said:

Does it have to be Postgres, or can you migrate to mysql? What are the number of reads and writes do you anticipate? Do you want to self host?

If you are ok with managed databases, look into planet scale and amazon aurora.

If you are looking to self host, perhaps install something like vitess on some kubernetes cluster. This option will probably be cheaper if you have a large db. For smaller dbs with not much writes, I personally wouldn't bother with self hosting vitess. I will just spin up a mysql/postgres docker container and use it instead.

Click to expand...

Damn techie is in the house.

It wont let me edit my post, but PlanetScale is actually not free anymore and starts at $39/mo.

BassTrackerBoats said:

Damn techie is in the house.

Click to expand...

Haha or may be a tech lover. I wish these techs were available 10 years ago. Thanks man.

Gogol said:

Haha or may be a tech lover. I wish these techs were available 10 years ago. Thanks man.

Click to expand...

The truth is I have uber respect for you techies and rely on those in your end of the industry all the time but I won't say that in public.

I had a chat with the CTO for the forum today, he's a colleague and friend, and was impressed but I would not tell him that because we bust stones all the time but he knows I have respect.

For me, neironvps.com works well. Go ahead, they offer enough disk space, bandwidth, email services, free domain name, free website builder tool (CMS tools such as WordPress, Drupal, or Joomla).

Pleased with Allwebhost.com - the service is also great, i've had many inquiries promptly answered so on the overall this host comes highly recommended.