MySQL vs PostgreSQL in the context of celebrating the New Year
Not for the sake of holy war, but for fun, I want to tell, habralude, this story. On the eve of the celebration of the New Year on behalf of my office , I distributed personal licenses for ER designers: PgMDD and MyMDD (for PostgreSQL and MySQL, respectively). In my opus, I want to reveal some statistical aspects, and to share conclusions drawn from your requests, friends.
I will not disclose exact figures on the number of licenses given, but I will only say that the planned 8 billion was barely enough for the needs of those who ask. And this is taking into account the official (official?) ~ 7 billion of the world's population. In my opinion, the Chinese do not agree on something.
Your attention is a statistical "bubble", it is a torus. By the way, it was made with the help of a smart online tool , which I found quite by accident.
')
I don’t know how to evaluate the result of 63% for MySQL versus 36% for PostgreSQL. I suggest you to make far-reaching conclusions to you, habrazhitel, in the comments. I personally believe that the “Wishing Postgres” caste got drunk before their brothers in mind couldn’t ask for a gift. Let me remind you that the case was December 30 at the height of the fierce corporate parties, of which the author of these lines also became a victim.
It is worth paying attention to one interesting fact. Hardly anyone is surprised that we were intently reading letters from people with mailboxes different from gmail.com and mail.ru, and more specifically from people with corporate mailboxes.
So if students and web freelancers prevail in requests for a designer for MySQL, then corporate people are asked for postgres, and there are a lot of them. We saw nothing surprising in the fact that PostgreSQL is seriously considered an alternative to Oracle, at least for new projects. In this regard, I confess, I was surprised by the fact that no one asked for support from EnterpriseDB , the designer of the DBMS, which aggressively positions itself as “PostgreSQL compatible with Oracle” (Built upon PostgreSQL ... offers deeper Oracle® compatibility).
Let's talk about people. Our people have always been famous for simplicity, open heart. And this time he did not let him doubt his qualities. Every fourth of the gifted asked both designers at once. Some, though in natural modesty, sent two letters at different times, which added to us anal pain, but not critical.
We can also share approximate data on the “layers” of the population:
This is a very rough estimate, but still.
From amusing (read “to no one needed”) facts, I want to give statistics on popular names:
Based on the results, one thing can be said with certainty - the Chinese skillfully mimic.
We were not surprised by the fact that the hegemon in the field of postal services today is none other than Google. The share of people with boxes from the “corporation of good” was 58.7% percent. The closest competitors of Yandex and Mail.ru have a share of 7.2% each. There were many people who chose to provide us with their corporate mailboxes for registration. But in general, the Google Mail is walking around the planet.
By the way, the burden of registration and processing fell on the shoulders of two fragile girls. They made a great manual work. They even wrote to all the owners of all the servers that sent us nonsense like this:
or such:
There were no answers, draw conclusions about the services. We understand GMail, which can shove a message into spam, but stupidly not to accept it - in our opinion it’s just overkill.
Feedback from you began to flow right there. What pleased - as developers, and grieved - as people born in the USSR. I had to literally pull myself out of the festive table like the notorious Baron Munchausen. And urgently check, prepare and respond. By the undoubted victory of Habr in the affairs of the bugfix, it is worth noting the beta released hot on the heels of the PostgreSQL designer. And the most amazing thing is that this beta was aimed at fixing problems with Wine.
Wins and accomplishments to you in the new year, friends!
I did not include a designer for MsSQL in this statistic, since it is in a state of being. “Prebeta” is such a euphemism among us, you can safely use it - the monitor will not explode. There is simply no documentation yet and still there are small shoals for which reports licenses are readily given after the release of the combat release. Well, you know how it is.
Popularity
I will not disclose exact figures on the number of licenses given, but I will only say that the planned 8 billion was barely enough for the needs of those who ask. And this is taking into account the official (official?) ~ 7 billion of the world's population. In my opinion, the Chinese do not agree on something.
Your attention is a statistical "bubble", it is a torus. By the way, it was made with the help of a smart online tool , which I found quite by accident.
')
I don’t know how to evaluate the result of 63% for MySQL versus 36% for PostgreSQL. I suggest you to make far-reaching conclusions to you, habrazhitel, in the comments. I personally believe that the “Wishing Postgres” caste got drunk before their brothers in mind couldn’t ask for a gift. Let me remind you that the case was December 30 at the height of the fierce corporate parties, of which the author of these lines also became a victim.
Castes
It is worth paying attention to one interesting fact. Hardly anyone is surprised that we were intently reading letters from people with mailboxes different from gmail.com and mail.ru, and more specifically from people with corporate mailboxes.
So if students and web freelancers prevail in requests for a designer for MySQL, then corporate people are asked for postgres, and there are a lot of them. We saw nothing surprising in the fact that PostgreSQL is seriously considered an alternative to Oracle, at least for new projects. In this regard, I confess, I was surprised by the fact that no one asked for support from EnterpriseDB , the designer of the DBMS, which aggressively positions itself as “PostgreSQL compatible with Oracle” (Built upon PostgreSQL ... offers deeper Oracle® compatibility).
Population
Let's talk about people. Our people have always been famous for simplicity, open heart. And this time he did not let him doubt his qualities. Every fourth of the gifted asked both designers at once. Some, though in natural modesty, sent two letters at different times, which added to us anal pain, but not critical.
We can also share approximate data on the “layers” of the population:
- 80% - students and teachers (to study),
- 5% - freelancers (earn),
- 3% - state institutions
- 2% - girls (judging by the names).
This is a very rough estimate, but still.
From amusing (read “to no one needed”) facts, I want to give statistics on popular names:
- 7.3% - Alexander
- 7.2% - Dmitry
- 6.5% - Sergey
- 5.7% - Alexey
- 5.2% - Andrey
- 3.8% - Eugene
- 2.9% - Michael
- 2.9% - Maxim
- 2.8% - Anton
- 2.7% - Pavel
- 2.7% - Vladimir.
Based on the results, one thing can be said with certainty - the Chinese skillfully mimic.
post office
We were not surprised by the fact that the hegemon in the field of postal services today is none other than Google. The share of people with boxes from the “corporation of good” was 58.7% percent. The closest competitors of Yandex and Mail.ru have a share of 7.2% each. There were many people who chose to provide us with their corporate mailboxes for registration. But in general, the Google Mail is walking around the planet.
By the way, the burden of registration and processing fell on the shoulders of two fragile girls. They made a great manual work. They even wrote to all the owners of all the servers that sent us nonsense like this:
host mxs.majordomo.ru [78.108.81.249]: 550-host 80.73.171.170 is listed in rbl.majordomo.ru, use:
550 htt://majordomo.ru/rbl for remove IPor such:
host imx2.rambler.ru [81.19.88.6]: 554 5.7.1 Spam message rejected; If this is not spam contact abuse at rambler-co.ruThere were no answers, draw conclusions about the services. We understand GMail, which can shove a message into spam, but stupidly not to accept it - in our opinion it’s just overkill.
Feedback
Feedback from you began to flow right there. What pleased - as developers, and grieved - as people born in the USSR. I had to literally pull myself out of the festive table like the notorious Baron Munchausen. And urgently check, prepare and respond. By the undoubted victory of Habr in the affairs of the bugfix, it is worth noting the beta released hot on the heels of the PostgreSQL designer. And the most amazing thing is that this beta was aimed at fixing problems with Wine.
Instead of conclusion
Wins and accomplishments to you in the new year, friends!
PS
I did not include a designer for MsSQL in this statistic, since it is in a state of being. “Prebeta” is such a euphemism among us, you can safely use it - the monitor will not explode. There is simply no documentation yet and still there are small shoals for which reports licenses are readily given after the release of the combat release. Well, you know how it is.
Source: https://habr.com/ru/post/80642/
All Articles