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

31–40 of 51 posts

Re: Underrated Features of PostgreSQL

#31

Post by reuven »

dramaticus3 wrote: post #19
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 ?

Good question; I'm not sure. That said, none (literally none) of my PostgreSQL-using clients use psql, and they're somewhere between amazed and horrified that I prefer it for working with the database.

I'm not against GUIs, but it seems to me that psql has all of the advantages of the GUI administration tools, and then some.

Re: Underrated Features of PostgreSQL

#32

Post by ryanbraganza »

jpeterson wrote: post #12
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

rails dbconsole is the same thing. (it runs psql for you with args as specified in your database config)

Re: Underrated Features of PostgreSQL

#33

Post by rbranson »

mapgrep wrote: post #21

Using PostgreSQL for full text search is a bad idea. There is no native support for exact phrase searching "like this;" there are some hacky workarounds but you lose stemming and have to do a scan ( http://stackoverflow.com/questions/1489617/how-do-you-do-phr... ). High quality, world class text search is a basic prerequisite for a production web app these days (if your app needs search at all). The idea of keeping y…

Eh, it's good for basic stuff and getting to MVP, but I tend to agree that if search is a core feature, ElasticSearch or Solr are the way to go.

Re: Underrated Features of PostgreSQL

#34

Post by davidw »

samuel wrote: post #6
davidw wrote: post #3

Earlier quoted context omitted.

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?

Huh, weird. I don't know Oracle much at all... it seems that it does some things amazingly well, and others abominably. Strange beast.

Re: Underrated Features of PostgreSQL

#35

Post by jpitz »

jpeterson wrote: post #12
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

Seriously. The command line console for postgres really is that good. I'd rather spend a day in it than any vendor-provided or third party GUI for any database I have ever touched. This includes things like dbVisualizer, SquirrelSQL, pgAdmin3, SQL Server Management Studio, and the various flavors of Toad. A screen session with psql in one display and emacs in the other is heaven.

Re: Underrated Features of PostgreSQL

#36

Post by jpitz »

samuel wrote: post #6
davidw wrote: post #3

Earlier quoted context omitted.

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?

Oracle silently issues an implicit commit after each DDL statement. I think it kills a kitten each time.

Re: Underrated Features of PostgreSQL

#37

Post by a2tech »

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

DbVis is GREAT and multi-db management tool http://www.dbvis.com/

Re: Underrated Features of PostgreSQL

#38

Post by techscruggs »

reuven wrote: post #30
techscruggs wrote: post #28

Earlier quoted context omitted.

Wow, I have to ask, what do you think are some of the best resources to pull on for postgres knowledge are? and do you blog/tweet about your postgres work? if so, where?

Do I blog or tweet about it? Oh, I really, really should. (And I enjoy doing so when I do.) I used to blog a bit, but consulting + family + my (oh-so-dragged-out) PhD work tend to eat into my time. But yeah, I really should. Maybe your comment will push me back into occasional blogging on technical subjects. Fortunately, there are some amazing resources out there. The pgsql-general e-mail list has oodles of helpful p…

Thanks! I have and love the two Packt books. I'll check out the rest. If end up blogging, let me know. I'm @techscruggs

Re: Underrated Features of PostgreSQL

#39

Post by caf »

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

Have you tried Aqua Data Studio?

Re: Underrated Features of PostgreSQL

#40

Post by jeltz »

reuven wrote: post #30
techscruggs wrote: post #28

Earlier quoted context omitted.

Wow, I have to ask, what do you think are some of the best resources to pull on for postgres knowledge are? and do you blog/tweet about your postgres work? if so, where?

Do I blog or tweet about it? Oh, I really, really should. (And I enjoy doing so when I do.) I used to blog a bit, but consulting + family + my (oh-so-dragged-out) PhD work tend to eat into my time. But yeah, I really should. Maybe your comment will push me back into occasional blogging on technical subjects. Fortunately, there are some amazing resources out there. The pgsql-general e-mail list has oodles of helpful p…

Also I can highly recommend the #postgresql IRC channel at freenode. The people there are helpful and polite.
Post reply on HN