为什么在Web开发中经常使用MySQL?

时间:2022-09-16 11:18:03

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

我经常想知道为什么MySQL变得如此受欢迎。有什么想法吗?它成功背后的具体原因是什么? (请保持答案分析)

6 个解决方案

#1


12  

  1. It is free, which means it sees more use on personal projects as well as on hosting platforms that provide a DMBS solution.
  2. 它是免费的,这意味着它可以在个人项目以及提供DMBS解决方案的托管平台上看到更多用途。
  3. It is one of the few solutions that can run on almost any operating system.
  4. 它是几乎可以在几乎任何操作系统上运行的少数解决方案之一。
  5. It uses basic SQL rather than a specialized variant, meaning that it requires less-specialized knowledge to use.
  6. 它使用基本的SQL而不是专用的变体,这意味着它需要使用较少的专业知识。
  7. Setup and configuration is more straight-forward and less time-consuming than most other options.
  8. 与大多数其他选项相比,设置和配置更简单,耗时更少。

#2


1  

added more spices, is pretty fast for myisam

添加更多香料,对于myisam来说非常快

for what is meant free

什么意思是免费的

if you using oracle, and you want to setup multiple instances on different boxes, you probably required to pay for each boxes.

如果你使用oracle,并且你想在不同的盒子上设置多个实例,你可能需要为每个盒子付费。

unless, you have big budget to spent, oracle just don't sounds great

除非,你有很大的预算花费,oracle只是听起来不太好

postgres is also free

postgres也是免费的

mysql is easier to learn due to it's friendly sql (not standard compliance)

由于它的友好sql(不符合标准),mysql更容易学习

#3


1  

Early support in languages like PHP had a bit to do with it as well. While MySQL's C API is relatively straight forward (provided you are comfortable managing your callbacks), the PHP implementation made it crazy easy to use. Some would argue too easy to use.

像PHP这样的语言的早期支持也与它有点关系。虽然MySQL的C API相对简单(假设您可以轻松管理回调),但PHP实现使其易于使用。有些人认为太容易使用了。

I've worked in the hosting industry for quite a while, and notice trends. Almost as soon as PHP added support for SQLite3, people started asking for it to be installed. I'm not saying that PHP is the only contributing factor, nor can I guess at just how much of a factor it was, but it did have a bit to do with it.

我已经在托管行业工作了一段时间,并注意到趋势。几乎只要PHP添加了对SQLite3的支持,人们就开始要求安装它。我并不是说PHP是唯一的因素,我也不能猜测它是多少因素,但它确实与它有一点关系。

After all, they call it LAMP for a reason.

毕竟,他们称之为LAMP是有原因的。

#4


0  

It's opensouce and free (Community Edition).

它是开放和免费的(社区版)。

#5


0  

Ubiquity, cost and performance.

无处不在,成本和性能。

#6


0  

  1. Open Source - free of Cost [GNU license] - It is one among LAMP Linux, Apache, MySQL and PHP. So Its is suited with develop websites in PHP., etc.

    开源 - 免费使用[GNU许可证] - 它是LAMP Linux,Apache,MySQL和PHP之一。所以它适合用PHP开发网站等。

  2. Light Weight - Usually in Web development the space is an important issue,MySQL occupies less memory as compared to others so it is considered to be light weight.

    轻量级 - 通常在Web开发中,空间是一个重要问题,与其他人相比,MySQL占用的内存较少,因此被认为是轻量级的。

  3. While there is fight between gaints like Oracle vs SQL Server on Enterprise application, the MySql focused on the WEB Development and made popular.

    虽然企业应用程序上的Oracle与SQL Server之间存在争议,但MySql专注于WEB开发并且受到欢迎。

  4. ...

    ...

#1


12  

  1. It is free, which means it sees more use on personal projects as well as on hosting platforms that provide a DMBS solution.
  2. 它是免费的,这意味着它可以在个人项目以及提供DMBS解决方案的托管平台上看到更多用途。
  3. It is one of the few solutions that can run on almost any operating system.
  4. 它是几乎可以在几乎任何操作系统上运行的少数解决方案之一。
  5. It uses basic SQL rather than a specialized variant, meaning that it requires less-specialized knowledge to use.
  6. 它使用基本的SQL而不是专用的变体,这意味着它需要使用较少的专业知识。
  7. Setup and configuration is more straight-forward and less time-consuming than most other options.
  8. 与大多数其他选项相比,设置和配置更简单,耗时更少。

#2


1  

added more spices, is pretty fast for myisam

添加更多香料,对于myisam来说非常快

for what is meant free

什么意思是免费的

if you using oracle, and you want to setup multiple instances on different boxes, you probably required to pay for each boxes.

如果你使用oracle,并且你想在不同的盒子上设置多个实例,你可能需要为每个盒子付费。

unless, you have big budget to spent, oracle just don't sounds great

除非,你有很大的预算花费,oracle只是听起来不太好

postgres is also free

postgres也是免费的

mysql is easier to learn due to it's friendly sql (not standard compliance)

由于它的友好sql(不符合标准),mysql更容易学习

#3


1  

Early support in languages like PHP had a bit to do with it as well. While MySQL's C API is relatively straight forward (provided you are comfortable managing your callbacks), the PHP implementation made it crazy easy to use. Some would argue too easy to use.

像PHP这样的语言的早期支持也与它有点关系。虽然MySQL的C API相对简单(假设您可以轻松管理回调),但PHP实现使其易于使用。有些人认为太容易使用了。

I've worked in the hosting industry for quite a while, and notice trends. Almost as soon as PHP added support for SQLite3, people started asking for it to be installed. I'm not saying that PHP is the only contributing factor, nor can I guess at just how much of a factor it was, but it did have a bit to do with it.

我已经在托管行业工作了一段时间,并注意到趋势。几乎只要PHP添加了对SQLite3的支持,人们就开始要求安装它。我并不是说PHP是唯一的因素,我也不能猜测它是多少因素,但它确实与它有一点关系。

After all, they call it LAMP for a reason.

毕竟,他们称之为LAMP是有原因的。

#4


0  

It's opensouce and free (Community Edition).

它是开放和免费的(社区版)。

#5


0  

Ubiquity, cost and performance.

无处不在,成本和性能。

#6


0  

  1. Open Source - free of Cost [GNU license] - It is one among LAMP Linux, Apache, MySQL and PHP. So Its is suited with develop websites in PHP., etc.

    开源 - 免费使用[GNU许可证] - 它是LAMP Linux,Apache,MySQL和PHP之一。所以它适合用PHP开发网站等。

  2. Light Weight - Usually in Web development the space is an important issue,MySQL occupies less memory as compared to others so it is considered to be light weight.

    轻量级 - 通常在Web开发中,空间是一个重要问题,与其他人相比,MySQL占用的内存较少,因此被认为是轻量级的。

  3. While there is fight between gaints like Oracle vs SQL Server on Enterprise application, the MySql focused on the WEB Development and made popular.

    虽然企业应用程序上的Oracle与SQL Server之间存在争议,但MySql专注于WEB开发并且受到欢迎。

  4. ...

    ...