PostGre Conversion... mmm, im not asking :)

[etones]

Hi all, ok I have postgre installed on my server, now if I were to create a script that would replicate my exisiting mysql database in postgreSQL, how difficult would it be to re-code vbulletin to use postgre?

As i understand it, postgre works with almost all mysql sql commands....

other than changing all php calls to mysql, what else would be changed??

Cheers all, 4php... one for you :)

[tubedogg]

In order to experience the full benefits of using another RMDBS you would need to rewrite the majority of vBulletin to take advantage of things specific to that RMDBS.

[4php]

You will find some tools to convert from MYsql to Postgresql at this site
http://techdocs.postgresql.org/
Also seems to be a php/mysql to php/postgresql script there too.
You might need to alter some of the sql syntax too. You'd just have to try.

[etones]

Hi tubedogg, im not really interested in optimising vb to work on postgre, i just want it to work.

As it stands only the SQL limit commands would need re-doing and all mysql php functions coverting over to php postgre fucntions.

As I said, Im not after an optimised port, just a working port :)

Cheers all.

[Mike Sullivan]

As it stands only the SQL limit commands would need re-doing and all mysql php functions coverting over to php postgre fucntions.I assume you mean MySQL's LIMIT feature? Well, yes, that'd be one. But you'd also have to change all the LEFT JOINs, as I think PgSQL uses a different syntax.

The install script is also a major pain to convert, but I don't know if you'd have to do that.

[4php]

Shouldn't need to redo the install script. There are perl scripts that will convert your database to MYsql. Never tried them though.

[Mike Sullivan]

The install script part was in reference to when I was playing aroung with PgSQL and vB a while back -- an install script would be necessary then.

[etones]

well, i'll give it a go and keep ya all informed then :))