Hi All. I like PostgreSQL and have began to port b2evolution to MySQL. I think that the dificulties wil be almost the same to port to another database like firebird or oracle.
I thought that the main attack would be in _db.class.php.
But there a lot of other things :( .
The standard SQL way to quote string is a single quote, not double quotes.
Just changing that on a lot of files makes the query work.
The sandard way to concatenate string is || and not the mysql CONCAT.
You can change the setting of the significanfe of "||" in MYSQL using PIPES_AS_CONCAT, but I don't know if '||' are used as or in other queryes.
REPLACE will be a difficult thing.
But I thik that we can begin with the easier: replacing double quotes for single quotes :)