Changes

Jump to: navigation, search

GEPS 010: Relational Backend

402 bytes added, 05:32, 1 December 2008
SQL Backend
# An SQLite version of a GRAMPS BSDDB should be much faster
# An SQLite version of GRAMPS would allow people to create much bigger trees
# SQLite code is much simpler than the equivalent BSDDB code, because SQL is declarative and abstract and BSDDB is an API
Further implications:
# A fullscale MySQL backend would be a trivial step from SQLite
# Easy to allow multiple users in a SQLite database (uses file-locking)
 
Some downsides to the switch:
 
# There is a lot of code that we have written dealing with BSDDB. It would have to all be rewritten in SQL (on the other hand, a lot of code can be deleted, which will make GRAMPS easier to maintain and adapt)
# We will have to develop SQL experts
== Discussions of BSDDB in Python ==

Navigation menu