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

Underrated Features of PostgreSQL

ledgersmbdev.blogspot.com

Post reply on HN
Print view View original

11–20 of 51 posts

Re: Underrated Features of PostgreSQL

#11

Post by kijin »

famousactress wrote: post #10

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…

According to the manual [1], this is one of the standard use cases for partial indexes. See the last section.

CREATE UNIQUE INDEX index_name ON table_name (a, b) WHERE deleted_time IS NULL;

[1] http://www.postgresql.org/docs/9.1/static/indexes-partial.ht...

Re: Underrated Features of PostgreSQL

#12

Post by jpeterson »

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

    #> psql mydb

Re: Underrated Features of PostgreSQL

#14

Post by megaman821 »

Pewpewarrows wrote: post #8
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?

It is not free, but neither is my time. I find that Navicat is awesome.

Re: Underrated Features of PostgreSQL

#15

Post by izak30 »

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

You could do alright (and very customizable) with the django admin and introspection. "Somebody" should probably write up a guide on doing that.

Re: Underrated Features of PostgreSQL

#16

Post by re_todd »

reuven wrote: post #9

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.

I used it about 2 years before realizing it had regular expressions, which have made some of my queries so much easier. http://www.postgresql.org/docs/9.0/static/functions-matching...

Re: Underrated Features of PostgreSQL

#17

Post by bockris »

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

Just curious, is it a pgadmin3 on OSX that is the problem for you or pgadmin3 in general?

On Windows, I find that I quite like pgadmin3 as compared to MySQL workbench but it's likely just a matter of taste.

Re: Underrated Features of PostgreSQL

#18

Post by willcodeforfoo »

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

Sequel Pro is awesome... I think they are working toward offering Postgres support: http://code.google.com/p/sequel-pro/issues/detail?id=362 but haven't seen anything concrete yet.

I just learned SP has bundles, like TextMate. Nifty.

Re: Underrated Features of PostgreSQL

#19

Post by dramaticus3 »

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

What's wrong with the console ?

Re: Underrated Features of PostgreSQL

#20

Post by rdunklau »

On the top of my head, another list of features worth looking at: - ARRAY support: makes your life easier, especially the array_agg aggregation function - HSTORE extension: use postgresql like a key/value store - SQL/MED implementation, foreign data wrappers: allows you to define external data sources as an extension.

Things that I miss in postgresql: - materialized views !! - a better graphical management tool.

Post reply on HN