Which database to use- Mysql or Oracle? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

If someone is to build a University Management开发者_C百科 System using PHP, which database would you suggest for that- Mysql or Oracle? Or let me put it this way.. is it okay if someone uses mysql as a database for the University Management System or it is better to use Oracle?

Thanks in Advance

EDIT

Sorry, I should have been more specific about the University management system. What the plan is, to store student, teacher, employees information. Enroll Students in courses(students will hook up online and do it by themselves). All students,teachers and employees will have own personalized page. Some other features are fee collection, library management, attendance tracking etc.

Thanks :)

---

In my opinion, MySQL is powerful enough for most things. If you're looking for data storage, then MySQL will do the job. If you're going to be doing a lot of clustering, replication, stored procedures, triggers, and integration with enterprise software such as PeopleSoft, then Oracle may be a better solution.

It's a rather hard question to answer with out knowing how the database will be utilized.

In my experience I have used MySQL clustered and replicated across time zones with high traffic social networks, and have had no problems.

---

If you write your PHP application using the PDO library for your database access, then your application will be able to work with either MySQL or Oracle (or several other DBs) without having to change the code.

However, if you have to make a choice over database now, then between these two it comes down to cost: MySQL is free; Oracle costs money. Quite a lot of money.

There's nothing wrong with MySQL as a database. It is capable of running high performance, high volume systems. There are advantages to using a commercial database like Oracle though (they wouldn't be able to justify the price otherwise).

(By the way, as an aside, it's worth knowing that the Oracle company also owns MySQL. So in fact both databases are produced by the same company)