4,861
edits
Changes
m
Gramps
This page documents the format of a SQL database version of the GRAMPS Gramps BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]] for GRAMPSGramps, and for supplying data to other applications, such as a [[GEPS 013: Gramps Webapp]].
= GRAMPS Gramps SQL database Overview =
There are two versions of exporting a SQL database: an ExportDjango version and an ExportSql/ImportSql version. Currently, the ExportDjango is the latest SQL design. You can access the older functionality through the ''ExportSql'' and ''ImportSql'' programs of the [[Third-party Plugins]] and the newer ExportDjango in SVN in [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/ /trunk/gramps/webapp/], [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/templates/ src/data/templates/] and [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/javascript/ /src/data/javascript/].
</pre>
If you change the data, you can then read it back in and GRAMPS Gramps will reflect the changes.
NOTE: You should only attempt editing textual fields or fields for which you know the meaning. For example, in the above, do not change the handle fields, but you can change one's gender.
''This section describes the latest SQL schema in the SVN branch.''
The GRAMPS Gramps BSDDB data is broken up into the following tables. The structure and names of the tables and fields were designed to match the naming and operation of the GRAMPS Gramps source code. All of the tables have singular form names (e.g., 'person' rather than 'people').
The schema is created in the [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/grampsdb/models.py /trunk/gramps/webapp/grampsdb/models.py] file as Python code.
