1998 if i recall correctly...
When did Postgres become cool?
121–130 of 182 posts
Re: When did Postgres become cool?
#122What IS "cool"?
It's that moment just before something becomes uncool, lol.
Software developers are glorified teenagers. Once something goes from upstart to widely used, developers get bored with it or else frustrated with the issues that arise from actual professional use. Then they go looking for the next fashionable upstart.
Oddly, I feel like PostgreSQL is on it's second cycle through this loop now.
Re: When did Postgres become cool?
#123The only correct answer to this question is 2012-09-10, the PostgreSQL 9.2 release date. In that release they unveiled JSON datatypes, and developers were able to have their cake and eat it too.
https://www.postgresql.org/about/news/postgresql-92-released...
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...
Re: When did Postgres become cool?
#124If you were paying attention, postgres always the better option, based on my experience starting around 2002 or so. MySQL had the better marketing in its name and was arguably a bit easier to get going from the start, but postgres was always more advanced and IMHO once you got past the most basic usage made a lot more sense in how it's configured. The fact that it was the M in the LAMP stack gave it a huge edge too.…
In the early 2000s, MySQL was: - way easier to install - way easier to maintain (not vacuuming, etc) - and had a replication story. So you had startups which created their MVP on some shared webhost, which had MySQL and nearly non had pg. as those startups graduated into enterprise fame, they never left MySQL but instead fixed its problems along the way.
Yeah, and MySQL was popular among PHP developers, remember LAMP installers?
Re: When did Postgres become cool?
#125I'll argue that it was Heroku that made Postgres popular. It was easy and simple to get set up, and it pretty much just worked. It was the first time I'd used it, and the first place many of my friends and coworkers had used it. Heroku was "mediatemple for apps built in the 2010s" and Postgres being the default (and really only sql option outside the marketplace) was a huge win for Postgres.
Edit: I also think emoji becoming popular was a huge win for Postgres. Emoji didn't work in MySQL because "utf8" wasn't actually UTF-8 and "utf8mb4" made indexes super limited for dumb reasons. As people started realizing this, it hurt MySQL's reputation pretty badly and a lot of folks avoided it for new projects.
Re: When did Postgres become cool?
#126If you were paying attention, postgres always the better option, based on my experience starting around 2002 or so. MySQL had the better marketing in its name and was arguably a bit easier to get going from the start, but postgres was always more advanced and IMHO once you got past the most basic usage made a lot more sense in how it's configured. The fact that it was the M in the LAMP stack gave it a huge edge too.…
>postgres was always more advanced
I don’t agree. WAL/replication was complete junk for a long time. Not to mention needing stuff like pgpool and pgbouncer in more complicated deployments.
Re: When did Postgres become cool?
#127I'll argue that it was Heroku that made Postgres popular. It was easy and simple to get set up, and it pretty much just worked. It was the first time I'd used it, and the first place many of my friends and coworkers had used it. Heroku was "mediatemple for apps built in the 2010s" and Postgres being the default (and really only sql option outside the marketplace) was a huge win for Postgres. Edit: I also think emoji…
Why care that utf8 isn't utfmb4? Just use the defaults and you will get utfmb4.
Re: When did Postgres become cool?
#128Nobody seems to have mentioned the MySQL licensing kerfuffle that got it pulled from most main stream Linux distros. For some of us this was the nail in MySQL coffin at a time when Postgres was becomming easier to manage.
Re: When did Postgres become cool?
#129If you were paying attention, postgres always the better option, based on my experience starting around 2002 or so. MySQL had the better marketing in its name and was arguably a bit easier to get going from the start, but postgres was always more advanced and IMHO once you got past the most basic usage made a lot more sense in how it's configured. The fact that it was the M in the LAMP stack gave it a huge edge too.…
In the early 2000s, MySQL was: - way easier to install - way easier to maintain (not vacuuming, etc) - and had a replication story. So you had startups which created their MVP on some shared webhost, which had MySQL and nearly non had pg. as those startups graduated into enterprise fame, they never left MySQL but instead fixed its problems along the way.
The mysql replication story was the big thing for me in the early/mid 2000s. Back then postgres replication seemed like every option was a brittle/incomplete 3rd party hack with different sets of tradeoffs.
Postgres also had a reputation for being correct but slower. The perf differential disappeared a) as postgres got faster and b) mysql got more reliable/robust.
Re: When did Postgres become cool?
#130I'll argue that it was Heroku that made Postgres popular. It was easy and simple to get set up, and it pretty much just worked. It was the first time I'd used it, and the first place many of my friends and coworkers had used it. Heroku was "mediatemple for apps built in the 2010s" and Postgres being the default (and really only sql option outside the marketplace) was a huge win for Postgres. Edit: I also think emoji…
Why care that utf8 isn't utfmb4? Just use the defaults and you will get utfmb4.
For some time specifying utf8 got you utf8mb3 rather than uft8mb4.
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8...