OraFAQ Forum: MySQL » Oracle over MySQL

Home » Open Source » MySQL » Oracle over MySQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle over MySQL [message #302065]

Fri, 22 February 2008 19:10

evergrean
Messages: 15
Registered: February 2008

Junior Member

We have a selection in my area between Oracle 9i and MySQL (version 4.1) for our databases that are used as back end for Web Applications built with Cold Fusion and JSP/Servlets.

I am trying to find the advantages of using Oracle (my preference) over MySQL. Please advise how Oracle is better than MySQL.

Report message to a moderator

Re: Oracle over MySQL [message #302067 is a reply to message #302065]

Fri, 22 February 2008 19:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please advise how Oracle is better than MySQL.
MYSQL is easier to install & support.
Since you had to ask this question, I conclude Oracle would be a sub-optimal choice for you.

Report message to a moderator

Re: Oracle over MySQL [message #302087 is a reply to message #302067]

Sat, 23 February 2008 05:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Also, did you consider price you'd have to pay for these products? Did you have Oracle Express Edition in mind (which is free, but with some limitations)?

Report message to a moderator

Re: Oracle over MySQL [message #302094 is a reply to message #302065]

Sat, 23 February 2008 06:57

evergrean
Messages: 15
Registered: February 2008

Junior Member

Price is not an issue and I have many instances available for me to use.

My Web applications dont use alot of tables per application and they dont have alot of heavy processing in the database but I like Oracle Client and working with triggers, sequences and the availability of PL/SQL.

I was hoping I can convince other people I work with to use Oracle over MySQL. Everyone likes MySQL (we have older version - 4.1) because it has autonumbering, easier to use and no privilege issues.

Report message to a moderator

Re: Oracle over MySQL [message #302095 is a reply to message #302094]

Sat, 23 February 2008 07:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

evergrean wrote on Sat, 23 February 2008 13:57

Price is not an issue and I have many instances available for me to use.

... and all of them are licensed? I'm NOT saying that you are doing anything illegal (God forbid!), it's just that using Oracle for educational purposes (free of charge) is different from putting your development efforts into production (which should be charged).

Oracle isn't cheap, so - either you are wealthy, or work for a company that licenced its Oracle product(s) or ...

Report message to a moderator

Re: Oracle over MySQL [message #302097 is a reply to message #302095]

Sat, 23 February 2008 07:34

evergrean
Messages: 15
Registered: February 2008

Junior Member

Thanks, yes everything is licensed and paid for.

Any other advise for using Oracle over MySQL?

[Updated on: Sat, 23 February 2008 07:35]

Report message to a moderator

Re: Oracle over MySQL [message #302100 is a reply to message #302097]

Sat, 23 February 2008 09:13

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.google.com/search?hl=en&q=oracle+vs+mysql&meta=
Regards
Michel

Report message to a moderator

Re: Oracle over MySQL [message #302105 is a reply to message #302100]

Sat, 23 February 2008 11:09

evergrean
Messages: 15
Registered: February 2008

Junior Member

Thanks, I saw many opinions from the Google results saying: "mysql and oracle. It depends what you're using it for

It seems it will come down to the actual requirements (and price) and what I am using it for which is the same situation I had when comparing my use of Java or Cold Fusion.

Report message to a moderator

Previous Topic:	Oracle acquires BEA/ Sun to acquire MySQL
Next Topic:	Oracle 9i Connectivity Problem with MySQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 02:26:47 CST 2025