Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Amazon RDS for PostgreSQL

aws.amazon.com

Post reply on HN
Print view View original

111–120 of 246 posts

Re: Amazon RDS for PostgreSQL

#111

Post by nphase »

jes5199 wrote: post #32
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.

Some engineers I worked with went and interviewed people at various San Francisco startups about their experiences with their databases. The MySQL startups tended to say "We love MySQL. We've gotten in the habit of taking an hour or two of downtime in the middle of the night every week to run all of our schema migrations, and we've had to build our process around that, but one we had it in place, everything's been fi…

Which tools enable real-time schema migrations in Pg?

Re: Amazon RDS for PostgreSQL

#112

Post by elchief »

rachbelaid wrote: post #43

Great news and for people who ask them-self the questions but the version is Pg 9.3.1. Not all Pl are available, and it misses the PL/V8 and PL/Python at least. And it seems that all fdw (Foreign Data Wrapper) extensions are missing. But it's a great start, I'm looking forward to try. If anybody know if we can still access the WAL log then it will be very useful http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/C…

Ack, half my stuff's in PLV8. Oh well.

Re: Amazon RDS for PostgreSQL

#113

Post by r888888888 »

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.

IMO it was when Oracle bought MySQL and effectively killed development. MySQL still lives on with MariaDB I suppose, but in the years since Postgres has leapfrogged it in terms of functionality.

Re: Amazon RDS for PostgreSQL

#114

Post by gtaylor »

the_mitsuhiko wrote: post #21
yumraj wrote: post #8

I've heard about PostgreSQL and know that HN community raves about it, but am currently using RDS with MySQL. Does it make sense to migrate to PostgreSQL, I don't have a lot of data as I'm in the early stage? What are the primary advantages that PostgreSQL provides over MySQL? Any advise/pointers is appreciated.

> Does it make sense to migrate to PostgreSQL, I don't have a lot of data as I'm in the early stage? What are the primary advantages that PostgreSQL provides over MySQL? Any advise/pointers is appreciated. If MySQL works for you, there is no reason to change. Some people have quite a dependency on Postgres (hstore, JSON, transactional DDL, pubsub, PLPGSQL etc.)

> Some people have quite a dependency on Postgres

Our dependency on Postgres is more to do with it being a lot safer with our data. It doesn't silently fail, the transactions have a better failure mode, and as previously pointed out it handles ALTER in production a LOT better than MySQL.

The combination of safety, speed/efficiency in schema/index alteration, and its increasingly good performance are why we depend on it. The rest is just gravy.

Re: Amazon RDS for PostgreSQL

#115

Post by gtaylor »

ceejayoz wrote: post #100
jes5199 wrote: post #32

Earlier quoted context omitted.

Some engineers I worked with went and interviewed people at various San Francisco startups about their experiences with their databases. The MySQL startups tended to say "We love MySQL. We've gotten in the habit of taking an hour or two of downtime in the middle of the night every week to run all of our schema migrations, and we've had to build our process around that, but one we had it in place, everything's been fi…

pt-online-schema-change from Percona addresses this particular point with MySQL nicely for us, incidentally. We use their Percona XtraDB Cluster fork and are quite happy.

But that's not included in mainline MySQL, correct?

Re: Amazon RDS for PostgreSQL

#116

Post by gtaylor »

ancarda wrote: post #62
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 still use MySQL because trying out PostgreSQL recently scared me away. Maybe I was trying the wrong thing but I couldn't get pgAdmin to display my tables. I think I sank most of my afternoon trying unsuccessfully to do something MySQL can do in 5 minutes. I recognize I'm used to MySQL but I was under the impression that because PostgreSQL has a similar syntax (SQL) it wouldn't take too long to pickup.

I deal with Postgres a good bit, but will be the first to tell you that pgAdmin has got some issues. It's a very clunky, buggy, moody piece of software.

I've had better luck learning how to use the psql command/shell than mess with pgAdmin, at least in certain cases. To take your example of displaying tables, psql in and type: \dt

The rest is just a search away.

Re: Amazon RDS for PostgreSQL

#117

Post by jeffdavis »

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.

Tactically, because PostgreSQL predictably releases robust software every year with major improvements and innovations.

Strategically, because PostgreSQL is not just trying to be a free database checking off features. It's trying to be something better -- lots of innovation that is having a bigger impact on what developers and DBAs can do.

Re: Amazon RDS for PostgreSQL

#118

Post by gingerlime »

wvanwazer wrote: post #72
nathanwdavis wrote: post #69

It doesn't mention which version of PostgreSql. I hope it is 9.3. It's got to be at least 9.2 since it supports the Json datatype.

It is 9.3.1.

But it's strange that the page says that PostgreSQL includes support for ‘JSON’ data type and two JSON functions

In PG 9.2 there were only two json functions[1], but 9.3 introduced more[2]

[1]http://www.postgresql.org/docs/9.2/static/functions-json.htm... [2]http://www.postgresql.org/docs/9.3/static/functions-json.htm...

Re: Amazon RDS for PostgreSQL

#120

Post by ceejayoz »

gtaylor wrote: post #115
ceejayoz wrote: post #100

Earlier quoted context omitted.

pt-online-schema-change from Percona addresses this particular point with MySQL nicely for us, incidentally. We use their Percona XtraDB Cluster fork and are quite happy.

But that's not included in mainline MySQL, correct?

The Percona Toolkit works with mainline MySQL and is trivial to install.
Post reply on HN