Oracle port

[pedershk]

Okay, I have to ask this.

Since it seems like it's gonna be a loooooong while (if Ever) until Jelsoft decides to write a port for vBulletin for Oracle - has anybody done this already? Or do you know somebody who has?

If not, I might be doing it myself. Would anybody be interested in joining a three-week intensive team effort to get this done??

[etones]

you might want to contact John on this one, he may offer you todo the port.

[pedershk]

John? Which John?

John? If you know about this - please reply here :-)

[Chris Schreiber]

This John here. He's the primary vBulletin developer and may be interested in getting in touch with you about this.

[pedershk]

Yup. Just sent'im an email about the subject, and we'll see where it goes from there.

Any news/progress on this?

I know one of the frequent posters on the site has added Sybase support to vBulletin already and is working with someone on the dev team (Ed Sullivan?) to get it folded into the official code base. Haven't seen people mention pre-existing Oracle ports however. Probably because so few people have access to Oracle.

-Jonathan

[eva2000]

John's on holiday i believe

Just curious: which data type did the author of Oracle port decide to use instead of MEDIUMTEXT in MySQL?
Is it CLOB?
And how would he implement LIMIT function?

I think it would be easier to do then you might think. Since all of the database interaction is handled via a class in a self contained file, and the way its called is basically by taking a name from your config file (the one with your sql server, password, database, etc. in it) it might be possible to simple rewrite the existing functions so you would be left with the same functionality, but it would be utilizing a different class, and hence a different database. using the current class as a blueprint, basically.

i've thought about this many times as some of vb's db interaction really hits my server performance. i have a fairly large board, and especially searching can litterally hang the server. the only thing thats kept me from giving it a go, is the fact i cant really afford the oracle software :P

hell i can barely afford my cell phone bill with banner ads paying what they are :P

note: you'd need some kind of parser for the queries themselves :\

[etones]

urm, i think i'll break the bad news to you...

although a lot of the dabase calls are stored within the class files... a hell'uva lot are also hard coded into the actual vb php scripts..
fair enough, you can re-code the class files.... but you also need to re-code most of the entire vb software