corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » people who know about Oracle/MySQL


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author people who know about Oracle/MySQL
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 09:29   View User's Profile U2U Member Reply With Quote
I am setting up a messageboard for my work, will have about 600 users to start with. The company prefers IIS with asp/oracle, I have persuaded them to let me use Apache/PHP, but they are not budging on the oracle front.

Ideally I would like to use Invision Power Board as my website (http://sniffglue.net) uses it and i have spent a lot of time customising it, but it only uses MySQL!

Does anyone know of any BB software that uses PHP but uses Oracle as a backend, or why MySQL would be better so i can put an argument together!

Ta Muchly
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 10:43   View User's Profile U2U Member Reply With Quote
Tim
Site Administrator

Avatar

Registered: 21st Apr 00
User status: Offline
19th Jul 05 at 10:46   View Garage View User's Profile U2U Member Reply With Quote
There's an Oracle driver available for Invision board for a fee (< £50 IIRC)...

Why use Oracle though as MySQL is much more lightweight, free, and I'm sure you don't need your message board to be so resilient to data corruption...
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 10:49   View User's Profile U2U Member Reply With Quote
Ooh, ill see if I can find that, thanks!

I dont want to use Oracle, i want MySQL as im used to it, but oracle is the company standard!

Isnt Oracle going to make it a pain to mod the forum as well, its going to need some quite drastic work to make it work how we need it to

thanks for the reply!
Tim
Site Administrator

Avatar

Registered: 21st Apr 00
User status: Offline
19th Jul 05 at 10:59   View Garage View User's Profile U2U Member Reply With Quote
The driver is available from invisionboard.com...

Once installed you should be able to mod the hell out of the board as normal -- you can still hack all the tables and queries as usual.

It's the same here with Oracle being the company standard (I assumed this is quite a big company), but there's no point running Oracle installs unless you 1) know what you're doing and 2) have appropriate licensing...
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 11:16   View User's Profile U2U Member Reply With Quote
The problem is that i use this http://mods.invisionize.com/db/index.php/f/3456 SDK to find out the user ID of the logged in member then do my own queries on top of that. Any idea id that mod will work with oracle?

Ive seen the Oracle driver on the IPB site now, looks good.

How easy is it to query Oracle databases in PHP, im assuming not as easy as MySQL?

Cheers Tim
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
19th Jul 05 at 12:05   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by MikeLamb
why MySQL would be better
Its free and works now. Anything else is money and time.
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 12:36   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
quote:
Originally posted by MikeLamb
why MySQL would be better
Its free and works now. Anything else is money and time.


Unfortunately its the opposite for them, everything is currently oracle and paid for. They dont want to spend any time installing MySQL, so frustrating considering I could do it myself!
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
19th Jul 05 at 13:03   View Garage View User's Profile U2U Member Reply With Quote
Connection is different but queries should be similar tbh.

Time installing MySQL is greatly outweighed by time faffing with code though!
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 13:08   View User's Profile U2U Member Reply With Quote
Yup, thats the frustrating part, if it was my choice it would be linux, Apache, Php and MySQL, the best I have been offered is Windows, Apache, PHP and Oracle
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
19th Jul 05 at 13:09   View User's Profile U2U Member Reply With Quote
do you know how Oracle is managed, In the respect I use PHPMyAdmin for MySQL, what would I use for Oracle?
Tim
Site Administrator

Avatar

Registered: 21st Apr 00
User status: Offline
19th Jul 05 at 13:15   View Garage View User's Profile U2U Member Reply With Quote
I use dbVisualizer (java app). Can get oracle and mysql jdbc drivers for it so it can connect to nearly everything...

Actual admin of Oracle should be performed by your DBAs. If you need to create a database you need to run 'dbca' as the oracle user. To manage the DB you can do most things using 'oemapp dbastudio'...

(both are graphical so if it's a remote host you need to ensure you are forwarding X11 connections and are running a local X11 server)



[Edited on 19-07-2005 by Tim]

 
New Topic
New Poll

Corsa Sport » Message Board » Off Day » people who know about Oracle/MySQL 23 database queries in 0.0158942 seconds