PostgreSQL is more popular than MySQL

#1

Post by huntermeyer » Thu, Oct 23, 2014, 1:14 PM UTC

PostgreSQL is more popular than MySQL
databasefriends.co

Re: PostgreSQL is more popular than MySQL

#2

Post by ddorian43 » Thu, Oct 23, 2014, 1:37 PM UTC

I think users of postgresql are usually more experienced, care about features and complete polls than users of mysql who probably don't user foreign-key constraints.

Re: PostgreSQL is more popular than MySQL

#3

Post by jonifico » Thu, Oct 23, 2014, 1:38 PM UTC

How come I'm not surprised? At all.

Re: PostgreSQL is more popular than MySQL

#4

Post by 67726e » Thu, Oct 23, 2014, 1:38 PM UTC

Well, I'm sure on a site about RDBMSes, you're gonna get some skewed results. In the wild, MySQL sees higher use than PostgreSQL. That said, as an old coworker would say, MySQL is the PHP of RDBMSes. Ubiquitous, gets the job done, and works well mostly. Of course it does horrendous comparisons, conversions, and mutilations of data. Exactly the thing a database should not do.

Re: PostgreSQL is more popular than MySQL

#5

Post by davidw » Thu, Oct 23, 2014, 1:40 PM UTC

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.

Re: PostgreSQL is more popular than MySQL

#6

Post by carsongross » Thu, Oct 23, 2014, 1:41 PM UTC

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

Re: PostgreSQL is more popular than MySQL

#7

Post by jasode » Thu, Oct 23, 2014, 1:46 PM UTC

This is a survey asking "what's your favorite?"

"favorite" != "popular"

I don't think the editorializing in the title is an accurate summary of the survey's results.

Re: PostgreSQL is more popular than MySQL

#8

Post by blumkvist » Thu, Oct 23, 2014, 1:50 PM UTC

jonifico wrote: post #3

How come I'm not surprised? At all.

Because it's an extremely inaccurate title, based on an extremely biased survey?

Re: PostgreSQL is more popular than MySQL

#9

Post by gtCameron » Thu, Oct 23, 2014, 1:52 PM UTC

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.

The feature you are looking for is replication, I have used that in MySQL many times to do the exact thing you are talking about, works great.

Example - http://blog.onetechnical.com/2012/05/29/quick-mysql-replicat...

Re: PostgreSQL is more popular than MySQL

#10

Post by drsintoma » Thu, Oct 23, 2014, 1:52 PM UTC

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.