Database solutions for web hosting accounts
Ups and downs of different database solutions commonly used for dynamic websites. Databases include MySQL, MS SQL and Microsoft Access.
The most dynamic and easily updateable websites are all driven by a database. This enables maximum flexibility and lowest possible maintenance because it completely separates content from presentation.
A widely used free database is MySQL. It is both efficient and powerful, and has many fans all over the world. Most common scripting languages can be used with it, but the combination PHP/MySQL is most popular. Because of this, PHP/MySQL-hosting is most common on Linux servers, and since Linux, MySQL and PHP are both free and very efficient(less strain on the server), PHP/MySQL hosting is cheap.there are plenty of MySQL-driven PHP scripts available for free on the internet, like discussion forums, directory scripts and shopping carts.
PHP/MySQL-hosting is most common on Linux servers, and since Linux, MySQL and PHP are both free and very efficient(less strain on the server), PHP/MySQL hosting is cheap.
MySql's little brother in the open source world in terms of popularity, but very comparable(if not better) in performance.
PostgreSql hosting is also most common on Linux/Unix servers, since the Windows version is "on the way". Can easily be used with programming languages such as Python, PHP and Java. Does not add any significant costs to your web hosting account, but availability as a bit limited.
Microsoft has its own version of SQL, called MS SQL. Like MySQL it is a powerful database solution, but only available on Windows servers. Widely used for commercial applications, but Windows/MS SQL hosting is more expensive than Linux/MySql hosting, and there are fewer online resources for MS SQL.
One more database from Microsoft, which is available in many cheap Windows hosting packages. It is said not to be as efficient and scalable as SQL databases, but price is its strength if you need Windows hosting.