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

[Michael Feher]

While getting familiar with the source code I realized that the CR 
backend stores the data in a particular structure which I think is hard 
to access from other applications outside of FLOW3.

As FLOW3 claims to be a framework not only designed for TYPO3 I think it 
is necessary to be able to exchange data with other applications on a DB 
level. Therefore I think FLOW3 should also provide a way to access data 
stored in the database of a foreign application. (could be implemented 
as special backend)

The problem I see is that you probably want to mix the data storage 
backends. Such that you can store some of the objects in the FLOW3 
structure and fetch other objects from an external database. I would 
propose some kind of annotation mechanism where you specify on a class 
level which backend should be used and a DB connection string.

Another issue which should be taken into account when designing the CR 
is that in business applications certain security mechanisms are usually 
implemented in the DB by access rights to the tables. As you usually 
don't want to run your DB connection as root you need a way to have 
different database connections based on the current user.

Are there any plans to implement such features? If so I would be willing 
to help. Or is this out of the scope of FLOW3 and developers are 
required to implement such DB connections on their own.

Michael