From: | chris(at)future-i(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Geneology: GEDCOM and PostgreSQL |
Date: | 2001-04-15 17:10:10 |
Message-ID: | Pine.LNX.4.20L2.0104151659080.12472-100000@budvar.future-i.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am getting interested in creating a web application for collaberativly
compiling family trees. Of course this is not a new idea, but I can't find
much good open-source code about, and I don't trust any of the existing
services not to go bust.
My first task is to build a solid data model.
GEDCOM[1] is a data exchange format developed by the Mormons (who consider
genealogy to be a 'religious obligation'[2]). Together with it's XML
translation GedML[3], GEDCOM seems to summerise the standard data model
which is used by genealogists.
I have a few questions:
Has anyone produced an Postgres-style SQL translation of the GEDCOM
data model?
Are there any existing Postgres-based genealogical tools?
Is there anything I should know about Postgres's handling of the
inevitable tree traversal queries? (Is there anything like the Oracle
connect by syntax?)
[1] http://www.gendex.com/gedcom55/55gctoc.htm
[2] http://www.zdnet.com/devhead/stories/articles/0,4413,2264378,00.html
[3] http://users.iclway.co.uk/mhkay/gedml/index.html
--
Cheers
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-04-15 17:12:40 | Re: Changes in PostgreSQL 7.1 |
Previous Message | Yann Ramin | 2001-04-15 17:06:42 | Re: How to simulate MEMO data type?Thanks! |