PostgreSQL (mssql, Oracle etc)...

[vitalic]

it`s a good idea make db_layer for different SQL.. (like it done in phpBB)...

YaBB - best (best from other ibb,ubb,phbb etc, etc...)
best `coz:
1 - have one - simple template
2 - can switch on/off images
3 - handle all what can be needed in forum
but...
i use YaBB gold... and need/want to upgrade to YabbSE but... i have postgreSQL, and many-many parts of site use PostgreSQL...

i begin recoding YabbSE for handle other SQL ...not all, but PostgreSQL or MySQL...

may be someone make it too?

now i rewrite particulary index.php, MessageIndex.php and Subs.php...

[Spaceman-Spiff]

YaBB SE 2 will have multiple database support

u can read here if u wanna know more: http://www.yabbse.org/community/index.php?board=142;action=display;threadid=19755

[vitalic]

thanx for answer) so... than i stop rebuilding, and wait till YaBB SE 2...
did i can help for developming?...

[Spaceman-Spiff]

hmm... i don't know if we need more devs or not
how good are you with php and postgres?
you can try contacting one of the admins here

[[Unknown]]

Well, I don't know much about the differences, myself...

Would you mind posting/pming me a short list?  The only one I know is that I *think* it doesn't support LIMIT.

-[Unknown]

[[Unknown]]

Well, I don't know much about the differences, myself...

Would you mind posting/pming me a short list?  The only one I know is that I *think* it doesn't support LIMIT.

-[Unknown]

Thanks, I was wrong :$.

*goes off to get a replacement for FIND_IN_SET...*

-[Unknown]

[Gobalopper]

A lot of the CREATE TABLE queries are probably going to have to change as well.

And I know that Oracle doesn't support LIMIT at least the versions I've used.

[groundup]

can someone post that list of differences?

[Spaceman-Spiff]

hope this will help a bit:
- http://www.sitepoint.com/article/529/1
- http://www.sitepoint.com/article/542/1

[[Unknown]]

For FIND_IN_SET:

when i make port from mysql to pgsql ...
i have one field where CSV of members was used... in mysql i use find_in_set... in pgsql i replace it to:

$findinset="(parentlist='".$id."' or parentlist like '%,".$id."' or parentlist like '".$id.",%' or parentlist like '%,".$id.",%')";

i`m not sure about speed, but it`s work

So, I guess...

tr/FIND_IN_SET\(([^,]+?),\s?([^,]+?)\)/\\2 SIMILAR TO '(,|[^.])' || \\1 || '(,|[^.])'/

CONCAT would be more difficult to change from CONCAT(a, b, c, ...) -> a || b || c || ...

about LIMIT you can read at manual:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=queries-limit.html

so, and in pgsql is absent:
REPLACE INTO
FIND_IN_SET
IF (but CASE exist)
...
P.S.
i`am not too proffessional in pgsql, `coz all i do that for  MySQL, but in my new work, more parts of site use PgSQL.... and i need rewrite/upgrade some...

Much in the way of thanks go to vitalic for this.

-[Unknown]