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

131–140 of 246 posts

Re: Amazon RDS for PostgreSQL

#131

Post by avenger123 »

fat0wl wrote: post #129
fat0wl wrote: post #105

Earlier quoted context omitted.

Yea I was using MySQL on RDS just to escape the Heroku monolith. Funny that Heroku announced a new Postgres pricing model that is VERY expensive compared to old setup ( https://news.ycombinator.com/item?id=6712570 ) just in time to be wiped off the map by RDS.

hey who downvoted this without replying?! Last time I badmouthed Heroku on here I got a reply from one of their employees asking me to fill out support tickets for errors I was getting in their apps...... O_o they're watching.

No one's watching. Your initial comment just really didn't add any value. Calling Heroku monolith compared to Amazon is an understatement and I don't see Heroku being "wiped off the map" from this.

Re: Amazon RDS for PostgreSQL

#132

Post by Daishiman »

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…

Best open source geospatial? It handily beats Oracle and MSSQL!

Re: Amazon RDS for PostgreSQL

#133

Post by KingMob »

gtaylor wrote: post #116
ancarda wrote: post #62

Earlier quoted context omitted.

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.

I have idle daydreams where Sequel Pro is finally ported to Postgres. pgAdmin is horrendous.

Re: Amazon RDS for PostgreSQL

#134

Post by reinhardt »

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.

You must be joking right? Either that or spending too much time on HN. PostgreSQL has won in the same sense that Golang or Clojure have won: in frequency of frontpage HN articles.

Re: Amazon RDS for PostgreSQL

#135

Post by ceejayoz »

gtaylor wrote: post #126
ceejayoz wrote: post #120

Earlier quoted context omitted.

The Percona Toolkit works with mainline MySQL and is trivial to install.

I guess that means "No, it's an unofficial, third party toolkit".

So's jQuery, but that hardly stops me from using it. Unsure as to the point you're trying to make.

Re: Amazon RDS for PostgreSQL

#137

Post by aschreyer »

aschreyer wrote: post #49
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.

PL/Python is NOT supported: http://www.databasesoup.com/2013/11/first-look-at-postgresql...

Re: Amazon RDS for PostgreSQL

#138

Post by [deleted] »

eli wrote: post #44
adrianh wrote: post #23

Earlier quoted context omitted.

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…

[deleted]

Re: Amazon RDS for PostgreSQL

#140

Post by ceejayoz »

avenger123 wrote: post #131
fat0wl wrote: post #129

Earlier quoted context omitted.

hey who downvoted this without replying?! Last time I badmouthed Heroku on here I got a reply from one of their employees asking me to fill out support tickets for errors I was getting in their apps...... O_o they're watching.

No one's watching. Your initial comment just really didn't add any value. Calling Heroku monolith compared to Amazon is an understatement and I don't see Heroku being "wiped off the map" from this.

https://twitter.com/scottvdp/status/401111184092315648

> RDS 4XL vs Heroku Mecha: 40% cheaper on demand, 74% cheaper 1 year reserved, 82% cheaper 3 year reserved... with more features and capacity.

If that's true, Heroku's Postgres offering isn't going to do well. "Wiped off the map" may be an overstatement, but not by that much.

Post reply on HN