Geek Answers Handbook

Oracle XE or MySQL, which one should I choose?

I am going to create an SNS site. Now I need to make a decision between Oracle XE and MySQL.

I know that you are a group of experts. Can you share some comments on this?

Best wishes

Ariso

+6
oracle mysql database-design
source share
4 answers

What I would think:

1) Do you ever want to zoom in? If so, Oracle will allow a very straightforward route to the scalable platform (you can simply back up the database and restore it to a full Oracle instance).

2) Are you going to scale moderately? If so, Oracle XE is limited to the total DBG size of 4Gb, where MySQL can run reasonably significantly more.

3) Are there other restrictions on Oracle XE? It will only support 1 GB of RAM and 1 processor, for example. If you think that you will likely need more than a decent job, this is not a starter. For more details, see the FAQ ( http://www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf ).

4) Do you have skills in your organization? Not only as a developer, but also for support, backup strategies, and so on. If you have the skills in place, then probably go where you have the skills. Make sure you talk to support guys and get their input.

My messenger says MySQL, but use the above to weigh it.

+12
source share

I would choose MySQL. Oracle XE is just supposed to be used to prove the concept. It looks like a cracker giving you a taste and then loading you with a butt after your hook: D

I think MySQL is a reliable choice for low to mid level applications. But your expected size negates your decision.

+8
source share

I would like to point out that Oracle recently acquired MySql and that the future of MySql is a little bit in the air. If you are familiar with Oracle XE, you can use it, but I would like to point out the following reasons for not using Oracle.

Oracle licenses are the most expensive in the business (Sql Express might be better because Sql Server is cheaper)

Oracle is almost inaudible in the hosting domain. Hosting providers will provide SqlServer, MySql and PostGre Sql, but I can’t even think about what Oracle Hosting is.

+3
source share

This is very similar to the question: what language should I use? Long before you run into scaling problems, you are likely to run into problems of experience. I think you should ask yourself more basic questions, such as:

  • What type of support is available if you encounter problems? For example: IRC, forums, bloggers, friends;)
  • How good is the documentation?
  • Are there any free tools?
  • How well does your language support the database of your choice?
  • With your language, which database is most often used with the db code sample?
  • What are you facing?

So, for example, if you use Ruby, you probably want to go with MySQL. If you use PHP, the choice may be a bit blurry.

+1
source share

More articles:


All Articles