MySQL

MySQL is without doubt one of the most powerful and most used database management technology. Anyone who is familiar with PHP coding would have written some MySQL queries. One of the best thing with MySQL is that it is an open-source product therefore, it was adopted and utilized through many programming languages. Since Mysql is extensible , it integrates easily to any web-based technology. MySql has very good performance and it does not require complex queries to extract or add data. MyISAM is a great design within MySQL since it does not take lot of storage.

One of the cons of MySQL , is that it does not support large storage. MySQL lacks Tablespace, Role Management, synonym and much more. Contrary to Oracle, MySQL does not feature XML. One of the best thing with MySQL is its simplicity. You can easily export simple SQL files and migrate to another computer or server.

MySQL runs seamlessly under any operating system including Windows and UNIX-like systems. So if anyone who is not looking for large databases then MysQL is the best choice. MySQL is so popular for web development and PHP coding. MySQL supports ODBC under windows environment.There are many open-source alternatives like PostgreSQL, SQlite, MariaDB and much more.