[TYPO3-dev] DBAL error on fe_groups,pages

[Martin Kutschker]

R. van Twisk schrieb:
> 
> 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).

Of course you can replace all JOINs with loops and multiple queries, but 
why bother then with SQL? Sorry, it's IMNSHO ridiculous to ask for not 
using JOINs in any application that works with a SQL database.

> It's cool that DBAL can 'export' tables to other databases, 

IMHO this is a gimmick of DBAL. The only real world expamples I could 
image til now is storing the data of an extension or perhaps tt_adress 
(for direct mail) in a different 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.

You could try and XCLASS DBAL itself and replicate the fe_users table 
(ie duplicate all INSERT/UPDATE/DELETE statements). But how to get DBAL 
to do the JOIN with the right copy when doing a JOIN?

> 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?

I played with the idea myself. If it were only about t3lib_db I had 
given it a try, but you need to XCLASS more files (for the installer 
etc). And I was not sure if I don't need ADOdb (like DBAL) in the end, 
so I never tried.

Masi