On Thu, Jun 4, 2009 at 7:31 AM, Fred Williams <f.willi...@verizon.net> wrote: > > Nothing to do with relational databases, but if you are developing for a > future animal husbandry environment I would plan on supporting clones. Like > it philosophically or not.
sadly, SQLite doesn't have built-in capabilities for replication, though one could custom code it, no? ;-) > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Ibrahim A > Sent: Thursday, June 04, 2009 5:59 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Db design question (so. like a tree) > > > Jan schrieb: >> Hi, >> >> I am planning a database for animal breeding. I need to store the >> relations between individuals and therefore I have to build something >> like a tree structure. But of course with two parents (There wont be >> cloned animals in the database .-) afaik) >> >> I read a little bit about >> >> - adjacency list (not very difficult to understand) >> - nested sets (hm, more difficult) >> - b tree (to difficult) >> - ? (something I missed?) >> >> Could anyone give me an advice what to use or what else to read? Maybe >> someone has already done something similar e.g. genealogy. >> >> Bye >> Jan >> > ... > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, Geospatial Data http://sciencecommons.org Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users