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

61–70 of 78 posts

Re: Heroku Postgres

#61

Post by dewiz »

jinushaun wrote: post #17
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.

have you considered Navicat ? there is also a free version and it runs on windows, osx, linux

Re: Heroku Postgres

#62

Post by DavidChouinard »

pvh wrote: post #55
sgrove wrote: post #38

Earlier quoted context omitted.

I'd be curious to hear the alternatives, and the overall process used to arrive at the current language.

Hmm, this would make a good blog post. I'll draft something up.

Please do. There seems to be valuable lessons learnt there.

Re: Heroku Postgres

#64

Post by volkadav »

drewcrawford wrote: post #15

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.

Not exactly RESTful but you might find some utility in this, developed at and open-sourced by the NYT: http://code.nytimes.com/projects/dbslayer

(edit to add: this is mysql-only, unfortunately :) I forgot about that part when I remembered it off-hand.)

Re: Heroku Postgres

#67

Post by tednaleid »

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'm a big fan of DBVisualizer (http://www.dbvis.com/), and have used it almost daily for ~6 years now on OSX. It's not a perfect OSX app (it's cross platform Java, but quite good looking for what that normally implies). Lots of power, doesn't crash, decent looking, and it works for pretty much every relational database out there (including MySQL, PostgreSQL, and Oracle).

I own a SequelPro license (as well as licenses for a couple of other non-free tools, RazorSQL and Querious) and I always come back to DBVisualizer.

Re: Heroku Postgres

#68

Post by jackowayed »

pbreit wrote: post #63
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

How about a http://kickstarter.com project?

But it's kinda kickstarter in reverse since you have people wanting to give money but no one picked to do the work. It's a bounty.

I worked on and almost launched an open source bounty site a couple years ago. But the closer I got to launch the more I realized that I hadn't adequately solved all of the hard UX problems (mostly around a: picking who's going to work on it, trying to avoid both having two people separately do it due to know central coordination and having one person say "yeah, I'm going to do this!" and then not get around to it and hold the project back, and b: how to handle it when someone does technically address the bounty, but in a way that is unsatisfactory either because bounty-placers did not perfectly state their needs or because of poor quality.

Re: Heroku Postgres

#69

Post by olefoo »

pvh wrote: post #27
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 would say that at this point you're right, we're probably not right yet for companies subject to HIPAA or PCI regulation. The advanced Postgres datatypes are pretty much my favorite thing in the world. We use HStore internally all over the place, as well as some more exciting projects that we haven't said too much about yet. As I mentioned elsewhere in the thread, if you're interested in trying out some of those ex…

I'm a real fan of PostGIS and like ltree and hstore a lot. Heroku isn't quite right for my needs at this time, but I would definitely consider it if I had a use case that needed an extremely fast public facing postgres installation.

I am curious as to whether you do pro-rated pricing?

Re: Heroku Postgres

#70

Post by pvh »

olefoo wrote: post #69
pvh wrote: post #27

Earlier quoted context omitted.

I would say that at this point you're right, we're probably not right yet for companies subject to HIPAA or PCI regulation. The advanced Postgres datatypes are pretty much my favorite thing in the world. We use HStore internally all over the place, as well as some more exciting projects that we haven't said too much about yet. As I mentioned elsewhere in the thread, if you're interested in trying out some of those ex…

I'm a real fan of PostGIS and like ltree and hstore a lot. Heroku isn't quite right for my needs at this time, but I would definitely consider it if I had a use case that needed an extremely fast public facing postgres installation. I am curious as to whether you do pro-rated pricing?

As of today, we only charge for the time you use. I don't imagine we'd ever need to change that, but never is a long time.
Post reply on HN