mySQL/postgreSQL?

[tecknophreak]

i'm going to start up a sql server on my linux box and i'm wondering which one would be better? thanx

[Bradmont5]

That really depends on what you're doing. For sheer speed, MySQL. For security, reliability, real backups, et cetera, Postgres.

[jemfinch]

For anything, PostgreSQL. There's little or no appreciable difference in speed these days, and starting with MySQL will limit you and your knowledge of SQL horribly.

Jeremy

[GuruWannabe]

There was a MASSIVE flame war about this a year ago. The issue was MySQL's lack of transaction support at the time. If you're interested I'll dig up the link.

I've tried both but haven't done anything substantial in either. From what I've seen, though, PostgreSQL has more of the things that a relational database is needed for: transaction support, stored procedures, etc.

[Whipping Boy]

One phrase: MySQL Max

[joelmon]

what are transactions?
And is mysql capable of handling 1,000 + queries per hour?

Just curious, I use mysql, have postgres, and am not sure specifically how stable and powerful mysql is and how many concurrent hits it can handle without falling apart

same with postgres
?

Thanks

[tecknophreak]

security is good. so i guess i'll go with the postgre. thanx. i'll prolly be back up with some sort of qs about it.

[EscapeCharacter]

id say postgres since its support more standard sql than mysql(except that part about dropping column, which is kind of annoying)

[jcrowe]

Set up both. Then make any code you write able to use both with a database layer.