MySQL vs. PostgreSQL?

I know alot about MySQL (well at least I think I do!) I keep hearing about PostgreSQL, can someone explain the differences between the two (if any) and which one is better?

Thanks!

PostgreSQL offers procedural languages, views, and functions which are all features of general RDBMS systems. mySQL doesn't have these the last time I coded with it. PostgreSQL is more robust and enterprise class because of these added features although they also make it considerably slower than mySQL as a result.

The challenge that mySQL faces is how many more features can they add without it taking a toll on it's speed.

Roj

I prefer MySQL because of speed, and ease of use. I have no real need for the extra features that PostgreSQL offers

Typically, you wouldn't really need to use PostgreSQL unless you had a very large database. MySQL will usually suffice but if you have a very large database or one that might become very large in the future, then PostgreSQL is a good choice.
There's more to it that what I just said but this is just the skinny on it

ive looked at postgres before but never really switched. im building a HUGE application at the moment and its not to late to switch.

Originally Posted by Adam ive looked at postgres before but never really switched. im building a HUGE application at the moment and its not to late to switch.

How many records do you think your DB will have to hold?

Not sure why but people say postgres is more secure.

Originally Posted by Koobi How many records do you think your DB will have to hold?

well it depends on how many customers i get

but its going to hold a fair bit


database 1
sales tickets
+ original topics
+ replys

support information
+ original tickets
+ replys
+ attatchments

faq database
+ tutorial
+ images
+ comments

user information
+ usernames
+ passwords
+ addresses
+ phone numbers

security
+ logging information

database 1

website database
6 databased pages (plus more for in growth)
vbull forum

see my major concern is encryption and security, the support db (database 1) will run over https but its no good if my data is stored as plain text so i need a way to store the information safeley and securly.

MySQL is probably the one you want to go for, very easy to use and fast to boot.