To Work With Oracle...

Hello, John...

How difficult would be to a user ( on a hypothetical extreme need ) to alter ( hack ) vBulletin in order to make it work with Oracle? I didn't see your code yet, as you know...

I am working with someone over the next few weeks to release an OFFICIAL Oracle version hopefully. It all depends on how easily Oracle accepts the MySQL syntax.

John

> ...to release an OFFICIAL Oracle version hopefully.

Thank you, John... :D

[ /me jumping up and down wildly ]

Originally posted by John
I am working with someone over the next few weeks to release an OFFICIAL Oracle version hopefully

Not that I care, but I guess this was put on hold?
Or will Oracle be supported in the much anticipated "summer release"?

How about Sybase? It is considerably cheaper than an Oracle system and offers much of the same features / stability / etc.

thetakerfan,

I believe John's working on the Oracle version, but it is unlikely to be released as a feature of the "summer release".

All the best,

James

> Not that I care, but I guess this was put on hold?

It is my entire fault, actually... :)

To avoid unnecessarily absorbing John from the mainstream vB development for such a ?minor? improvement, I should have provide him with an Oracle server to play with ( and a couple of 8i developers to help things out ), two months ago... However, due to some internal corporate struggles I failed miserably (so far). Well, I will wait John to return from his development marathon on the backwoods to propose and discuss some alternatives...

mrogish : Oracle support, LDAP compliance, and some others specific features were proposed just to help the vB acceptance in the corporate market.

Aldreis,
Ok then, I just know that there are people (me for instance! :)) who want more features than mySQL can provide and can't afford the $50 - 100K price tag that Oracle 8i Enterprise offers -- Sybase offers an attractive DB at around $10K, which is *much* easier on the wallet.

As a matter of fact I've already started working on a port for Sybase (anyone want to help? huh? :)) -- it exposed a lot of really inefficent things in mySQL -- for some reason mySQL doesn't care about "NOT NULL" columns in inserts, non-standard column types, that sort of thing.

well, according to their calculator, an oracle license would be fairly cheap for my Dual 600 machine. Only $520,000 for a single machine license.

Please tell me I did something wrong????

(Disclaimer: Oracle is cool. They make a good, albeit expensive, product. This is meant to be sarcastic, so if you recently spent over $100,000 on Oracle 8i Enterprise and you are all flustered over this, deal with it)
Wow, what a deal!

You must be using some of their wacky pricing schemes! On an internet box you have to use the UPU -- Universal Ripping-You-Off Unit.

For us (dual PIII-750):
1500 UPU = $150,000
Minus a volume discount (some random number so it isn't a total rape): $37,500

Total: $112,500

Let me repeat:
WOW! WHAT A DEAL!

And the weird thing is, I was talking with an Oracle tech to see Sybase ASE vs Oracle 8i Enterprise and he said they were virtually identical. That doesn't explain the factor of ten price difference!

sorry to bring up old thread.
my company would be extremelly intrested in vB if it had support for Oracle and LDAP servers...
any news about these 2 features?

A Sybase version of vBulletin is in the works, or so I believe. I am not sure when or if vB will be ported to Oracle.

Also, I know LDAP is in consideration for a future release.

-Chris

Originally posted by Chris Schreiber
Also, I know LDAP is in consideration for a future release.

-Chris

any chance you could give aproximate time frame of this future release? something beside "when it's done" :)

Being an Oracle Developer myself and having recently learned PHP. I can say that each and every SQL statement in the newest version (1.1.4) will have to be changed to support ORACLE.

Especially getting rid of those JOINs.

The actual structure of the database is ok, except for the auto-increment fields but sequences will handle that.

Given That:
If you have a good developer, he should be able to convert the entire vBulletin Application to Oracle and Stored Procedures (big performance enhancement) in about 30-45 days.

After conversion there would be little-to-no ACTUAL SQL in the product though because it is much more efficient to use stored procedures.

I personally would be willing to undertake this project for proper compensation.

The same goes for anyone wishing to run vBulletin under Sybase or SQL Server.

If anyone is interested you can contact me through the email form.

Originally posted by wluke
The same goes for anyone wishing to run vBulletin under Sybase ...

I have already ported it over to Sybase, and it looks like, if all goes well, that we and Jelsoft will reach an agreement to hand the code over to them, thereby making it an official release.

P.S.
http://www.vbulletin.com/forum/showthread.php?threadid=4444&pagenumber=2


[Edited by mrogish on 11-16-2000 at 07:09 PM]

Any word on an Oracle version?

[Frank]

Well now a year since this has been covered, any further development on an oracle version?