MySQL

Popular programs in Internet

What is MySQL

MySQL is a popular open source database management system (RDBMS), used for adding, accessing, and processing data in a database. MySQL is most commonly used for Web applications and for embedded applications.

Features

MySQL is a relational database and a client/server system. Among its best features is its ability to work on many different platforms and its support for many data types. Supported platforms include Apple Macintosh OS X, Linux, Microsoft Windows, and the countless Unix variants.

Standard SQL (Structured Query Language) is the database language supported by MySQL. SQL is a standardized language for querying and updating data and for the administration of a database. Tables can be mixed from different databases in the same query.

MySQL is considered a very fast database program. This speed has been captured by a large number of benchmark tests.

Conclusion

One of the most popular languages, MySQL is free to download and use from the MySQL website. It can be tailored to your needs in accordance with the general public license. It is a privilege and password system that is very flexible and secure, and that allows host-based verification.

Brief History

MySQL was purchased by Sun Microsystems in 2008. Oracle purchased Sun Microsystems (including MySQL) in 2009 for $7.5 billion. It was still the most popular open source database as of 2013.

Pros

• Simple, fast, reliable and flexible
• Ideal for both small and large applications
• Open Source for anyone to use and modify
• Supported by an active, worldwide user community
• Ever increasing volume of users
• Greater MySQL investment and innovation than ever before
• A large volume of projects
• Designed with a focus on the Web, Cloud, and Big Data

Cons

• Not as mature as other RDMS and lacks certain features
• Community-driven yet Oracle owns the product and final say
• MySQL is mature and has increasing competition