Amazon RDS for PostgreSQL • Hacker News Board

Re: Amazon RDS for PostgreSQL

#11

Post by MrGando » Thu, Nov 14, 2013, 5:29 PM UTC

runako wrote: post #10

MrGando wrote: post #2

I think that the 'simple monthly calculator' hasn't yet included PostgreSQL instances?

MySQL (free) and Oracle BYOL (no additional license cost) are the same cost at RDS. Since PG is free, I'd guess the cost will be the same as MySQL.

That's what I think too, they should state MySQL/PostgreSQL or something like that in the calculator though.

Re: Amazon RDS for PostgreSQL

#12

Post by sillysaurus2 » Thu, Nov 14, 2013, 5:30 PM UTC

Will anyone please explain the tactical reasons why PostgreSQL won? It's pretty obvious it has. I've basically ignored the database wars for a few years, so it's kind of interesting to see that everyone's using PostgreSQL now.

Re: Amazon RDS for PostgreSQL

#13

Post by frakkingcylons » Thu, Nov 14, 2013, 5:30 PM UTC

I'd be most curious to know how the performance/dollar ratio stacks up to Heroku's Postgres offering.

Re: Amazon RDS for PostgreSQL

#14

Post by jakozaur » Thu, Nov 14, 2013, 5:31 PM UTC

Wondering what is the easiest way to convert from MySQL RDS to Postgres. Any hints?

Re: Amazon RDS for PostgreSQL

#15

Post by kvinnako » Thu, Nov 14, 2013, 5:33 PM UTC

sillysaurus2 wrote: post #12

Will anyone please explain the tactical reasons why PostgreSQL won? It's pretty obvious it has. I've basically ignored the database wars for a few years, so it's kind of interesting to see that everyone's using PostgreSQL now.

One of many reasons is MySql being bought by Oracle and name change/lost of community backing etc...along with some missing advanced technical features....

Re: Amazon RDS for PostgreSQL

#16

Post by ptio » Thu, Nov 14, 2013, 5:34 PM UTC

Great news! Now I don't need to setup PostgreSQL myself.

Here is a related whitepaper if you still want to setup PostgreSQL yourself: http://media.amazonwebservices.com/AWS_RDBMS_PostgreSQL.pdf

Re: Amazon RDS for PostgreSQL

#17

Post by craigkerstiens » Thu, Nov 14, 2013, 5:34 PM UTC

sillysaurus2 wrote: post #12

Will anyone please explain the tactical reasons why PostgreSQL won? It's pretty obvious it has. I've basically ignored the database wars for a few years, so it's kind of interesting to see that everyone's using PostgreSQL now.

I've written a couple of blog posts about what makes Postgres a great database, many of these reasons are why its now preferred by so many devs - http://www.craigkerstiens.com/2012/04/30/why-postgres/

Re: Amazon RDS for PostgreSQL

#18

Post by onedognight » Thu, Nov 14, 2013, 5:34 PM UTC

This is great news, but unlike for Amazon's MySQL offering, they do not yet support read replicas for PostgreSQL.

Re: Amazon RDS for PostgreSQL

#19

Post by kvinnako » Thu, Nov 14, 2013, 5:34 PM UTC

Somehow it seems pretty costly...Wouldn't it be cheaper for me to just run it on my virtual instance that's hosting the app and probably just back it up with S3.

Re: Amazon RDS for PostgreSQL

#20

Post by avenger123 » Thu, Nov 14, 2013, 5:36 PM UTC

sillysaurus2 wrote: post #12

Will anyone please explain the tactical reasons why PostgreSQL won? It's pretty obvious it has. I've basically ignored the database wars for a few years, so it's kind of interesting to see that everyone's using PostgreSQL now.

I wouldn't say PostgresSQL has won. MySQL is still very relevant.

I would say that if you are just starting out and you already know MySQL and you are proving out your MVP, MySQL is still relevant.

Once you have a stable product and you need a better database, PostgresSQL is a good move up.