Where to find a good link when choosing a database?

Question

I and two others are working on a project at the university.

In the project, we are creating a prototype MMORPG.

We decided to use PostgreSQL as our database. Other databases that we reviewed were MS SQL Server and MySQL. Does anyone have a good recommendation that will justify our choice? (preferably last year)

Answer 1

Someone recently recommended wikivs .com to me : MySQL vs. PostgreSQL is a pretty detailed comparison of the two, and may help you.

Answer 2

the most famous difference between MySQL and PostgreSQL is related to your read / write ratios. If you read a lot more than you write, MySQL is usually faster; but if you do a lot of heavy updates for the table, as often as other threads should read, then MySQL's default lock is not the best, and PostgreSQL might be the best performance choice.

IOW, PostgreSQL scales better with respect to writing to DB.

why he usually said that MySQL is best suited for webapps and PostgreSQL is more "enterpriseisey".

Of course, the picture is not so simple:

• InnoDB tables in MySQL have very different performance behavior
• At boot levels, where it is better to block PostgreSQL, they intercept MySQL, other nodes of your platform may be bottlenecks.
• PostgreSQL is more standards-compliant, making it easier to replace later.

in the end, the choice has so many variables that no matter how you go, you will find an important problem that makes it the right choice.

Answer 3

Go with something that someone on your team has actual production experience. All databases have problems that users often know about.

I can’t stress that someone in the team needs PRODUCTION experience in using it. Do not use it for your homework or for storing a list of CDs.

Answer 4

All these databases have their advantages and disadvantages. It better depends on:

Your teams are experiencing
Your exact requirements
Your current environment, for example. What is your application written for and will be posted?

The main problem of SQL servers is the cost if you do not use the express version, which has performance limitations, but is very easy to use and has a number of good tools.

There is a comparison of different versions of SQL: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Then you can compare them with MySQL and PostGre.

If the purpose of this comparison is theoretical for your essay, then you can link to web pages, such as a link to Microsoft, and compare performance, cost, etc.

Answer 5

Postgresql has a case study page that you can link to and link to.

Indeed, any of the above would work for you. I personally like PostgreSQL. One solid advantage that it has over MSSQL (even assuming you can get it for “free”) is that PostgreSQL is not a property. If you are going to inject dependency into your project (and re-creating RDBMS will be crazy), you do not want this to be a black box.