Personally speaking I must tell you that I like MySQL very much because of its compactness (in the 3.x-releases). But at some points you're right, it wasn't the best database-solution to choose because of it's features - but I was able to "emulate" a lot through php- scripts. The 4.x-branch changes this, as you already stated. But I wouldn't use 4.x in a "rough" production-environment at the moment. If you use it for your university that's okay I believe - but you can't use it in a REALLY critical environement yet.
PostgreSQL has a lot of the things MySQL-users always wanted. But MySQL is catching up. Therefor I would say: Choose whatever you like. As far as I know with both correctly configured and administrated (adding indexes etc.) you can use bpoth even for heavy-loaded sites. It's a question of peronal likes / dislikes Give MySQL 4.x a try - it's worth it. But PostgreSQL on the other hand already has all the features that are now arriving in the MySQL 4.x-releases. No easy questions ... make up your own mind about it. I don't want to influence you ... and be asured: Both solutions are quite good and fast! Greetingz Stefan On 26 Feb 2003 at 16:07, Juan Nin wrote: > Hi, > > I'm about to make a kind of yahoogroups in PHP. It's for a University, > so it will be used a lot. I'm considering using either MySQL or > PostgreSQL... > > Which one would you recommend for this project? > I've always heared that PostgreSQL is better for big databases with > lots of records, where data integrity, etc is critical, and that MySQL > is better for light web applications, and smaller databases where > quickness is needed... > > but I've heared that the new MySQL 4.x branch changes this a bit, and > that from MySQL 4.1 there are nested queries support, etc > > any recommendations? > > Thanks in advance, > > Juan > > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list