Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!solace!nntp.uio.no!news-feed.inet.tele.dk!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!feed1.news.erols.com!news.enteract.com!newsfeed.enteract.com!news From: Craig Brozefsky <craig@onshore.com> Newsgroups: comp.infosystems.www.misc,comp.infosystems.www.servers.unix,comp.lang.c,comp.unix.bsd.freebsd.misc,comp.unix.programmer,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.server,comp.databases.oracle.misc Subject: Re: mysql Compare with postgres? (Re: Advice needed on large database project) Date: 01 May 1997 11:01:46 -0500 Organization: onShore Development Team Lines: 30 Message-ID: <m2207r89lg.fsf@subject.cynico.com> References: <5jo09j$20o$1@news.enterprise.net> <33606e0c.3792623@news.sc.edu> <3360C0C4.31A9264B@id.dk> <5k27n4$3s4$1@gaia.ns.utk.edu> <336663C4.4B41@ix.netcom.com> <33676770.69ADFAF4@explore.net> <336773C1.167E@c-lab.de> <p5iv1443m9.fsf@baynetworks.com> NNTP-Posting-Host: subject.onshore.com X-Newsreader: Gnus v5.4.42/XEmacs 19.15 Xref: euryale.cc.adfa.oz.au comp.infosystems.www.misc:49533 comp.infosystems.www.servers.unix:29457 comp.lang.c:208097 comp.unix.bsd.freebsd.misc:40110 comp.unix.programmer:53816 comp.databases:60606 comp.databases.ms-sqlserver:17881 comp.databases.oracle.server:7762 comp.databases.oracle.misc:6250 psmith@baynetworks.com (Paul D. Smith) writes: > MySQL also uses threads, while Postgres uses a new process for each > client access (last time I looked). Which one is better is somewhat a > religious issue, but I prefer threads myself. > > But you're right, Postgres has the most featurful SQL support. If you > really need full-fledged SQL you should start there. Hmm, no primary keys? No multi-table indexes(indexing two or more fields across table,s or indexing two or more fields alone) without having to write a bunch of SQL and make surrogate types. I have yet to see anything about outer joins(are they there at all?), no triggers(well you can rewrite functions). On the other hand it's free. I would stay away from msql, last time i looked it has osme major security problems(buffer overflows). Maybe they have been fixed by now. I have used PostgreSQL to write a rather large web based application, and I'm dissapointed by it's lack of support for some of these features, and it's performance(subjective analysis only YMMV). I'm looking at giving MySQL a shot soon. -- Craig Brozefsky craig@onshore.com onShore Inc. http://www.onshore.com/~craig Development Team p_priority=PFUN+(p_work/4)+(2*p_cash)