Create A WebSite

Which databaseÂ? you shouldÂ? consider whenÂ? build a website?

Now the most popular database for website is mysql because of its consistent fast performance,high reliability and ease of use.It’s used in more than 10 million installations ranging from large corporations to specialized embedded applications on every continent in the world.MySQL can run on more than 20 platforms including Windows, Linux,Â? OS/X, HP-UX, AIX, Netware,etc.

PostgreSQL :2006 Linux Journal Editors’ Choice Awards for Best Database

PostgreSQL is another open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others

If you need a large weisite and have some budget , SQL ServerÂ? is your another choice.

SQL Server( latest version is SQL Server 2005) is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools.The SQL Server database engine provides more secure, reliable storage for a relational database format or XML.

Benchmarks

MySQL 4.0Â? VS Oracle9i

SQL Server 2000 VS MySQL version 4.1

The SQL Server 2000 advantages:

• SQL Server 2000 holds the top TPC-C performance and price/performance results.
• SQL Server 2000 is generally accepted as easier to install, use and manage.
• Transact-SQL is more powerful language than MySQL dialect.

The MySQL version 4.1 advantages:

• MySQL version 4.1 supports all known platforms, not only the Windows-based platforms.
• MySQL version 4.1 requires less hardware resources.
• You can use MySQL version 4.1 without any payment under the terms of the GNU General Public License.

Benchmark Results For Postgresql, Mysql, Firebird(Done by Mark)