1,583
edits
Changes
→GRAMPS SQL database Overview
= GRAMPS SQL database Overview =
== 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 =