Re:Amazon RDS now supports PostgreSQL 9.6.1
by tokenizerrr on Tuesday November 15, 2016 @07:14AM
(#12957372)
Do people really talk to databases over WAN (which means relatively high latency)? I was under the impression this was a bad idea.
Re:Amazon RDS now supports PostgreSQL 9.6.1
by oskari on Tuesday November 15, 2016 @10:23AM
(#12958719)
Many of the hosting providers provide PG as a service in multiple clouds / hosting providers allowing you to run your applications on your own VMs in the same cloud. So while you would be using the external IP addresses to communicate with the database it'd still be in the same datacenter.
Also, as pointed out in the parent post, some of the hosting providers such as us (Aiven, https://aiven.io) are directly involved in PostgreSQL development and one of the bugfixes in the latest releases (9.6.1 and 9.5.5) that just came out was contributed by us.
Re:Amazon RDS now supports PostgreSQL 9.6.1
by tokenizerrr on Tuesday November 15, 2016 @01:40PM
(#12960878)
Running within the same cloud provider makes sense, I hadn't thought of that.
Re:Amazon RDS now supports PostgreSQL 9.6.1
by imaginology on Tuesday November 15, 2016 @08:46AM
(#12957889)
It depends on the type of application and the requirements and expectations of its users. I wouldn't recommend having a web app talk to its database over a WAN, for example. Unless it had a decent caching layer in between.
Re:Amazon RDS now supports PostgreSQL 9.6.1
by wasd on Tuesday November 15, 2016 @11:51AM
(#12959734)
That's a great point. I've heard of some smaller companies (compose, elephantsql) but to be honest, I have definitely not considered them. The reason is that I just want all inclusive solution and I don't have much context for these companies. How healthy they are, what's the likelyhood of them going out of business, etc.
I think you bring up a good point. I'm going to put aside my bias and give a smaller company a shot. Thanks for sharing.
Re:Amazon RDS now supports PostgreSQL 9.6.1
by akbar501 on Tuesday November 15, 2016 @01:17PM
(#12960623)
Compose.io is owned by IBM. I had a chance to meet both the Compose team and a few people from IBM at the DataLayer conference. They are passionate and smart.
Compose is in a sweet spot right now. They run with the speed of a startup, but have access to IBM's massive resources. Really the best of both worlds.
See for example this staggering list of hosting providers in Europe: https://www.postgresql.org/support/professional_hosting/euro...
Yes, most of those are smaller companies. But some of these companies are directly involved in the development of PostgreSQL (just look at the PostgreSQL-hackers mailing list), so they should really know what they are doing!