Hacker News Reader

Comment by mr_overalls | Hacker News Reader

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?

View on HN

At least on HN PostgreSQL is discussed 60% more than MySQL, but both are discussed positively:

https://hnprofile.com/compare?search=postgres,mysql

Reddit has PostgreSQL up by about 40% over MySQL:

https://redditprofile.com/compare?search=postgres,mysql

[1] https://imgur.com/a/COee2qz

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.

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.htm...

[2] https://trends.google.com/trends/explore?date=2012-01-01%202...

Another mentions-based trends site https://db-engines.com/en/ranking_trend that shows Postgres uptrend. Most surprising thing to me there is that MongoDB is still going up.

Is anyone using Mongo in a large volume production system?

Lots of major players are using it: https://www.mongodb.com/who-uses-mongodb

We use it for large volumes of machine learning features and it's been amazing.

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.

MongoDB has improved a lot in the last few years.

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.

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

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.

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.

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.

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

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

I find this hard to believe.

Have you tried hiring one lately? Oracle experience out the wazoo, but PostgreSQL experience is much harder to come by.

Maybe there's a reason that there's a surplus of Oracle DBAs and a shortage of Postgres DBAs.

I'm in uni and everything is Microsoft, Oracle and Cisco.

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.

IMX, universities are not influenced by companies as much as they are influenced by the inertia of established curriculum and limited interest from the professors to use a different tool that offers minimal benefits. Even if I'm teaching a class and using Oracle, I'm probably mostly teaching general relational databases where one is as good as any other. It's not the job of a conceptual RDBMS class to teach you the implementation details of arbitrary offerings; quite the opposite!

That's a shame, and increasingly out of touch.

Yeah, it pays way more.

If you're saying there are more Oracle DBAs because they are paid more, that's the opposite of the point I was making. Basic supply/demand economics would indicate that you'll have a surplus of something that is falling out of favor, and that surplus will be inexpensive. There would be many looking for jobs because it used to pay well when it was in demand and there was a shortage, not because they're making lots of money looking for jobs.

If you're having trouble finding decent Postgres DBAs to hire, it could be that other companies are snapping up all the good ones, and that you're not offering enough.

You're presenting anecdotes, I'm presenting anecdotes. Exciting stuff. Market shifts take quite a few years, so I'm sure there are still plenty of high paying Oracle DBA jobs, and I'm sure that there will probably always be some of those jobs to support legacy systems.

Totally agree. We're in NYC and so hard to find a very very good PostgreSQ DBA.

Find an Oracle DBA instead. The similarity is obvious, and PostgreSQL have less quirks.

> 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/

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.

Yes, the most of migrations to PostgreSQL is not from MySQL, but from Oracle.

Reply on news.ycombinator.com