I am working on a series of websites, all using the same drupal core files as a multi-site, and i would like the bible on all of the sites, but the one snag is that each site has a separate database, and it seems a bit wasteful to have the bible database tables replicated in each database - i exported just the bible tables, came to around 5MB - if i do this in a large number of sites, that 5MB each becomes quite huge.

Is there any way to have this module reference a single database, instead of the database being used by the rest of the drupal installation? i have *a little* experience with module writing, but if it is possible, can anyone point me in the right direction?

Comments

MikeLee_Birdy’s picture

MikeLee_Birdy commented

Dear Sir:
I've think about this feature, but I encounter some problems:
1. db permission. If I put all bible context in one mysql/postgresql db, how to write the module code to access the "common" db? Should this site manager assign some sql connection infomation or any other method?
2. Context selection. Not every site choose the same bible versions. This can be solved by allowing site administrator to choose which versions he/she wants.
3. Importing and bible administrating. This will become another site manager issue. Could be solved but need some extra work.
4. Or, change the verse reading by calling webservice method. But, this will cost more effort to work....
MikeLee

Kriss-dupe’s picture

Kriss-dupe commented
Status: Active » Postponed

Been here too long, changing status for efficiency.

onepartscissors’s picture

onepartscissors commented
Status: Postponed » Closed (won't fix)