[TYPO3-mvc] Oracle DB Backend

[Zachary Davis]

Xavier,

I spent most of the day working on this today. So far, it's going well. 
I've implemented a class called OracleDbBackend that uses Typo3DbBackend 
as a starting point. We have a simple extension that lists "resource" 
models. Lists are generated based on resource type and category, both of 
which are m2m relationships. By making a handful of small changes to the 
DB Backend in extbase to make extBase respect the DBAL mapping that's 
stored in TYPO3's DB object, the list view works fine, as does filtering 
on those many-to-many relations. The query constraints that we've looked 
at so far seem to just work. I'm going to dig deeper tomorrow and try to 
get more complicated queries to work and see if I can find a solution 
for the sub-selects. So far, my sense is  getting quick Oracle support 
into ExtBase isn't going to be all that difficult.

Zach




Xavier Perseguers wrote:
> Zach,
>
>> Or, alternately, I suppose that until there's a full query builder
>> object in TYPO3 that lives outside of ExtBase, it might make sense to
>> just write an extBase DB backend that interacts with Oracle directly,
>> thereby avoiding DBAL altogether.
>
> I guess this is the best option and as a first solution, file(s) could
> be integrated into DBAL too as this would then ease the refactoring to
> make it better tight with DBAL afterwards.
>
> Xavier