Oracle 8i Database?

[kitchend]

I would like to use vBulletin on an Oracle 8.1.6 or Oracle 8.1.7 database and have the queries as stored procedures, etc for performance gains.

Is an Oracle port being worked on, or should i simply port this myself?

If no port is being worked on and I were to do it myself, would vBulletin want to pay for that work (once completed) so that they too could sell the new Oracle version of vBulletin?

If no port is being worked on at all, could i re-write vBulletin to fit a Vignette, Oracle, iPlanet environment (i.e. new build, same functionality and similiar achitecture) and retain ownership of the new build? i.e. without vBulletin claiming rights to parts of the HTML, which would obviously be similiar? Would vBulletin be interested in licensing a Vignette & Oracle version from me?

All high-end questions, but i desire an Oracle version, if I need to write it myself, i'm more inclined to write a Vignette one than work on a Oracle/PHP version ;)

Opinions welcome.

Cheers

David Kitchen

[eva2000]

Matt from www.fanhome.com ported a Sybase version but not sure anyway has done the same for Oracle

do a search for sybase on this forum and you'll find the posts

[doron]

I think Jelsoft is doing a Oracle port, probably once vb2 is completed. You best contact them (john@jelsoft.com and james@jelsoft.com) for more info ;)

[gitdown]

hi there.
over at winamp.com, we need vbulletin running on
oracle so we can integrate our forum users with the
other users. I've ported the entire data model to
oracle (vbulletin 1.6) and I've done a port of
db_mysql.php to have db_oci8.php. I'm using
oracle 8.1.6. I need to finish this up relatively soon,
and I'd be happy to help out anyone who is also
attempting this. I don't plan on having a pretty
installer, but will write up a document on how
to create and populate all the necessary tables.

Thanks,

Rolf

[eva2000]

Originally posted by gitdown
hi there.
over at winamp.com, we need vbulletin running on
oracle so we can integrate our forum users with the
other users. I've ported the entire data model to
oracle (vbulletin 1.6) and I've done a port of
db_mysql.php to have db_oci8.php. I'm using
oracle 8.1.6. I need to finish this up relatively soon,
and I'd be happy to help out anyone who is also
attempting this. I don't plan on having a pretty
installer, but will write up a document on how
to create and populate all the necessary tables.

Thanks,

Rolf cool.. gitdown contact Jelsoft :)

wow possiblity of both a Sybase and Oracle version of vB :D

[kitchend]

gitdown,

if you would like i could help you with your port,
i would happily devote some time to making an Oracle 8i (8.1.6 and above) or 9i version of vBulletin 2.0.

i also see no reason why we can't produce a PL\SQL script to install all of the tables, constraints, stored procedures and populate the tables with the default templates, etc. effectively making a simple installer to be run prior to the PHP installer being run.

once we have that much done, then i also see no reason why i couldn't create a Vignette front-end for the Oracle back-end, resulting in a true enterprise class version ;)

the hardest thing then is to work closely with vBulletin to ensure that our versions maintain the security and improvements evolution that the PHP/MySql version revels in.

cheers

david kitchen

[Fippy]

We at SOE would also be interested in working with other folks on an Oracle version.

If anyone has set up an Oracle/VBulletin email list or other line of communication, please include me?

Has anyone completed the port yet?

Thanks all!
Fippy.

[qasic]

A guy by the name of "The Prohacker" did an Oracle version of vBulletin; you may want to contact him for details. He's a regular browser of these boards.

qasic

[eva2000]

bringing a 6 month old thread back from the dead :)

a postgresql port is being worked on and a sybase port has been done as i said above by fanhome.com

still not sure if anyone has a working Oracle port.. would be hard for vB/jelsoft to do such a port without access to a oracle license???

[eva2000]

Originally posted by qasic
A guy by the name of "The Prohacker" did an Oracle version of vBulletin; you may want to contact him for details. He's a regular browser of these boards.

qasic he did?

[The Prohacker]

I did a port for a company, so I can't release that the files I made, they are now owned by the company that hired me. Sorry, I'll try to be as much help as possible if you need me....

[qasic]

Getting a whole team to work on would be cool - whether it be pubically or the Jelsoft led :)

Prohacker, I heard that the search queries optimized for Orcale was the hardest part; can you confirm?

qasic

[dragoco]

I am also try to use Oracle as the database server cos my client needed only Oracle as the server. Anyone can help?

[Fippy]

I'm reading in other forums that VBulletin 2.x backed to Oracle is not a good performer, and does not scale well, maybe not even past 1000 or so users.

Does anyone have any evidence to share with us?

What is the largest simultaneous count that anyone has experienced (and measured) with VBulletin in general?

[JamesUS]

There is no evidence whatsoever to support that claim. vBulletin does not run on Oracle at all - therefore no claims can be made about it's performance.
The claims may be true for an unofficial hacked version of vBulletin, but if an official version was made it would be optimized heavily for Oracle and would most likely be able to exceed 1000 concurrent users.


I believe the highest concurrent user count I've seen is somewhere around 7-800 (on MySQL). There may have been higher though. Bear in mind this is higher than average and the server was probably very powerful. Most servers won't be able to hit this figure.

[Fippy]

Thank you for the swift update. The figure you quoted is useful.

I understand your opinion about Oracle ports - another reason to get an official port done. :) That is what we are most interested in.

[Mike Sullivan]

*looks at name*
You know, I woulda sworn that said Flippy before. :)

The highest "concurrent user" count I've seen was at HardOCP's forum: http://www.hardforum.com/ -- 950. But I don't have any specs on their hardware or anything.

[laughlen]

perhaps not greatly constructive as I am not a programmer (not even close!), however, I would like to add my support for an Oracle port.

We are building a vB solution for an alumni community of approximately 20,000+ people. It is an effort of the alumni association, but we would like to integrate it in future to the universities internal systems, and that means Oracle.
We run linux/mysql/apache/php
they run NT/oracle (backend) and Solaris/iplanet/coldfusion/ (frontend)

anything that brings us closer together but allows us to keep vB is a good thing, and we would certainly be likely to pay more for it.

[Prometheus]

:D