Changes

Jump to: navigation, search

Gramps SQL Database

571 bytes added, 15:43, 16 August 2009
GRAMPS SQL database Overview
= GRAMPS SQL database Overview =
The current version There are two versions of this project outputs the GRAMPS BSDDB data into exporting a relational SQLite SQL database: an ExportDjango version and an ExportSql/ImportSql version. Currently, the ExportDjango is the latest SQL design. You can access this the older functionality through the ''ExportSql'' and ''ImportSql'' programs of the [[Third-party Plugins]] and the newer ExportDjango in SVN in [http://gramps.svn.sourceforge.net/viewvc/gramps/branches/geps/gep-013-server/ branches/geps/gep-013-server/].
== Sample Older version sample usage ==
After dropping the above plugins into your .gramps/plugins subdirectory, you can:
Exporting a SQL database can take up to 2 seconds per record to output. Prior to adding indexes and primary keys, importing a SQL database can take up to 1 second a record to read in. However, with the keys and indexes enable, it only takes about 0.01 seconds per record.
 
== Newer Version ==
 
Please see the README file in the [http://gramps.svn.sourceforge.net/viewvc/gramps/branches/geps/gep-013-server/webapp/grampsweb/README?view=markup branches/geps/gep-013-server/webapp/grampsweb/README]. You can run the ExportDjango plugin in this branch once you have the setup finished.
== External Access ==
After exporting, you can then access your data using any program that can read access your database (postgresql, sqlite files, etc). For example, on Linuxwith sqlite:
<pre>
If you change the data, you can then read it back in and 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 for 0 to 1.
= Database Structure =

Navigation menu