PostgreSQL

• smknox

  Hall of Fame

  Points: 3275

  More actions

  April 19, 2008 at 11:26 am

  #184641

  Not sure where this question goes, but wondering how SQL server compares to PostgreSQL. Is there a good source for comparing features?

  Thanks,

  Sam

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  Follow

  April 19, 2008 at 5:23 pm

  #804674

  Not sure I've seen a good one. I know lots of Oracle like things are in PostgreSQL, so that may be a good start.

  are you looking for things in terms or programming, admin, ?

  Is this to decide which you want to use or perhaps to considering porting code?

• smknox

  Hall of Fame

  Points: 3275

  More actions

  April 20, 2008 at 6:19 am

  #804697

  I'm checking out some of the open source options in terms of perhaps porting over an application. I looked at MySQL and was stunned that they just now have stored procedure capabilites. That told me all I needed to know there. Plus no administrative capabilities.

  Postgres seems to be a different story, but it seems that everyone is strongly in one camp or the other. I grew up on SQL server, know little about Oracle, but exploring what's out there.

  Sam

• paulallen7

  SSC Enthusiast

  Points: 103

  More actions

  May 14, 2008 at 4:44 am

  #815031

  Don't suppose anyone out there has found good postgres vs sql server websites / docs etc... I've been asked to investigate sql server vs postgres but only have experience with sql server.

  Really looking for a list of features + pros & cons mainly focusing on:

  O/S compatibility

  Performance

  Limiting factors

  Support

  GUI

  Programming language

  etc...

  I've been having a look around and getting feel for the differences but haven't found any killer sites yet.

  Any help much appreciated.

  Thanks

  Paul