[TYPO3-dev] DBAL error on fe_groups,pages

[R. van Twisk]

Martin Kutschker wrote:
> R. van Twisk schrieb:
>   
>> Hey Guys,
>>
>>
>> for a DB I am designing I need to move just a couple of tables 
>> externally to PostgreSQL
>> so I can create references from other tables to the fe_groups table to 
>> other tables.
>>
>> Now I did that I get this error:
>>
>> DBAL fatal error: Tables in this list "fe_groups,pages" didn't use the 
>> same DB handler!
>>
>> The error originates from tsfebeuserauth (I think).
>>
>> Should I just goahead and move everything to PostgreSQL?
>>     
>
> All tables that are joined together in a single query must reside in the 
> same DB. The DBAL errors will tell you which ;-)
>
> Masi
>   

Hey Martin,

I did understand about the joins

However what is the guideline for typo3 core? Is it allowed to do joins 
in favor
of execution speed, or should it do two separate queries in favor of 
DBAL 'compatibility' (but slower).

It's cool that DBAL can 'export' tables to other databases, however it's 
of not much use
if the core itself makes joins and thus prevents of 'exporting' a single 
table
to a other DB.

For now I leave the tables into mysql and I unfortunately need to write 
'DB check' functions
to delete appropriate records when a row get's deletes.

I have been playing with the though to make a native PostgreSQL driver 
for TYPO3 just like
there is a native driver for MySQL. Any thoughts on this?

Ries