I’m currently using MySQL almost exclusively for my Rails projects, but keeping reading about PostgreSQL and its more powerful feature set.
However, both myself and my colleagues have always been put off by how awkward PostgreSQL is to set up and use, plus the lack of nice OSX GUI tools puts us off.
Can anyone recommend good articles or OSX tools to get me started?
By now, it’s somewhat dated, but the O’Reilly book “Enterprise Rails” had a good discussion of PostgreSQL which you might find useful. You should be able to get a used copy for very little.
Many thanks for your replies! I think I’m going to get a book and make the effort to learn it.
It’s a pity that there isn’t a tool as friendly as Sequel Pro for PostgreSQL, although it appears that PG Commander has progressed a lot since I last looked at it.
However when you’e connected to a server through ssh, you’ll have to use the psql commandline utility. Although I’m certainly not proficient in using Postgres from the command line, I found out it’s not really that hard, and knowing some commands for creating roles and permissions enable one to configure a PostreSQL database in no time.
I’ll have to have another play with pgAdmin3, thanks. By the way, it does look like there’s a SSH tunnelling option in the connection settings. I haven’t tried it out yet, it but does seem to let you connect over SSH: