From owner-freebsd-questions Wed May 29 13:22:31 2002 Delivered-To: freebsd-questions@freebsd.org Received: from moutng0.schlund.de (moutng0.kundenserver.de [212.227.126.170]) by hub.freebsd.org (Postfix) with ESMTP id 25ACB37B41D for ; Wed, 29 May 2002 13:22:19 -0700 (PDT) Received: from [212.227.126.160] (helo=mrelayng0.kundenserver.de) by moutng0.schlund.de with esmtp (Exim 3.22 #2) id 17D9xP-00045Y-00 for freebsd-questions@freebsd.org; Wed, 29 May 2002 22:22:07 +0200 Received: from p508e44e3.dip0.t-ipconnect.de ([80.142.68.227] helo=sschwarzer.net) by mrelayng0.kundenserver.de with asmtp (Exim 3.35 #1) id 17D9xP-000287-00; Wed, 29 May 2002 22:22:07 +0200 Message-ID: <3CF53837.943FEB0D@sschwarzer.net> Date: Wed, 29 May 2002 22:21:11 +0200 From: Stefan Schwarzer Organization: None X-Mailer: Mozilla 4.61 [en] (OS/2; U) X-Accept-Language: de-DE,en MIME-Version: 1.0 Cc: freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hello Lance "Lance M.Westerhoff" wrote: > > Have you considered PostgreSQL? It's another _extremely_ powerful > > open-source database. > > Agreed. A little more research may be in order here. Do you know if > either MySQL or PostgreSQL offer any Object Oriented or Object > Relational support (like Oracle)? Biological systems are inherently > object oriented and over the coming months I'll be exploring OO DBMS to > see what I can see. I have focused exclusively on RDBMS's such as MySQL > (the databases are currently fully implemented with MySQL), but OO seems > interesting (at least for certain types of applications). PostgreSQL provides some object relational features (see the docs on http://www.postgresql.org/) but is not really an object-oriented database. Neither is MySQL, Oracle or DB2 (AFAIK). If you want to choose from the more common database servers but also do object-oriented programming I recommend using an OO-ER wrapper framework for your programming language. In a project we use Python with PostgreSQL; there are several OO-ER mappers (though you probably will have more work with Python than with e. g. Java because of Python's dynamic "nature"). I would be interested to know what happens further. :-) Stefan To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message