5 ms·

A while ago I'd say! Last time I heard anyone seriously excited about NoSQL was several years ago. It still has its place, but it seems like Postgres is the hyp

A while ago I'd say! Last time I heard anyone seriously excited about NoSQL was several years ago. It still has its place, but it seems like Postgres is the hype these days.

symlinkk 6y ago
Weird to describe an open source relational database as “hype”. It’s the assumed default. It’s like describing water as “hype”.
- TedDoesntTalk 6y ago
  > 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.
- LukeShu 6y ago
  Fitting comparison; it's been weird watching the rise of reddit.com/r/HydroHomies . We live in weird times, if water can be "hype", so can PostgreSQL!
  - zikzak 6y ago
    I had to check. It's really a subreddit.
  - rubatuga 6y ago
    That subreddits name had an interesting history if you google it.
    - CameronNemo 6y ago
      https://knowyourmeme.com/memes/sites/water-niggas-hydro-homies https://knowyourmeme.com/memes/sites/water-niggas-hydro-homi...
  - CameronNemo 6y ago
    I always think of Heinlein's water brothers when I see that subreddit.
  - darkerside 6y ago
    It is fitting. Water is a miracle drug. And we take it for granted. Needs more hype!
random5634 6y ago
Yay - I dodged the noSQL hype! And agreed on postgresql (and sqllite if something small and simple needed without any overhead)
schoolornot 6y ago
I'm surprised Postgres has continued to be popular despite having multi-master or sharding support.
- zozbot234 6y ago
  Postgres supports table partitioning and foreign data wrappers (used for accessing remote SQL databases) which can be used to set up sharding as described in the postgres docs.
- markdown 6y ago
  > multi-master Wow, so oppressive. #DecoloniseSQL
- sitharus 6y ago
  Why? Very few products need sharding, let alone multi-master. Sure a popular social media platform would, but most development in the world is for small to medium scale line-of-business apps. Postgres is _fantastic_ for these.
  - plaur782 6y ago
    This is the key point we see - most applications just do not generate write traffic that is beyond what a recent release of Postgres can handle.
- speedgoose 6y ago
  It's because most developers don't need multi-primary databases, which have downsides too.
- sharadov 6y ago
  I manage a large sized Postgres farm with 100s of instances, and there has been one case where we need multi-master, and I went with Galera cluster for MariaDB. You can shard using the citus extension for Postgres.
  - plaur782 6y ago
petters 6y ago
The excitement about NoSQL at Google seems to have stopped with the introduction of Spanner, at least.

A while ago I'd say! Last time I heard anyone seriously excited about NoSQL was several years ago. It still has its place, but it seems like Postgres is the hype these days.

symlinkk 6y ago

Weird to describe an open source relational database as “hype”. It’s the assumed default. It’s like describing water as “hype”.

TedDoesntTalk 6y ago
> 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.
LukeShu 6y ago
Fitting comparison; it's been weird watching the rise of reddit.com/r/HydroHomies . We live in weird times, if water can be "hype", so can PostgreSQL!
- zikzak 6y ago
  I had to check. It's really a subreddit.
- rubatuga 6y ago
  That subreddits name had an interesting history if you google it.
  - CameronNemo 6y ago
    https://knowyourmeme.com/memes/sites/water-niggas-hydro-homies https://knowyourmeme.com/memes/sites/water-niggas-hydro-homi...
- CameronNemo 6y ago
  I always think of Heinlein's water brothers when I see that subreddit.
- darkerside 6y ago
  It is fitting. Water is a miracle drug. And we take it for granted. Needs more hype!

random5634 6y ago

Yay - I dodged the noSQL hype! And agreed on postgresql (and sqllite if something small and simple needed without any overhead)

schoolornot 6y ago

I'm surprised Postgres has continued to be popular despite having multi-master or sharding support.

zozbot234 6y ago
Postgres supports table partitioning and foreign data wrappers (used for accessing remote SQL databases) which can be used to set up sharding as described in the postgres docs.
markdown 6y ago
> multi-master Wow, so oppressive. #DecoloniseSQL
sitharus 6y ago
Why? Very few products need sharding, let alone multi-master. Sure a popular social media platform would, but most development in the world is for small to medium scale line-of-business apps. Postgres is _fantastic_ for these.
- plaur782 6y ago
  This is the key point we see - most applications just do not generate write traffic that is beyond what a recent release of Postgres can handle.
speedgoose 6y ago
It's because most developers don't need multi-primary databases, which have downsides too.
sharadov 6y ago
I manage a large sized Postgres farm with 100s of instances, and there has been one case where we need multi-master, and I went with Galera cluster for MariaDB. You can shard using the citus extension for Postgres.
- plaur782 6y ago

petters 6y ago

The excitement about NoSQL at Google seems to have stopped with the introduction of Spanner, at least.