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

Heroku Postgres

postgres.heroku.com

Post reply on HN
Print view View original

11–20 of 78 posts

Re: Heroku Postgres

#11

Post by bad_user »

andypants wrote: post #10

This is really awesome, just a few downsides (for me): I don't use postgres - I hope heroku expands this kind of service to more databases (although I don't think it's likely in the near future). The smallest database is also pretty expensive. I wouldn't mind a cheaper plan for less resources. Only being able to create one database of each size is just weird, especially if forking or following. Can anybody confirm th…

In case you're using Mysql, give Postgres a try -- it's really awesome.

I do agree about them being expensive. Their services in general are too expensive for me -- personally I prefer to manage my own EC2 instances. But they do provide value worth paying for depending on your needs.

Re: Heroku Postgres

#12

Post by swilliams »

It would seem that their acquisition by SalesForce hasn't slowed them down at all, in fact I'd go as far to say that they've been even more productive since that happened. I'm curious about how that whole process has gone; has SalesForce provided more support/funding/resources? Or just removed distractions and allowed them to focus on their product?

Nice job Heroku.

Re: Heroku Postgres

#13

Post by wtn »

olefoo wrote: post #4

Just a little usability nit, is the pricing per month, per year, lifetime? It's not clear from the pricing page, and I'm assuming it's per month, in which case it's reasonable, especially given the value added services being offered, especially the ability to fork the database and the automated creation of read slaves. It looks like a solid offering. It's probably not right for companies that are subject to HIPAA or…

Basic plan is $200/month.

Re: Heroku Postgres

#14

Post by msmith »

olefoo wrote: post #4

Just a little usability nit, is the pricing per month, per year, lifetime? It's not clear from the pricing page, and I'm assuming it's per month, in which case it's reasonable, especially given the value added services being offered, especially the ability to fork the database and the automated creation of read slaves. It looks like a solid offering. It's probably not right for companies that are subject to HIPAA or…

I'm sure it's monthly. The price tiers are the same as the full Heroku platform (http://heroku.com/pricing), which is billed monthly.

Re: Heroku Postgres

#15

Post by drewcrawford »

This is ridiculous, but I would love a REST interface to a SQL server. I do a lot of AppEngine work and although I love the datastore and write super-optimal queries, I would really love the ability to pull a SQL datasource in every once in awhile.

Re: Heroku Postgres

#17

Post by jinushaun »

boundlessdreamz wrote: post #16

If there is anyone from heroku reading, please pay some money to http://www.sequelpro.com/ developers to develop postgresql compatibility. All GUIs available on OS X for postgres are horrible

I love using Sequel Pro for MySQL, but also wish it had support for SQLite and PostgreSQL. It's a great app and better than all the other OSX clients that I can find on the internet, including the non-free ones.

It's open source, so nothing's stopping anyone from adding support for other SQL servers.

Re: Heroku Postgres

#18

Post by firemanx »

Do they still limit the usage of user defined functions and contrib modules, or did that open up? I would love to use Heroku for some lightweight data warehousing that I've got going, but it's still pretty dependent on functions/sprocs for performance reasons.

I looked for any more documentation about that, but the only official word I have from them in the past is the support ticket I filed last year stating that they don't support "additions" like user defined functions or the various contrib modules.

Re: Heroku Postgres

#19

Post by khoffrath »

andypants wrote: post #10

This is really awesome, just a few downsides (for me): I don't use postgres - I hope heroku expands this kind of service to more databases (although I don't think it's likely in the near future). The smallest database is also pretty expensive. I wouldn't mind a cheaper plan for less resources. Only being able to create one database of each size is just weird, especially if forking or following. Can anybody confirm th…

For a similar service using MySQL you can try http://xeround.com/. (Disclaimer: I haven't tried it myself and have no association with them)

Re: Heroku Postgres

#20

Post by pvh »

firemanx wrote: post #18

Do they still limit the usage of user defined functions and contrib modules, or did that open up? I would love to use Heroku for some lightweight data warehousing that I've got going, but it's still pretty dependent on functions/sprocs for performance reasons. I looked for any more documentation about that, but the only official word I have from them in the past is the support ticket I filed last year stating that th…

Our production service has always supported UDFs, though the free sandbox service does not.

Unfortunately, Postgres makes it difficult to install extension modules without superuser. That said, we've wanted to support contrib modules for ages. Lately, encouraged by the work Dimitri Fontaine has been doing on extensions, we have a pilot project going which includes support for hstore, pgcrypto, pg_trgm, and of course, postgis. Feel free to contact me at pvh(at)heroku.com if you're interested in taking it for a spin.

Post reply on HN