6 ms·

Slightly off-topic, but: has PostgreSQL largely replaced MySQL for new projects? I'm seeing larger numbers of positions advertising for Postgres, even here in t

Slightly off-topic, but: has PostgreSQL largely replaced MySQL for new projects? I'm seeing larger numbers of positions advertising for Postgres, even here in the Midwest. Postgres seems so chock-full of features now - is there a reason to prefer MySQL? Easier replication?

nateguchi 8y ago
Yes, MySQL has more developed methods of replication. There are also some specific functionalities available in either MySQL or Postgres that you may pick based on your use case (geo, upsert, insert and replace). There's definite variation with feature parity and performance that makes either a better choice depending on use case.
jordanthoms 8y ago
Yeah I'm seeing postgres far more than MySQL, and even in larger businesses I've seen a lot moving from Oracle/SQL Server to PostgreSQL.
- paulryanrogers 8y ago
  EnterpriseDB offers some additional compatibility features in their flavor of Postgresql. It looked a lot easier than a move to MySQL.
meritt 8y ago
There's been a definite surge the past 4 years [1] however I think at least part of that is due to growth of extremely capable MySQL forks (MariaDB and Percona) [2]. [1] https://www.hntrends.com/2018/oct-react-holds-off-python.html?compare=MySQL&compare=Postgresql&compare=&compare= https://www.hntrends.com/2018/oct-react-holds-off-python.htm... [2] https://trends.google.com/trends/explore?date=2012-01-01%202018-11-28&geo=US&q=mariadb,percona https://trends.google.com/trends/explore?date=2012-01-01%202...
- mlinksva 8y ago
  Another mentions-based trends site https://db-engines.com/en/ranking_trend https://db-engines.com/en/ranking_trend that shows Postgres uptrend. Most surprising thing to me there is that MongoDB is still going up.
  - nateguchi 8y ago
    Is anyone using Mongo in a large volume production system?
    - threeseed 8y ago
      Lots of major players are using it: https://www.mongodb.com/who-uses-mongodb https://www.mongodb.com/who-uses-mongodb We use it for large volumes of machine learning features and it's been amazing.
      - dx034 8y ago
        Major players using it doesn't mean it's used for large-scale projects. I've seen several companies testing it but none of them uses it for any of their core production systems.
    - emmelaich 8y ago
      MongoDB has improved a lot in the last few years.
Thaxll 8y ago
Not really, reading HN / Reddit doesn't reflect of the real world. Most people I know use MySQL / Aurora.
diminoten 8y ago
I dunno, it's still pretty damn hard to find a DBA with relevant PostgreSQL experience on the east coast...
- ghotli 8y ago
  I find this hard to believe.
  - diminoten 8y ago
    Have you tried hiring one lately? Oracle experience out the wazoo, but PostgreSQL experience is much harder to come by.
    - coder543 8y ago
      Maybe there's a reason that there's a surplus of Oracle DBAs and a shortage of Postgres DBAs.
      - penagwin 8y ago
        I'm in uni and everything is Microsoft, Oracle and Cisco.
        coder543 8y ago
        Universities are often... influenced by big companies, and do not necessarily use technologies that are representative of what you'll see in the real world. They could be, by random chance, but it’s not necessarily the case. Anecdotally, I usually hear from people that it wasn’t representative when they are comparing what they learned in college to what they use in the workforce. It also really annoys me when universities teach their students expensive, proprietary software that they won't be able to use outside of class when there are competent and often superior free options. These students are paying good money to learn, and the universities are intentionally choosing to teach them something less than the most beneficial knowledge that those students could reasonably be learning about.
threeseed 8y ago
Most businesses are right now transitioning to the cloud. And so often they are moving to managed databases like Aurora, Redshift etc where things like replication are handled for you. Personally not seeing large scale move away from MySQL.
liftbigweights 8y ago
> Slightly off-topic, but: has PostgreSQL largely replaced MySQL for new projects? I'm seeing larger numbers of positions advertising for Postgres, even here in the Midwest. Perhaps, but I suspect people who are migrating from mysql are moving to mariadb, not postresql. > Postgres seems so chock-full of features now Now? PostgreSQL has always been more feature-rich ( especially compared to mysql ). What made mysql popular was it's lack of features ( simplicity ) and its tie-in with php/etc web development. Web developers loved mysql because it was simple and easier to manage because it was so feature poor. Give credit where it is due. MySQL really rode the web development momentum. But PostgreSQL has always been the more mature RDBMS. This is a basic features list ( maybe somewhat biased and somewhat dated ) but the overall trend still holds today. http://www.postgresqltutorial.com/postgresql-vs-mysql/ http://www.postgresqltutorial.com/postgresql-vs-mysql/
- MisterOctober 8y ago
  Postgres has really picked up steam with enterprise and institutional users in my neck of the woods also [southwestern US]. The emphasis on role-based security and, lately, the ability to handle JSON, geolocation data, etc [plus finally getting some overdue query features like ROLLUP] have made some folks who previously swore by SQL Server or Oracle take it more seriously as an option for inhouse systems. I see a fair number of local job postings that specify Postgres experience.
  - snaky 8y ago
    Yes, the most of migrations to PostgreSQL is not from MySQL, but from Oracle.
lettergram 8y ago
At least on HN PostgreSQL is discussed 60% more than MySQL, but both are discussed positively: https://hnprofile.com/compare?search=postgres,mysql https://hnprofile.com/compare?search=postgres,mysql Reddit has PostgreSQL up by about 40% over MySQL: https://redditprofile.com/compare?search=postgres,mysql https://redditprofile.com/compare?search=postgres,mysql [1] https://imgur.com/a/COee2qz https://imgur.com/a/COee2qz
paulddraper 8y ago
One small thing: AWS Aurora MySQL is lightyears ahead of AWS Aurora PostgreSQL. As an AWS and PostgreSQL user, I wish it were the other way around, but that is currently the unfortunate truth.
dano 8y ago
PostgreSQL has been in my toolbox since 2003 having proved itself as reliable, stable, always free, well tested, and with a vibrant community on IRC. freenode #postgresql The company I built in 2003 is still using PostgreSQL for all of its operating data, web services, APIs, and royalty calculations. Someone once said, and I agree, "PostgreSQL is the answer unless proven otherwise." If you've not tried PostgreSQL I encourage you to give it a whirl, I think you'll like it. I'll also say that #postgresql is really a friendly place for newbies and experts alike.

nateguchi 8y ago

Yes, MySQL has more developed methods of replication. There are also some specific functionalities available in either MySQL or Postgres that you may pick based on your use case (geo, upsert, insert and replace). There's definite variation with feature parity and performance that makes either a better choice depending on use case.

jordanthoms 8y ago

Yeah I'm seeing postgres far more than MySQL, and even in larger businesses I've seen a lot moving from Oracle/SQL Server to PostgreSQL.

paulryanrogers 8y ago
EnterpriseDB offers some additional compatibility features in their flavor of Postgresql. It looked a lot easier than a move to MySQL.

meritt 8y ago

There's been a definite surge the past 4 years [1] however I think at least part of that is due to growth of extremely capable MySQL forks (MariaDB and Percona) [2]. [1] https://www.hntrends.com/2018/oct-react-holds-off-python.html?compare=MySQL&compare=Postgresql&compare=&compare= https://www.hntrends.com/2018/oct-react-holds-off-python.htm... [2] https://trends.google.com/trends/explore?date=2012-01-01%202018-11-28&geo=US&q=mariadb,percona https://trends.google.com/trends/explore?date=2012-01-01%202...

mlinksva 8y ago
Another mentions-based trends site https://db-engines.com/en/ranking_trend https://db-engines.com/en/ranking_trend that shows Postgres uptrend. Most surprising thing to me there is that MongoDB is still going up.
- nateguchi 8y ago
  Is anyone using Mongo in a large volume production system?
  - threeseed 8y ago
    Lots of major players are using it: https://www.mongodb.com/who-uses-mongodb https://www.mongodb.com/who-uses-mongodb We use it for large volumes of machine learning features and it's been amazing.
    - dx034 8y ago
      Major players using it doesn't mean it's used for large-scale projects. I've seen several companies testing it but none of them uses it for any of their core production systems.
  - emmelaich 8y ago
    MongoDB has improved a lot in the last few years.

Thaxll 8y ago

Not really, reading HN / Reddit doesn't reflect of the real world. Most people I know use MySQL / Aurora.

diminoten 8y ago

I dunno, it's still pretty damn hard to find a DBA with relevant PostgreSQL experience on the east coast...

ghotli 8y ago
I find this hard to believe.
- diminoten 8y ago
  Have you tried hiring one lately? Oracle experience out the wazoo, but PostgreSQL experience is much harder to come by.
  - coder543 8y ago
    Maybe there's a reason that there's a surplus of Oracle DBAs and a shortage of Postgres DBAs.
    - penagwin 8y ago
      I'm in uni and everything is Microsoft, Oracle and Cisco.
      - coder543 8y ago
        Universities are often... influenced by big companies, and do not necessarily use technologies that are representative of what you'll see in the real world. They could be, by random chance, but it’s not necessarily the case. Anecdotally, I usually hear from people that it wasn’t representative when they are comparing what they learned in college to what they use in the workforce. It also really annoys me when universities teach their students expensive, proprietary software that they won't be able to use outside of class when there are competent and often superior free options. These students are paying good money to learn, and the universities are intentionally choosing to teach them something less than the most beneficial knowledge that those students could reasonably be learning about.

threeseed 8y ago

Most businesses are right now transitioning to the cloud. And so often they are moving to managed databases like Aurora, Redshift etc where things like replication are handled for you. Personally not seeing large scale move away from MySQL.

liftbigweights 8y ago

> Slightly off-topic, but: has PostgreSQL largely replaced MySQL for new projects? I'm seeing larger numbers of positions advertising for Postgres, even here in the Midwest. Perhaps, but I suspect people who are migrating from mysql are moving to mariadb, not postresql. > Postgres seems so chock-full of features now Now? PostgreSQL has always been more feature-rich ( especially compared to mysql ). What made mysql popular was it's lack of features ( simplicity ) and its tie-in with php/etc web development. Web developers loved mysql because it was simple and easier to manage because it was so feature poor. Give credit where it is due. MySQL really rode the web development momentum. But PostgreSQL has always been the more mature RDBMS. This is a basic features list ( maybe somewhat biased and somewhat dated ) but the overall trend still holds today. http://www.postgresqltutorial.com/postgresql-vs-mysql/ http://www.postgresqltutorial.com/postgresql-vs-mysql/

MisterOctober 8y ago
Postgres has really picked up steam with enterprise and institutional users in my neck of the woods also [southwestern US]. The emphasis on role-based security and, lately, the ability to handle JSON, geolocation data, etc [plus finally getting some overdue query features like ROLLUP] have made some folks who previously swore by SQL Server or Oracle take it more seriously as an option for inhouse systems. I see a fair number of local job postings that specify Postgres experience.
- snaky 8y ago
  Yes, the most of migrations to PostgreSQL is not from MySQL, but from Oracle.

lettergram 8y ago

At least on HN PostgreSQL is discussed 60% more than MySQL, but both are discussed positively: https://hnprofile.com/compare?search=postgres,mysql https://hnprofile.com/compare?search=postgres,mysql Reddit has PostgreSQL up by about 40% over MySQL: https://redditprofile.com/compare?search=postgres,mysql https://redditprofile.com/compare?search=postgres,mysql [1] https://imgur.com/a/COee2qz https://imgur.com/a/COee2qz

paulddraper 8y ago

One small thing: AWS Aurora MySQL is lightyears ahead of AWS Aurora PostgreSQL. As an AWS and PostgreSQL user, I wish it were the other way around, but that is currently the unfortunate truth.

dano 8y ago

PostgreSQL has been in my toolbox since 2003 having proved itself as reliable, stable, always free, well tested, and with a vibrant community on IRC. freenode #postgresql The company I built in 2003 is still using PostgreSQL for all of its operating data, web services, APIs, and royalty calculations. Someone once said, and I agree, "PostgreSQL is the answer unless proven otherwise." If you've not tried PostgreSQL I encourage you to give it a whirl, I think you'll like it. I'll also say that #postgresql is really a friendly place for newbies and experts alike.