Re: [Phpwiki-talk] Multiple instances - One DB

[Reini U. <ru...@x-...>]

Manuel VACELET schrieb:
> Reini Urban wrote:
>> Manuel VACELET schrieb:
>>> In order to be able to run multiple instances of PhpWiki based on the 
>>> same sources and the same DB, I want to modify WikiDB and 
>>> corresponding backends (at beginning PearDB) to add an unique id for 
>>> each PhpWiki instances.
>>
>> why? don't do that!
>> just define a different DATABASE_PREFIX for each wiki and generate the 
>> tables with these prefixes.
> 
> I want to offer phpwiki servicies to mutiple groups (I'm looking around 
> gforge wiki plugin). For security reason I have to separate content of 
> each instances of PhpWiki. I can have thousand instances of phpwiki so 
> it imply ten thousand mysql tables.
> 
> I already (successfully) tested database prefix but I think next phpwiki 
> updates (with db schema upgrades) will be a little bit complicated.

So please use different databases for this task. Just a different DSN.
You can do that automatically by creating the DSN automatically
e.g. by prefixing the database with the gforge project name. 
("myproject_phpwiki")
Or even use the gforge database "myproject" and just add some general 
"phpwiki_" prefix.

Either prefixes or databases.
I see no technical reason for a WikiDB db_id.

In gforge there's no need for a custom starter script for each project, 
you can do that automatically, by creating these wiki settings from your 
app. Just define the general settings in the central config/config.ini 
and define the custom overrides in the script behind the wiki link.

BTW: In CVS there's no nameclash with $Theme anymore, but 1.3.10 is not 
usable with gforge.

> But it's just "feeling" about possible issues, I don't really have 
> examples of "Why I think that it could be a problem?"
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/