Research Documentation 04 Mysql
04 Mysql
MySQL Documentation
The MySQL site is the home to everything you need to know about MySQL. The documentation page there has everything you need to set up MySQL and use it. The reference manual has information about installing, security, optimization, functions, data types, statements, and more. The sections go into detail about specific statements and what they do with examples on how to use them. The main documentation area also gives relaese notes for updates.
MySQL vs Other Databases
MySQL is a Relational Database Management System. There are other similar options for RDMS databases like MariaDB, Oracle, and PostgreSQL. Like these other databases, MySQL use the SQL query language. Like MariaDB and PostgreSQL, MySQL is an open source database which makes them free to use and download. Most of these other databases us a similar syntax as MySQL which makes it easier to go between different ones and know how to use them.
Usage of MySQL worldwide
MySQL is one of the most popular RDMS options out there. Because it is open source and free, it makes it more accessible for people to use. A Stack Overflow survey from 2020 found that MySQL is used by just over 50% of developers. PostgreSQL follows it at just over 40% in second place. MySQL also is easy to learn, which makes it more appealing. MySQL tends to rank right at the top with Oracle, which is a paid database system, but it is the top used free/open source database system. Even sites like Facebook and Twitter and platforms like WordPress use MySQL to manage their databases.
Summary
MySQL has been around a long time. Because it is open source and continually updated, it remains high in popularity. The ease of use also contributes to how much it is used. I've been using MySQL since the early 2000's to manage data on websites and it has always proven easy to work with and performed as I expected. Knowing that large sites like Facebook use it, shows that it is definitely a top choice for a great database system - even for large companies.