[FLOW3-general] CR support for simultaneous access to multiple databases

[Michael Feher]

Am 10.10.2010 11:05, schrieb Jigal van Hemert:
>
> If both databases are MySQL you can set up a table with the FEDERATED
> table engine to access the other database (more or less a workaround).

I strongly doubt that this would work. The current implementation of the 
backend stores all objects in 4 distinct tables (entities, valueobjects, 
properties and properties_data) common for all Applications. I am not 
sure if you can configure the DB on a Application level but I have not 
seen any hint for this until now.

The objects are basically exploded into different properties and each 
property is stored as a unique entry in the properties_data table. The 
other tables basically constitute a tree structure where you have a root 
object and from this root object you can reach the other objects and 
their properties.

If you want FLOW3 now to see foreign objects you would have to fiddle 
with these tables and add your objects to the tree structure. Taking 
care of all the unique identifiers and links between the objects. So I 
don't think that this is a way you would like to go.

Michael