[Gramps-devel] More on databases...

[Don A. <don...@co...>]

I think we are coming to a consensus on the database issues. I've had a
few additional thoughts.

I think what we have agreed on is:

  1) The database must be easy to install, preferably requiring no 
     additional installation, or easily installable via a package
     manager (such as apt or yum).

  2) The database should be easy to setup.

  3) Full SQL features are not necessary, however a few people might
     find this useful.

Fortunately, due to the object oriented nature of Python, I think we
could probably allow for multiple backends. The default will be a high
performance, simple embedded database, such as the Berkeley DB. Other
backends could be added to allow more advanced functions.

                              GrampsDB
                                  |
                  +---------------+---------------+
                  |               |               |
            GrampsSQLite     GrampsBSDDB     GrampsMySQL

The major difference between the database interfaces would be the
serialization of the objects in and out of the database.

At this point, I'm leaning in favor of GRAMPS providing a Berkeley DB
backend (BSDDB) as the default. Once this is established, we can look at
provding other backends.

Comments?

Don