Quote:
Originally posted by Backov
As for this DB war going on here, I'll contribute my two cents:
In my experience, Oracle is overkill for almost every project. Not to mention its ridiculous licensing prices and horrendously complicated setup. (I've never seen a db system before or since where we actually had to hire someone just to get the damn thing running.)
SQL Server is a nice DB. It's simple to setup, reliable and high capacity. It may not be as high capacity as Oracle, but few people would ever need more than SQL Server can handle.
MySQL is great, when it isn't crashing, as it does quite often.
PostGres - No idea there, was thinking about trying it but the reputation it has of being slow as molasses put me off.
Cheers,
Backov
|
Oracle is overkill for small projects, I admit. However, for the larger projects (and the project in question according to the thread-starter is HUGE) Oracle is simply the best option. Fast, safe, stable - it can't get much better than that.
SQL Server may be one of microsoft's better products, but it still has serious issues. For one, it follows one of the major microsoft traditions - not complying with standards. Security isn't the best in the world either, following another microsoft tradition.
Besides that, the quality doesn't justify the price. Things you can do with SQL Server can for the most part also be done with MySQL or PostgreSQL.
MySQL is fairly good, and pretty damn quick. Unfortunately, it's rather simple and at times unstable (although that is most often not caused by MySQL itself but by the people handling it the wrong way).
PostgreSQL is more stable than MySQL, more secure as well, and in my experience just as fast as SQL Server at much lower costs - that is, it's free.
So, if you really need the best database available, you should go for Oracle, if not, PostgreSQL. There is no reason to spend money on the MS SQL Server.