黄舟2017-04-17 11:09:22
I think, as a comment above said, the main thing is the lamp. Because I’m still a student, I don’t know much about the industrial environment, so let’s talk about the situation in school.
Although the teachers at school introduced both mysql and postgreSQL, there were too many articles introducing lamp (including graphic and text descriptions of various configurations, problem solutions, etc.). As far as I know, students had various problems configuring postgreSQL. If the search engine cannot find the results (mainly Chinese solutions) at once, a large part of them will turn to configure mysql.
In addition, xampp is such a famous tool and it is free, so it will definitely be favored by a large number of people.
Moreover, for beginners, when there is a problem, they often don’t really know the source of the problem. Many people encounter problems like this:
A: My postgreSQL configuration is unsuccessful, what should I do? Baidu can’t reach it!
B: Huh? Something went wrong? My mysql is fine! Let you toss and let you pretend. Change to mysql!
A: Hey, okay. Installation of X failed, so I changed to mysql.
A: Wow! The configuration is really successful, no problem!
Then, when there is no big difference between the two and there are no special needs, mysql becomes mainstream.
ringa_lee2017-04-17 11:09:22
Due to history, time is the greatest creator and has accumulated many users. Most users tend to use stability instead of being new and tired of the old.
ringa_lee2017-04-17 11:09:22
Because the company uses MySQL.
If the customer's demand is Oracle, then this must be done for him.
Because he gives money.
In other words, I think it would be better to try NoSQL. Of course, if you must save relationships, use PostgreSQL. But DBAs may prefer stable products because they have been tested, and the online documentation is relatively complete, so problems can be easily solved.
ringa_lee2017-04-17 11:09:22
1. Historical accumulation and many users
2. The company requires more stability and lower maintenance costs
3. What is taught in school is MySQL?
大家讲道理2017-04-17 11:09:22
It’s completely a matter of history. MySQL has too many accumulated users, and they are not willing to change; new users feel that what most people are using is definitely not wrong, so they follow suit. In fact, PostgreSQL's performance, ease of use, and stability are better than MySQL. As for PostgreSQL learning materials, there are actually quite a few. There is even a manual in Chinese called PostgreSQL 9.4.4 Chinese Manual. If you have any questions, you can ask for help from the PostgreSQL Chinese community. (However, there is a sequelae of learning PostgreSQL, that is, once you are familiar with PostgreSQL, you will despise MySQL, because these two databases are really not on the same level^_^)