Oracle 10g vs PostgreSQL 8 vs MySQL 5（外围特性评比）

PostgreSQL

I haven't previously used PostgreSQL outside of Cygwin (a Unix environment for Windows). I was surprised at the feel of the installation. It seemed very native and ran flawlessly. It was also a very quick install.

PostgreSQL installed the quickest. According to the documentation, you can install PostgreSQL without administrative rights. As this is the first version of PostgreSQL to support Windows (without Cygwin), I wanted to test the Services support. PostgreSQL installed as a service and came up without problems after rebooting.

PostgreSQL Installation Ranking: 10

MySQL

I ran a web site in the past, mainly for my own amusement, and used MySQL as the database. The technology stack I used was Java/Apache/MySQL. I was fully expecting MySQL to win the installation competition based on experience. However, MySQL was the only install to fail during installation. I performed a little cleanup and then re-ran the install. It failed again. I cleaned up again, rebooted and re-ran the installation. This time it installed. I'm not sure what caused the error. It was very cryptic but it was the same both times it failed. I was able to bulldoze past that, though. Remember, this is a beta release.

MySQL also installed as a service and on reboot came up with no errors. The install, when it ran correctly, ran quickly.

MySQL Installation Ranking: 5

Oracle

Oracle again proved that it is a very mature product. Of the three, Oracle is the only one that can NOT be installed without admin rights. It would be nice for this to be an option.

It did, however, install easily. I received no errors. Oracle was the only install to point me towards the next step at the end of the install. This is a sure fire method to support new users and requires almost no effort. All databases should provide this kind of support.

Where Oracle really took a hit was in the amount of time it took to install. This is a real issue for home users. There were a couple of spots where I thought the machine might be hung as I received no feedback for an extended amount of time.

Oracle Installation Ranking: 7

Ease of Verifying Successful Installation

To verify the success of the install was a little different, but all three provide data access tools. I followed the instructions in the provided documentation and was able to access the server in all three instances.

Verification Ranking for all 3: 10

Creation of Non-Admin User:

PostgreSQL: PostgreSQL uses the standard CREATE USER syntax and I was able to perform this task easily. The documentation walks the user through this task (which is required for security reasons).

PostgreSQL Create User Ranking: 10

MySQL: In v5, MySQL also uses the CREATE USER syntax. Prior releases did not. Due to the fact that the documentation is not yet complete; it is not completely obvious that CREATE USER is available. For a new user, this can be confusing.

MySQL Create User Ranking: 7

Oracle: Oracle uses the standard CREATE USER syntax and I was able to perform this task easily. The documentation walks the user through this task. Oracle Create User Ranking: 10

Time to Run First Query

All three database documentation sets provide a tutorial for getting connected and running your first query.

All three First Query Ranking: 10

Resource Requirements:

PostgreSQL – I was amazed at PostgreSQL's minimal need for resources. I performed some tests like opening web browsers and MS-Word while connecting remotely and could see no impact at all on my test machine.

I couldn't find the minimum hardware specs, but 256Meg on an old machine seems to be more than enough.

PostgreSQL Resource Ranking: 10

MySQL – MySQL's minimal need for resources is well known. That is one of its biggest selling points and always has been. I performed the same test that I preformed for PostgreSQL and MySQL performed as well as PostgreSQL.

Oddly enough, I couldn't find the minimum hardware specs for MySQL either, but 256Meg on an old machine seems to be more than enough.

MySQL Resource Ranking: 10

Oracle - Oracle uses the most memory, and Oracle 10g uses even more than previous versions. It really would run better on a 512M machine, and I would recommend 1gig.

On the test box, it takes forever (well, many long minutes) for Oracle to even start up. When I opened Word, I started getting swapping and stalling. With multiple remote connections, the database came to a standstill. Oracle will install and run in 256 Megs, but I don't recommend it.

Oracle Resource Ranking: 3

So how does each stack up? Here are the final rankings:

PostgreSQL: 55

MySQL: 50

Oracle: 50

So, that is the install and first use ranking. That is not at all what my expectations were. I think it's great that all three rated so high. I was not expecting that or that Oracle and MySQL would tie. I was definitely not expecting PostgreSQL to come in first.

 如果您对本文有任何疑问或者建议，请到讨论区发表您的意见: >> 论坛入口 <<