Underrated Features of PostgreSQL

Ryan Smith has wrapped the use of LISTEN/NOTIFY into a really handy queuing library called queue_classic that we've been using internally at Heroku. He does a good write up of it over on his blog: http://ryandotsmith.heroku.com/2011/09/queue_classic.html

Re: Underrated Features of PostgreSQL

#5

Post by treenyc » Wed, Nov 02, 2011, 3:12 PM UTC

davidw wrote: post #3

pielud wrote: post #2

Where is transactional DDL on this list?

I think that's the sort of thing most people take for granted. It really shocked me to see that Mysql didn't have that.

Web development is like a fashion industry. Just because it is popular it doesn't mean it has the functionalities.

Re: Underrated Features of PostgreSQL

#6

Post by samuel » Wed, Nov 02, 2011, 3:15 PM UTC

davidw wrote: post #3

pielud wrote: post #2

Where is transactional DDL on this list?

I think that's the sort of thing most people take for granted. It really shocked me to see that Mysql didn't have that.

transactional DDL for granted? Not at all! Oracle doesn't support that AFAIK. May be you were thinking about transactional DML?

Re: Underrated Features of PostgreSQL

#7

Post by saturn » Wed, Nov 02, 2011, 3:26 PM UTC

The one thing I miss after switching to PostgreSQL from MySQL is Sequel Pro. pgAdmin 3, sorry to say, sucks, and I grow tired of rails dbconsole - but that's my only option, really.

Please, someone, make a good osx pg client. Just copy Sequel Pro if you don't know what I mean by that. I would pay a lot of money for a good osx client, I am not kidding, I have to deal with this every day. I cannot be the only one..

Re: Underrated Features of PostgreSQL

#8

Post by Pewpewarrows » Wed, Nov 02, 2011, 3:30 PM UTC

saturn wrote: post #7

The one thing I miss after switching to PostgreSQL from MySQL is Sequel Pro. pgAdmin 3, sorry to say, sucks, and I grow tired of rails dbconsole - but that's my only option, really. Please, someone, make a good osx pg client. Just copy Sequel Pro if you don't know what I mean by that. I would pay a lot of money for a good osx client, I am not kidding, I have to deal with this every day. I cannot be the only one..

Is Navicat not a good option?

Re: Underrated Features of PostgreSQL

#9

Post by reuven » Wed, Nov 02, 2011, 3:36 PM UTC

I've been using PostgreSQL for about 15 years, and it's a rare week when I don't discover a feature that makes my life (and that of my clients) easier and better in some way. The software is rock solid, the feature set both broad and deep, and the community is generous in many different ways. It's really a pleasure to use this database, and to see that a growing number of people are starting to use it.

Re: Underrated Features of PostgreSQL

#10

Post by famousactress » Wed, Nov 02, 2011, 3:41 PM UTC

I used Postgres in a former life.. really liked it, but switched to MySQL because at the time pg didn't have a very palatable solution for running a read-slave. Boy have I been interested in jumping back since v8&9! A question about partial indexes... Can this be used to solve the problem of multi-column unique constraints with null values? That is.. Say I've got columns a, b, and deleted_time. If a null deleted_time means the item hasn't been deleted.. traditionally I can't create a useful unique constraint across them (because NULL != NULL). Does this postgres feature allow me to create a unique constraint on (A,B) where deleted_time is null ?