From owner-freebsd-hackers Thu May 20 11: 8:51 1999 Delivered-To: freebsd-hackers@freebsd.org Received: from picnic.mat.net (picnic.mat.net [206.246.122.133]) by hub.freebsd.org (Postfix) with ESMTP id 139BD15238 for ; Thu, 20 May 1999 11:08:44 -0700 (PDT) (envelope-from chuckr@picnic.mat.net) Received: from localhost (chuckr@localhost) by picnic.mat.net (8.9.3/8.8.5) with ESMTP id OAA75217; Thu, 20 May 1999 14:04:42 -0400 (EDT) Date: Thu, 20 May 1999 14:04:42 -0400 (EDT) From: Chuck Robey To: "Pedro J. Lobo" Cc: Dan Moschuk , hackers@FreeBSD.ORG Subject: Re: Database holywars? In-Reply-To: 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, Pedro J. Lobo wrote: > 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. And it has Java bindings (JDBC). I found Java makes *great* front ends. Postgresql + Java are a fine mixture. ----------------------------+----------------------------------------------- Chuck Robey | Interests include any kind of voice or data chuckr@picnic.mat.net | communications topic, C programming, and Unix. 213 Lakeside Drive Apt T-1 | Greenbelt, MD 20770 | I run picnic (FreeBSD-current) (301) 220-2114 | and jaunt (Solaris7). ----------------------------+----------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message