[TYPO3-mvc] Oracle DB Backend

[Zachary Davis]

Dennis,

Sorry not to get back to you sooner, I missed this message somehow. We 
haven't published the code, nor do we plan to until we can really flesh 
out the insert/update side of it. However, if you're mainly reading from 
an Oracle DB, then this should definitely be usable. It does assume, 
however, that you're using DBAL, as queries is passed through the TYPO3 
DB abstraction layer. That said, if you only wanted to pull data from 
Oracle for extBase, it wouldn't be hard to modify our code to talk to 
the Oracle DB directly.

Email me off list and I'd be happy to send you the Oracle DB Backend 
class and some basic instructions on how to use it. You'll need the 
version of ExtBase that came with TYPO3 4.5.2, as it relies on a 
Typoscript setting or two in that version.

best,
Zach


Dennis Ahrens wrote:
> Hi Zachary,
>
> On 25.02.2011 00:59, Zachary Davis wrote:
>> Just wanted to update this thread... We've made nice progress on the
>> ExtBase Oracle DB backend, and we now have a fully functional extension
>> with a handful of views and repositories. The repositories are using the
>> standard extBase query object and our Oracle DB backend. All of the
>> select functionality seems to be working well, including limits,
>> sorting, joins and queries using the "LIKE" operator.
>>
>> We haven't yet tackled inserts and updates, but will as soon as the need
>> presents itself.
>>
>> best,
>> Zach
>
> Is the code published somewhere? We have a oracle database containing
> person data and currently we mirror the data into MySQL to use extbase
> without crude hacks. I'm really interested in having a look at your
> extension, if this is possible.
>
> regards
> Dennis