MySQL vs PostgresSQL

[JCrou82]

i have knowledge of MySQL but have only done small applications using MySQL databases. For a dynamic, e-commerce website, should i go with mysql or postgres?

Generally what i am asking is:
what are the differences between postgres and mysql?
which is easier to work with, has support and is faster or more stable?
Basically the pros and cons and differences between MySQL and Postgres.

 

[Rick]

Hi JCrou82, I am but a mere computer science student but I have been researching the exact same question for a couple of days now and here is what I've come up with if it's any help:

MySQL is an easy to use DBMS but it seems a bit too simple for anything even slightly complex, ie it does not have any support for referential integrity, has no recursive join facility etc.

PostGreSQL on the other hand would seem to be a more suitable option if you want to do anything fancy like the above.

As I say I'm no guru on the subject but I try to offer what help I can, oh and one other thing is that MySQL is by far the most common used DBMS on the net. Regards Rick

 

[sleipnir214]

Check out this thread:

thread699-345432 ______________________________________________________________________
TANSTAAFL!

 

[JCrou82]

sleipnir214, I have placed both threads to get opinions from both ends of the spectrum. I want to make an unbiased decision so i put basically the same question in both forums to see what kind of output I would get from either. It seems that even in the MySQL forum, most ppl support/suggest that i use Postgres.....gives me something to think about.

quick question, does postgres have a "show tablename" syntax for me to see what tables or databases i have on the server?

 

[rycamor]

From inside the 'psql' command prompt, you would just enter '\dt' to display a list of tables. Enter '\?' to for the help output on other terminal commands.

PostgreSQL's command prompt works significantly different from the MySQL one, but you have at least as much flexibility, if not more, once you learn the commands. -------------------------------------------

Big Brother: "War is Peace" -- Big Business: "Trust is Suspicion"
(

http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html)