04 Mysql Home

MySQL

MySQL is the most popular open source relational database management system. Relational just means that data is stored in tables that are connected through some of that data. Recently, support has been added for other data types like JSON. Two features that people enjoy are atomicity, consistency, isolation, and durability (ACID) transactions, and its scalability.

Vs Other Databases

Since MySQL is open source, it's free, but since Oracle also owns it, it has the added benefit of more in-depth support than a purely open source database might have. It's also easier to learn than some of the other RDBMSs that I've used like MSSQL or PostgreSQL. However, it's not necessarily recommended to use it outside of some web applications. Compared to NoSQL databases, it can't store as many types of data, but that's the same for any SQL vs NoSQL database.

MySQL Usage

Over 135,000 companies use MySQL, the majority of which are from the United States, but collectively, the US contains a little less than half of the worldwide companies.

Summary

While MySQL seems like a good database to use, I still plan on connecting recommended databases with their respective languages, like MSSQL for C# for example. I would definitely use it for web applications though.