Geek Answers Handbook

Why is MySQL used so often in web development?

I often wondered why MySQL has become so popular. Any ideas why? Are there any specific reasons for success? (Please keep the answers analytical)

+6
database mysql rdbms popularity
source share
6 answers
  • It's free, which means that it uses more both personal projects and hosting platforms that provide DMBS solution.
  • This is one of the few solutions that can work on almost any operating system .
  • It uses basic SQL rather than a specialized version, which means that less specialized knowledge is required to use it.
  • Customization and configuration are more straightforward and less time consuming than most other options.
+12
source share

more spices added, pretty quick for myisam

for a free word

if you are using oracle and you want to configure multiple instances in different blocks, you probably have to pay for each square.

if you don't have a big budget spent, oracle just doesn't sound great

postgres is also free

mysql is easier to learn due to its friendly sql (not standard matching)

+1
source share

Early support in languages ​​like PHP was also relevant. Although the MySQL C API is relatively straightforward (assuming convenient callback management), the PHP implementation made it crazy crazy to use. Some argue that they are too easy to use.

I worked in the hosting industry for a long time and noted trends. Almost immediately after adding PHP support for SQLite3, people started asking to install it. I'm not saying that PHP is the only factor that can help, and I can’t guess how much it was a factor, but it had something to do with it.

After all, they call it LAMP for some reason.

+1
source share

It opens and is released (Community Edition).

0
source share

Ubiquity, cost and performance.

0
source share

  • Open Source - Free [GNU License] - This is one of LAMP Linux, Apache, MySQL and PHP. Thus, it is suitable for website development in PHP. Etc.

  • A light weight. Usually in web development, space is an important issue, MySQL takes up less memory than others, and therefore is considered lightweight.

  • While there is a struggle between assets such as Oracle vs SQL Server on Enterprise, MySql has focused on WEB development and has become popular.

  • ...

0
source share

More articles:


All Articles