MySQL Postgressql and other database large evaluation

mysql| Data | database sequence
With the development of Internet and the activity of free software software, more and more people begin to apply various databases to their own network applications. Thus, a variety of database systems appear on the Internet stage, where the two most commonly used databases are MySQL and PostgreSQL, the Internet has different applications and user groups. Interestingly, as is the case with Linux in the operating system realm, there is a lot of controversy between the two databases, and these arguments sometimes affect the user's own judgment in large part, and make the user feel uncomfortable when making a choice, FreeBSD. In order to make it easier for us to look at the problem with our own eyes, we have specially sorted out some of the comparative information provided by various aspects, so that we can use it as a reference. At the same time, we collect materials and other databases of some information, in order to provide you with more complete information, we also included in the. Here we compare features and performance, and other important factors, such as copyright and activity, can be easily obtained from the rest of our resources, which we will not repeat here.
Copyright notice
The information quoted in this paper by the original and/or its Chinese translators, this article is allowed to do any non-commercial use of free reprint, but reproduced please refer to each author's respective copyright notices, if there is a conflict, please contact the appropriate author. The data and results presented in the article are carefully and rigorously examined by the authors, but the authors do not make any commitment to any data or results and do not assume any responsibility for any consequences arising from this article.
Version
V1.0.0rc1
The Stone of his mountain
This is a comparison of Matthias Warkus written by Yan Zi.

Here is an evaluation from a Russian hacker.
Wang Po sells melons
Here is a collection of various aspects of their own evaluation and comparison.

This part of the content is the Netizen Wangbin collects and collates.
PostgreSQL's Test
PostgreSQL own comparison test is simpler, mainly based on the characteristics of comparison, but it is interesting that there is no MySQL in this list, from the concept of PostgreSQL MySQL is not a complete database, presumably because of the current MySQL Some key database features are also missing.

Here is a simple contrast made by PostgreSQL himself.
The test of MySQL
MySQL provides a database test suite and is the most abundant and detailed data in the materials we collect. In addition to providing a comparison with PostgreSQL, it provides comparative data with many other databases. MySQL comparison is mainly based on speed and performance, in all of its platform comparisons have a feature comparison, but the lack of a is becoming free software rdbms--interbase (InterBase said starting from 6.0 open source, but do not know whether the GPL).

The following is the information and test results on the MySQL site:

You can find the complete source code of the test program and some comparison data tables from the MySQL source release version.

Table entries with _fast tags are tested when nonstandard ANSI SQL mode is allowed to use the cleanup command (cleanup calls). This is no longer a hundred percent SQL, but these data table entries are still useful.

Some of the table entries were sent to us by the MySQL user anonymously, so there is no guarantee that the test data is completely accurate and we recommend that you run the test program on the database that you are interested in. If you would like to share your test results with us, you can upload the files in the ' Output ' directory to ' www.tcx.se/pub/mysql/incoming ' with FTP, so that we can release the test data in future test results.
The following chart is a comparison of all the reference databases in Crash-me
Comparison of all participating databases provided in the Crash-me
The chart below is a comparison of PostgreSQL and MySQL on the Linux platform
PostgreSQL and MySQL comparison datasheet

Compared with MySQL, absolute comparison
The following chart is a comparison of Access 2000 and MySQL on the Win98 platform
Comparison data table for Access 2000 and MySQL

Compared with MySQL, absolute comparison
The following is a comparison of Adabas and MySQL on Linux platforms
Adabas and MySQL comparison datasheet

Compared with MySQL, absolute comparison
The following is a comparison of DB2, Informix, Ms-sql, MySQL, Solid, and Sybase on NT 4.0 platforms
Comparison datasheet for DB2, Informix, Ms-sql, MySQL, Solid and Sybase on NT 4.0 platforms

Compared with MySQL, absolute comparison
The following is a comparison of Empress,postgresql,mysql and MySQL on the Linux platform
Comparison datasheet for Empress, PostgreSQL, MySQL and solidsybase on NT 4.0 platforms

Compared with MySQL, absolute comparison
The following is a comparison of MySQL, PostgreSQL and Solid on Linux platforms
Comparison tables for MySQL, PostgreSQL and Solid on Linux platforms

Compared with MySQL, absolute comparison
The following chart is a comparison of MySQL and Oracle 8.0.3 on NT platforms
Note that Oracle is accessed by ODBC in this test! Many users use Oracle's own APIs to get faster!

MySQL and Oracle 7.0 comparison datasheet

Compared with MySQL, absolute comparison
The following chart is a comparison of mSQL and MySQL, limited by the limitations of the msql, within the context of a very small amount of comparative content
mSQL and MySQL comparison datasheet

Compared with MySQL, absolute comparison
The following table shows how MySQL works on a different platform
Note the difference between CPU clock speed and available memory between different platforms

Comparison of numbers on different platforms

Compared with MySQL, absolute comparison

Report:

TCX's declaration information:

This information is provided by TCX, so users can get a real picture of the different databases (rather than the information provided by the vendor). Hopefully the above information will make it easy for you to find a database server that has the features you need and that you have the confidence to use.

We will continue to try to get MySQL testing to help users understand how fast the database is running in different typical jobs.

TCX will also continue to develop crash-me to showcase the real flaws and performance of the database server.
Some other resources
In Www.linux.com and Www.linuxcare.com There are some of the voting nature of the comparison, these are mainly the user's personal preferences and views, there is no clear test standards and means, but still have a certain reference value for everyone, we list the links here, please visit these links themselves to see the results of the vote.
Swim
From these reviews we can see that the common features of the two databases are distinctive, each with focus and weaknesses, then whether we can come to a better conclusion and determine what support does not support what? We don't think so, because the development of both databases is very active, and many of the current shortcomings can be quickly remedied, such as: In the MySQL TODO list, the support of the transaction is clearly in the most important position; The latest version of PostgreSQL 7.0 of the speed and stability are greatly improved, in addition, the existing large object interface will be greatly enhanced in 7.1. These all indicate that both are progressing, are constantly developing, the real decision or as an application developer of our own, through reasonable analysis, to avoid weaknesses, correct choice of their own database To meet the needs of the application. Do not forget that the task of being a computer practitioner is to provide services to non-professional professionals with our hours and experience. Finally, we will continue this information comparison work, and constantly update our information, hope to provide you with more detailed materials.