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

41–50 of 246 posts

Re: Amazon RDS for PostgreSQL

#41

Post by natural219 »

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software.

Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle. I am totally fine using Postgres at a company or with another DB developer who knows how to set up databases properly, but if I am starting a new project, I am going to use MySQL, period.

Re: Amazon RDS for PostgreSQL

#43

Post by rachbelaid »

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/CHAP_P...

Re: Amazon RDS for PostgreSQL

#44

Post by eli »

adrianh wrote: post #23
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.

Postgres actually cares about your data. Perhaps you mistakenly insert "2013-10-32" into a date column. MySQL will silently convert this to "0000-00-00" (!!). Postgres will raise an error. Perhaps you make an error in a transaction. MySQL lets you keep doing subsequent things in the transaction. Postgres treats the transaction as invalid and forces you to start over. Perhaps you want to add a column to a table that h…

Hey at least it throws a warning on the bogus date conversion (MySQL warnings should almost always be treated as fatal errors).

The thing that kills me with MySQL (technically it's with InnoDB-based storage enginges in MySQL) are the subtle quirks. Like the thing where it insists on writing temporary tables to disk if you do a query that selects TEXT or BLOB fields. Even if they could have easily fit in memory, it's not smart enough to be able to determine that with variable length fields. A very non-obvious performance killer unless you're specifically looking for it.

Re: Amazon RDS for PostgreSQL

#45

Post by jhdavids8 »

natural219 wrote: post #41

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…

Have you tried Heroku's PostgresApp postgresapp.com?

Re: Amazon RDS for PostgreSQL

#46

Post by njharman »

natural219 wrote: post #41

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…

Um, point of this announcement is you no longer have to install PostgreSQL!!! You can let Amazon do it for you, and scale it, back it up, maintain it etc.

Re: Amazon RDS for PostgreSQL

#47

Post by Keyframe »

natural219 wrote: post #41

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…

Yeah, psql is really hard to install. For example on ubuntu: apt-get install postgresql postgresql-contrib

Who could install this nonsense??

Re: Amazon RDS for PostgreSQL

#49

Post by aschreyer »

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…

PL/Python is very unlikely to appear soon unfortunately because it is an untrusted language in PostgreSQL.

EDIT: you are right, PL/Python is supported as well. I only read the "Language Extensions :PL/Perl, PL/pgSQL, PL/Tcl" part at the top.

Re: Amazon RDS for PostgreSQL

#50

Post by mattmanser »

njharman wrote: post #46
natural219 wrote: post #41

I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…

Um, point of this announcement is you no longer have to install PostgreSQL!!! You can let Amazon do it for you, and scale it, back it up, maintain it etc.

I'm going to guess he's talking about a dev machine, which is where 90%+ of all DB installs take place.
Post reply on HN