On Friday 21 December 2001 05:43, you babbled something about: > Trond Eivind Glomsrød wrote: > >> Anyone have an opinion on using either PostgreSQL or MySQL on RH 7.1? I > >> am a newbie to both. Which should I use? > > > >PostgreSQL. You want subqueries, you want foreign keys, you want triggers. > > With all due respect, Trond, that's a little one-sided, considering > that you represent a company that markets a Postgres-based product. > =)
It's probably more a SQL programmer's bias. Many experienced people don't know how how others live without that stuff. (Like me ;) > A better answer would be (as usual), "It depends." I'll refrain from > a debate about the merits of each, but the advantages Postgres offers > are not always worth the added complexity. The right choice depends > on the application. I agree here completely. They are both excellent products aimed at different needs. > The OP won't go wrong with either one, but I suspect she'll find more > documentation for MySQL than for PostgreSQL, which might be a > significant consideration. I find this highly inaccurate. The reason being that I believe there is so much written to document MySQL is due to the fact that it is not a standards compliant SQL implementation and geared towards people looking for some RDBMS functionality without having to learn a lot of stuff. Hence the reason for some of the "crutches" that MySQL has (that are convenient) that are not in other RDBMS to eliviate the need for more advanced programming skills. So exclusive docs must be written. To learn PostgreSQL one need only use any book/document/etc. that uses SQL92 compatible syntax and then pick up the extras from the PostgreSQL docs. -- Brian Ashe CTO Dee-Web Software Services, LLC. [EMAIL PROTECTED] _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
