3 ms·

> It’s the assumed default It is now, but before it had that privilege, MySQL did. The hype he is referring to may have taken the crown off MySQL and given it

> It’s the assumed default It is now, but before it had that privilege, MySQL did. The hype he is referring to may have taken the crown off MySQL and given it to PostGres. But make no mistake....postgres is not water. How do i know? Because it, too, will one day be unseated. And water does not lose its crown.

smt88 6y ago
I think Postgres is popular because of its emphasis on being explicit, strict, and correct. We're seeing the same thing in programming language adoption, where TypeScript is exploding in popularity and seemingly every language is getting static types if it didn't already have them. To me, the rise of Postgres (and its spiritual siblings, languages with expressive, static type systems) are about maturing of the industry rather than hype.
- joshxyz 6y ago
  > I think Postgres is popular because of its emphasis on being explicit, strict, and correct. And good documentation. Very good documentation.
7thaccount 6y ago
I think you have to look at it less as Postgres and more as SQL vs NoSQL. SQL has been the default for eons, (although I still use a 70s era heirarchy based database on a daily basis), but that is another story. My company has dozens of large production scale databases and I think only one or two NoSQL products. We don't use Postgres unfortunately though. NoSQL went through a hype in some circles (stayed non-existent in mine for the most part), but in my eyes, SQL has always been the work horse and was never not the default in the greater industry in my eyes. The Postgres implementation has become pretty popular recently, but so has Oracle and others in the past. I think the commenter was getting at this.
- TedDoesntTalk 6y ago
  > 70s era heirarchy based database on a daily basis Your file system perhaps?
  - 7thaccount 6y ago
    No haha, a real database as part of a major product. It's cool in a way, but very frustrating compared to SQL. I guess the closest thing people probably could compare it to is the MUMPS running in hospitals.

smt88 6y ago

I think Postgres is popular because of its emphasis on being explicit, strict, and correct. We're seeing the same thing in programming language adoption, where TypeScript is exploding in popularity and seemingly every language is getting static types if it didn't already have them. To me, the rise of Postgres (and its spiritual siblings, languages with expressive, static type systems) are about maturing of the industry rather than hype.

joshxyz 6y ago
> I think Postgres is popular because of its emphasis on being explicit, strict, and correct. And good documentation. Very good documentation.

7thaccount 6y ago

I think you have to look at it less as Postgres and more as SQL vs NoSQL. SQL has been the default for eons, (although I still use a 70s era heirarchy based database on a daily basis), but that is another story. My company has dozens of large production scale databases and I think only one or two NoSQL products. We don't use Postgres unfortunately though. NoSQL went through a hype in some circles (stayed non-existent in mine for the most part), but in my eyes, SQL has always been the work horse and was never not the default in the greater industry in my eyes. The Postgres implementation has become pretty popular recently, but so has Oracle and others in the past. I think the commenter was getting at this.

TedDoesntTalk 6y ago
> 70s era heirarchy based database on a daily basis Your file system perhaps?
- 7thaccount 6y ago
  No haha, a real database as part of a major product. It's cool in a way, but very frustrating compared to SQL. I guess the closest thing people probably could compare it to is the MUMPS running in hospitals.