From owner-freebsd-hackers Thu May 20 10:48:39 1999 Delivered-To: freebsd-hackers@freebsd.org Received: from haddock.euitt.upm.es (haddock.euitt.upm.es [138.100.52.102]) by hub.freebsd.org (Postfix) with ESMTP id D9F8114C15 for ; Thu, 20 May 1999 10:44:46 -0700 (PDT) (envelope-from pjlobo@euitt.upm.es) Received: from localhost (pjlobo@localhost) by haddock.euitt.upm.es (8.8.8/8.8.5) with ESMTP id TAA04828; Thu, 20 May 1999 19:39:02 +0200 (MET DST) Date: Thu, 20 May 1999 19:39:02 +0200 (MET DST) From: "Pedro J. Lobo" To: Dan Moschuk Cc: hackers@FreeBSD.ORG Subject: Re: Database holywars? In-Reply-To: <19990520125421.A94348@trinsec.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 20 May 1999, Dan Moschuk wrote: > >Greetings, > >I've taken up a project that will rely very heavily on remote database >access. Naturally, the choice as to which database engine to use is a >crucial one. > >I'd like to stay away from the commercial database suites (i.e. Oracle) for >the time being, however I will eventually move to it once the database grows >to over 100M records. In the meantime however, I'm debating heavily between >MySQL and Berkeley DB with a multi-threaded socket frontend. > >Suggestions and comments? ¿Have you considered PostgreSQL? It is on the ports collection, and is a heavy duty database engine, with transactions, subqueries (only partial support), etc. Version 6.5 will be released in about two weeks, and it adds MVCC (multi-version concurrency control), which will improve a lot its multi-user capabilities. And, I know of some projects that are using it for multi-GB databases. I've been using it for or student database for more than two years (since version 6.0), and am quite happy with it. See www.postgresql.org for more information. -- ------------------------------------------------------------------- Pedro José Lobo Perea Tel: +34 91 336 78 19 Centro de Cálculo Fax: +34 91 331 92 29 E.U.I.T. Telecomunicación e-mail: pjlobo@euitt.upm.es Universidad Politécnica de Madrid Ctra. de Valencia, Km. 7 E-28031 Madrid - España / Spain To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message