PostgreSQL

twinkle · Joined: 31 Jan 2006 Posts: 79

Anyone familar with PostgreSQL? My web host offers it besides MySQL. I do not know much about it and am curious if there would be any reason to use it as opposed to MYSql.

Much appreciated.
_________________
I shine

rose · Joined: 21 Feb 2006 Posts: 29

I believe it can handle larger databases more gracefully than mysql.

However, either way if you are programming in .Net it is more natural to stick with MS SQL.

I dont like any of the free databases myself.

twinkle · Joined: 31 Jan 2006 Posts: 79

So you don't like mysql either?

Out of curiosity, what is considered a big database where the benefits of PostgreSQL come into play?
_________________
I shine

rose · Joined: 21 Feb 2006 Posts: 29

Probably 100mb+ and with complicated, constant queries running in and out of it.

It also depends on how many concurrent users are going to be connected at one time, not all databases can handle large amounts of users gracefully.

administrator · Site Admin Joined: 01 Oct 2004 Posts: 183

I think that the recently released version 5 of MySQL is very well comparable to PostgreSQL as performance and functionallity. Check the 2 articles below for PostgreSQL and MySQL details:

http://www.databasedir.com/mysql/

http://www.databasedir.com/postgresql/
_________________
Peter
ASP & ASP.NET Articles and Tutorials

marbles · Joined: 01 Mar 2006 Posts: 16

But mySQL still remains the most popular database of choice for most developers running basic websites.
I think this is due to its bundling with Cpanel, which is the most popular linux hosting control panel.

paul · Joined: 11 Oct 2004 Posts: 128