Re:Postgres pushes past MySQL in developer hearts
by DigitalSea on Tuesday May 26, 2015 @01:39AM
(#9603114)
In my mind PostgreSQL has always been cool. I have never been one of those developers who choose the most popular option, I have been fighting hard on every project I get to have a say in database choice for years now to use PostgreSQL. I don't think it was ever not cool, a lack of mentions on social media and inclusions on LinkedIn isn't an adequate representation of popularity. I think PostgreSQL is one of those things that I would call a best kept secret, everyone knows it is superior to MySQL.
The article does make a few good points, but it seems to be largely speculative and lacking substance. If PostgreSQL is seeing an uptake, that's great because if any database solution out there deserves it, it is PostgreSQL. I love the JSON feature, but not only that being able to work with geospatial and location data out-of-the-box.
Re:Postgres pushes past MySQL in developer hearts
by anthony_franco on Tuesday May 26, 2015 @02:27AM
(#9603220)
The main thing holding me back from converting over to Postgres for my own projects (although I used it extensively at my previous jobs) is the lack of native multi-master support.
Granted, I haven't looked into it recently. What's the best way to setup multi-master replication on Postgres? Google shows various different options. I'm wondering what's the most commonly used method at this point.
Re:Postgres pushes past MySQL in developer hearts
by dennist on Tuesday May 26, 2015 @03:05AM
(#9603321)
I used MySQL until recently just because lots of people around me seemed to be using it. Over time I ran into too many issues with it (for example their default UTF-8 isn't actually UTF-8 but a subset that doesn't accept emoji for example), so I switched to Postgres and only then realised that suddenly everybody else around me seems to be using Postgres now. Definitely feels like there is a movement towards Postgres.
Re:Postgres pushes past MySQL in developer hearts
by jakejake on Tuesday May 26, 2015 @02:35AM
(#9603241)
Earlier today there was an article on the front page about a Postgres data corruption bug. I thought it was unusual to see a negative Postgres story here. I came back looking for it and it seems to have vanished and been replaced with this article.
Re:Postgres pushes past MySQL in developer hearts
by throwaway86543 on Tuesday May 26, 2015 @02:33AM
(#9603237)
This article is just another Matt Asay puff piece.
MySQL and Postgres are both great RDBMS choices with roughly the same number of features, though MySQL always has more replication options.
The factoids of interest in the article are that MySQL is the #2 database overall, and about to overtake Oracle at #1, and pg is growing in popularity in job listings.
The article does make a few good points, but it seems to be largely speculative and lacking substance. If PostgreSQL is seeing an uptake, that's great because if any database solution out there deserves it, it is PostgreSQL. I love the JSON feature, but not only that being able to work with geospatial and location data out-of-the-box.
Granted, I haven't looked into it recently. What's the best way to setup multi-master replication on Postgres? Google shows various different options. I'm wondering what's the most commonly used method at this point.
And PGPool has its own problems.
Here it is: https://news.ycombinator.com/item?id=9598211
MySQL and Postgres are both great RDBMS choices with roughly the same number of features, though MySQL always has more replication options.
The factoids of interest in the article are that MySQL is the #2 database overall, and about to overtake Oracle at #1, and pg is growing in popularity in job listings.