Conversation

Notices

1. Embed this notice
   Evan Prodromou (evan@prodromou.pub)'s status on Friday, 25-Nov-2022 00:53:00 JST Evan Prodromou

   This is an interesting claim by PostgreSQL. I wonder if it is defensible?

   • Embed this notice
     Evan Prodromou (evan@prodromou.pub)'s status on Friday, 25-Nov-2022 00:53:41 JST Evan Prodromou

     in reply to

     In what way is PostgreSQL measurably more advanced than any other Open Source rdbms?

   • Embed this notice
     David Martínez Martí (deavid@techhub.social)'s status on Friday, 25-Nov-2022 02:34:51 JST David Martínez Martí

     in reply to

     @evan Amountof SQL compatibility is outstanding. The transaction safety and concurrency, MVCC model is very good. The way it integrates with the OS caching is amazing as well.

     What other DBs want to compare to?

     MySQL: If your DB doesn't fit into memory, low performance. Also, low guarantees of data consistency and atomicity. Postgres can handle >100TB of data.

   • Embed this notice
     Evan Prodromou (evan@prodromou.pub)'s status on Friday, 25-Nov-2022 02:34:51 JST Evan Prodromou

     in reply to

     • David Martínez Martí

     @deavid so, how would you say PostgreSQL is more "advanced" than MySQL?

     Assume we're going to take that term literally, and not just in the colloquial meaning of "better"

   • Embed this notice
     Evan Prodromou (evan@prodromou.pub)'s status on Friday, 25-Nov-2022 02:35:08 JST Evan Prodromou

     in reply to

     • Accept purpose.

     @laprice exactly

   • Embed this notice
     Accept purpose. (laprice@mastodon.social)'s status on Friday, 25-Nov-2022 02:35:09 JST Accept purpose.

     in reply to

     @evan

     Advanced in which sense?

     Advancing the state of the art?

     An advanced case of?

     ps. I love it a lot

   • Embed this notice
     Evan Prodromou (evan@prodromou.pub)'s status on Friday, 25-Nov-2022 02:35:43 JST Evan Prodromou

     in reply to

     • Moon Baron :TwinPines:

     @moon_baron it's like The Onion, "America's finest news source"

   • Embed this notice
     Moon Baron :TwinPines: (moon_baron@social.coop)'s status on Friday, 25-Nov-2022 02:35:44 JST Moon Baron :TwinPines:

     in reply to

     @evan Yah, I mean this certainly falls under the "unprovable marketing claims" column in my books, but there are indeed some pretty great features in pgsql all under one roof:

     - You can make NoSQL-style queries with JSON columns

     - You can do some pretty reliable full-text search

     - Their pub-sub story is really strong.

     In my opinion, you can replace a lot of systems with pgsql if you're at a smaller scale.

     Of course, it has it's limitations and isn't a panacea.