Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL is more popular than MySQL

databasefriends.co

Post reply on HN
Print view View original

11–20 of 51 posts

Re: PostgreSQL is more popular than MySQL

#12

Post by jasondc »

This survey (which seems more thorough) has MySQL ahead of Postgres: http://db-engines.com/en/ranking

Ranking methodology: http://db-engines.com/en/ranking_definition

Google trends also shows MySQL above Postgres in popularity: http://www.google.com/trends/explore#q=%2Fm%2F05ynw%2C%20mys...

Re: PostgreSQL is more popular than MySQL

#13

Post by davidw »

drsintoma wrote: post #10
davidw wrote: post #5

In preparation for a potential move back to the US, I've started idly browsing indeed.com for potential jobs. It's not a dealbreaker, but I have to admit to feeling a tiny bit disappointed when I see Mysql instead of Postgresql.

At work we are moving from Postgresql to MySQL, simply because for our current needs both will do just fine, and as of today, thanks to galera cluster, a high availability setup in MySQL is much easier to operate.

They've both continued to improve, a lot, but whenever I'm forced to use Mysql, there always seem to be lots of little annoying things that I run into that make me grumpy.

In any event, I'm positive Mysql is actually more widely used. But Fiats are more widely used than Ferraris, too.

Re: PostgreSQL is more popular than MySQL

#14

Post by vidarh »

carsongross wrote: post #6

The ability to spin up and sync a follower db, for eventual cut over... man I'd kill for that in MySQL.

Replication is an area where MySQL is still far ahead of Postgres. And I say that as someone who has almost exclusively used Postgres for the last 6 years or so. Postgres is finally starting to catch up, but it's taken forever.

Re: PostgreSQL is more popular than MySQL

#15

Post by drsintoma »

davidw wrote: post #13
drsintoma wrote: post #10

Earlier quoted context omitted.

At work we are moving from Postgresql to MySQL, simply because for our current needs both will do just fine, and as of today, thanks to galera cluster, a high availability setup in MySQL is much easier to operate.

They've both continued to improve, a lot, but whenever I'm forced to use Mysql, there always seem to be lots of little annoying things that I run into that make me grumpy. In any event, I'm positive Mysql is actually more widely used. But Fiats are more widely used than Ferraris, too.

Yes, I know your feeling. But sometimes you need to be pragmatic, specially when resources are limited, and in many use cases you can stick to the standard ORM functionality and forget about what's underneath.

Re: PostgreSQL is more popular than MySQL

#18

Post by Someone1234 »

nanoscopic wrote: post #16

Why are MySQL and MariaDB shown separately. For all intensive purposes they are the same.

I might have agreed with that when the two initially forked, however the gap continues to widen:

https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibi...

Re: PostgreSQL is more popular than MySQL

#19

Post by thehal84 »

I'll stick with MySQL, the features and stability just keep getting better. Replication, Memcache Plugin (with amazing write and read performance that supports replication), InnoDB Barracuda compression, JSON datatypes (in 5.7), it has scaled amazing well for us at Enginuity Search Engine. I should do a write up on our company blog sometime about all this.
Post reply on HN