[TYPO3-dev] Current Status of Postgresql Support plus migration of mysql to postgresql

[Ries van Twisk]

On Apr 21, 2009, at 5:15 PM, Marcus Krause wrote:

> Oliver Leitner schrieb am 04/21/2009 10:39 PM Uhr:
>> Hello Everyone
>>
>> Since Oracle bought Sun, MySQL will prolly die pretty soon either as
>> an opensource product or totally...
>
> Don't worry, MySQL will not die. Oracle and MySQL Community version  
> have
> different target groups. Oracle would be pretty silly if they stop  
> MySQL
> development.
> Furthermore, even now there are promising MySQL forks.

Indeed, even Monthy created a fork already so MySQL will not die
I do see an increased worry inthe MySQL community and
I noticed from different channels question marks above teh heads of  
people.

It looks like that PostgreSQL is slowly going to be more mainstream.  
It will
never (<5 years) be a replacement of MySQL though for the LAMP stack.

>
>
>> for that reason id like to know where i could find the current status
>> on using postgresql as a database for typo3, as i see the future  
>> going
>> there...
>
> The current status is that it's not running out of the box. To test it
> put your mysql server in SQL strict mode (and use dbal). Failing  
> queries
> will also fail for postgres.

Don't bother to try.. core will run fine but extension will not, and  
you will
end up with a horrible upgrade path. DBAL is evil for a complete  
replacement for all tables.

Ries

>
>
> Marcus.