|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/1/2006 6:04:22 AM
GenoPro Version: 2.b15h
Posts: 7,
Visits: 5
|
|
I saw on the GenoPro 2 feature list there was a possibility to use an SQL database to store genealogy information. I cannot find anything related to SQL in the user interface.
Is it possible to do that?
I saw the post about someone wanting to export in SQL for phpGedView, this is not exactly what I would like.
If genopro was able to store all its information in the database, and update it exactly as it does with its flat or xml file, it would be perfect (I don't mind the table schema, as long as it is there is a way to prefix the table name for example with say "gno_").
Does genopro does that? if it does i'd really like to try it in the few days left in my evaluation period :D
Thanks!!
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 7:57:39 AM
GenoPro Version: 2.0.1.6
Posts: 3,515,
Visits: 14,842
|
|
At the moment, we have no schedule to implement an SQL or ODBC interface to store genealogy data. Instead we plan to push the XML to work with databases. The problem with relational databases is the need an ID for every row so we can locate an object (individual, family, picture, etc). GenoPro has many objects without IDs, which is fine under XML but cannot be stored in a traditional database.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/1/2006 6:04:22 AM
GenoPro Version: 2.b15h
Posts: 7,
Visits: 5
|
|
I completely understand this point of view.
But then, what is the SQL feature of the beta2, it there a page detailing this feature and how to use it?
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 7:57:39 AM
GenoPro Version: 2.0.1.6
Posts: 3,515,
Visits: 14,842
|
|
olivier.jaquemet (6/11/2006)
But then, what is the SQL feature of the beta2, it there a page detailing this feature and how to use it?This page should be deleted. We are keeping it because sometimes an idea which appear "impossible" may become possible with time...
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/1/2006 6:04:22 AM
GenoPro Version: 2.b15h
Posts: 7,
Visits: 5
|
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 7:57:39 AM
GenoPro Version: 2.0.1.6
Posts: 3,515,
Visits: 14,842
|
|
olivier.jaquemet (6/11/2006)
Any possibility to try them?Nobody can try this SQL feature because it is not implemented.
|
|
|
|
|
Junior Member
Group: Customers
Last Login: 2/12/2008 3:14:16 AM
GenoPro Version: 2.0.1.3
Posts: 14,
Visits: 50
|
|
I don't know if anyone else might be interested, but I've decided to take on the challenge of at least creating a reasonably good Relational Database representation of the data from a GenoPro file.
First let me say that the report write is ONE HECK OF A NICE piece of work! Nice Job guys! It really gives you a lot of power and so far has made the process of trying to create SQL that could duplicate the current contents of a GenoPro file in a relational database much easier than I expected.
Now, I've put in maybe 16 or 24 hours on this project and so far I've got, Individuals, Families and unions pretty much done. I've also got the XRef (many-to-many) tables being populated that store the relationships between:
--Individuals and pictures
--Individuals and families (in different roles)
--Families and unions
--Individuals and citations
--families and citations
I'd consider my work so far to be alpha level in quality and there certainly a lot more I need to do. However, I was wondering if anyone else might be interested in helping with the project or maybe just do a little testing of what I've got so far and helping me find the problems that I'm sure are there.
I'll be making the project available for collaborative work via Subversion. If you are interested please let me know and I'll setup accounts for people to be able to access the "live" files.
I'm attaching a zipped version of the current state of the project here.
Thanks in advance for anyone who might be willing to help out.
Tom Malia
"a society that draws a broad line between it's military and it's intellectuals has it's wars fought by idiots and it's thinking done by cowards" (paraphrased from a source that I no longer remember)
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 7:57:39 AM
GenoPro Version: 2.0.1.6
Posts: 3,515,
Visits: 14,842
|
|
| Thank you Thomas for the report skin. I am wondering if an SQL database could be a viable lossless storage format for GenoPro files. At the moment GenoPro uses XML as its core file format and there are many features in XML that cannot be directly stored in an SQL database. GenoPro could offer more methods to enumerate tags and therefore automatically generating the SQL script for creating tables. When I was working on a database project in 1998, the application was dynamically generating the SQL scripts to create its tables in the SQL database. After all, GenoPro knows all its tags and can therefore generate the CREATE TABLE statement. For your SQL project, do you need all the data, or just a part of the data?
|
|
|
| | |