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 (http://www.vbulletin.com/forum/member.php?s=&action=getinfo&userid=1). 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.

[roy7]

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 :)

[Ivan]

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?

[Ratorasniki]

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

[Wayne Luke]

Originally posted by Ratorasniki
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.

Actually it is more difficult than that since the Oracle functions are different from the the MySQL ones. For example there is no oracle_query function..

Second Oracle doesn't use Left Join terminology so almost every query has to be rewritten...

Third, Oracle doesn't need a LIMIT command because it can handle data like a database should. It doesn't choke on a few million records in an array like MySQL would. You could implement an approximation of this either in PHP or in Oracle's PL/SQL though.

A truly specatular port would have to take advantage of stored procedures and triggers. Only then would you be able to experience the true power of Oracle and support 10s of thousands of users concurrently on vBulletin.

[Ratorasniki]

Alrighty well i do believe i was just owned :o

I know nothing of oracle, so take the above as a guestimate at best. I should've mentioned that above :o

The extent of my Oracle knowledge is that its one of the fastest databases, and some extremely simple syntax. I think i'll go back to my corner :D