[TYPO3] Has anybody else integrated a second database with TYPO3?

[R. van Twisk]

hey Daniel,

a client of mine has it's data in PostgreSQL which is also incompatible 
with typo3.
But to make things easy for use we are writing a small module to copy 
the needed
data from PostgreSQL to Mysql. This works well for our situation.

We are going to use it to sell things... Then everyday we take the data 
from the
sale table of typo3 and sync it back to PostgreSQL. This on a daily base
at 1AM in the morning.

The advantage of doing it like this are

1) No Changes in typo3 or it's extensions.
2) We can keep our original data normalized per design.

Disadvantage:
1) We have to make two sync modules.

We basically handle business data in TYPO3 in such a way
that we can always feed TYPO3 with new data. SO we
always have our 'real' DB in PostgreSQL and not in the
data structure of TYPO3.

I am personally aiming to not changing typo3 or any of it's extensions.


One side note:
You can write TYPO3 compatible extensions that sit's in a external
DB and let typo3 'manage' the data with BE modules.
This is what we do under some situations.

Ries




-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk
=== Work:
email: ries at livetravelguides.com
web:   http://www.livetravelguides.com