ASP Hosting sale!
Double disk space and transfer for FREE!
Limited time offer! Act Now!

aspdev | articles | tutorials | forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

PostgreSQL

 
Post new topic   Reply to topic    ASPdev.org Forum Index -> SQL Programming (MS SQL Server, MS Access, MySQL)
View previous topic :: View next topic  
Author Message
twinkle



Joined: 31 Jan 2006
Posts: 79

PostPosted: Wed Feb 22, 2006 7:05 pm    Post subject: PostgreSQL Reply with quote

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
Back to top
View user's profile Send private message
rose



Joined: 21 Feb 2006
Posts: 29

PostPosted: Wed Feb 22, 2006 8:47 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
twinkle



Joined: 31 Jan 2006
Posts: 79

PostPosted: Thu Feb 23, 2006 11:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
rose



Joined: 21 Feb 2006
Posts: 29

PostPosted: Sun Feb 26, 2006 5:00 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
administrator
Site Admin


Joined: 01 Oct 2004
Posts: 183

PostPosted: Mon Feb 27, 2006 9:40 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
marbles



Joined: 01 Mar 2006
Posts: 16

PostPosted: Mon Mar 13, 2006 12:13 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
paul



Joined: 11 Oct 2004
Posts: 128

PostPosted: Mon Mar 13, 2006 11:45 am    Post subject: Reply with quote

marbles wrote:
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.


Most web hosting control panels (for both Windows and Linux) have built-in interface for interacting with MySQL database server. I believe that 99% of all web hosts install MySQL on their servers too. MySQL is much better option than MS Access for example. MS Access is not a good choice for a website backend, while MySQL does this job just fine.



Paul
_________________
World Countries | Survival Skills
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    ASPdev.org Forum Index -> SQL Programming (MS SQL Server, MS Access, MySQL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group

SQL Tutorial