4 ms·

Good read and yes, postgres is king, no argument there but i do think the comparison is a bit unfair to RethinkDB. Work on Postgres started in 1986, you can't c

Good read and yes, postgres is king, no argument there but i do think the comparison is a bit unfair to RethinkDB. Work on Postgres started in 1986, you can't compare performance of tools when one of them had 30 years to work on performance and the other is like 5y old which had the benefit of only a handful of brains working on it. I would say it's remarkabl what RethinkDB did in this timeframe. In relation to Postgres and real time messages, another approach is to use a real messaging server instead of using only the simple listen/notify interface pg provides. It's possible to connect them using this https://github.com/gmr/pgsql-listen-exchange https://github.com/gmr/pgsql-listen-exchange I am just wrapping up the integration here (http://graphqlapi.com http://graphqlapi.com) and so far it looks good. Postgres provides the power and features we all know and rabbitmq gives you all the realtime capabilities you need, and you can route messages in complex ways and have them delivered to a whole bunch of clients.

paulsutter 10y ago
> you can't compare performance of tools when one of them had 30 years to work on performance and the other is like 5y old Actually, you can and should. In fact that's the whole point. You certainly can't make a judgement on the skills of the developers, but William isn't doing that.
- ruslan_talpa 10y ago
  You are right, that was not a good choice of words. What i was getting at is that the article reads as "i was constantly fighting Rdb and Pg solved all my problems" and even if ppl don't make judgements on the developers they do so on the tool and that kind of remains in your brain, you attach a stigma to the tool and never consider it even though it will get a lot better if you just give it time. For example, i tried pg back in 2000 something, did just a stupid benchmark on how fast it does a count, compared it to mysql and never looked back, so for 10 years i ignored pg because of that stupid test and because in my brain there was this idea that it's slow. Thank god i somehow got over that ...
  - aidos 10y ago
    Might be wrong, but I feel like you may have a vested interest and hence read the article as more of an attack than it really was. To me it reads more like "I understood the problem space better during the rewrite so I could solve things in more apppropriate ways with a the tools at hand."
    - ruslan_talpa 10y ago
      Yes you are wrong :) i do not have a vested interest in RethinkDB, I actually do have a vested interest in Postgres :), so i was kind of defending the other guy although i am PG all the way (read my other comments, you'll see i quite like PG, so much so that i built a tool/business around it) EDIT: removed a link
jlg23 10y ago
> you can't compare performance of tools Of course you can. Unless the newcomer gives me the $800/month the OP saves now with pgsql, performance is one of the key metrics. Nobody cares if you can ride your bicycle hands-free if you come in last in the race.
- ruslan_talpa 10y ago
  that was a bad choice of words, i explained in the other commend below

paulsutter 10y ago

> you can't compare performance of tools when one of them had 30 years to work on performance and the other is like 5y old Actually, you can and should. In fact that's the whole point. You certainly can't make a judgement on the skills of the developers, but William isn't doing that.

ruslan_talpa 10y ago
You are right, that was not a good choice of words. What i was getting at is that the article reads as "i was constantly fighting Rdb and Pg solved all my problems" and even if ppl don't make judgements on the developers they do so on the tool and that kind of remains in your brain, you attach a stigma to the tool and never consider it even though it will get a lot better if you just give it time. For example, i tried pg back in 2000 something, did just a stupid benchmark on how fast it does a count, compared it to mysql and never looked back, so for 10 years i ignored pg because of that stupid test and because in my brain there was this idea that it's slow. Thank god i somehow got over that ...
- aidos 10y ago
  Might be wrong, but I feel like you may have a vested interest and hence read the article as more of an attack than it really was. To me it reads more like "I understood the problem space better during the rewrite so I could solve things in more apppropriate ways with a the tools at hand."
  - ruslan_talpa 10y ago
    Yes you are wrong :) i do not have a vested interest in RethinkDB, I actually do have a vested interest in Postgres :), so i was kind of defending the other guy although i am PG all the way (read my other comments, you'll see i quite like PG, so much so that i built a tool/business around it) EDIT: removed a link

jlg23 10y ago

> you can't compare performance of tools Of course you can. Unless the newcomer gives me the $800/month the OP saves now with pgsql, performance is one of the key metrics. Nobody cares if you can ride your bicycle hands-free if you come in last in the race.

ruslan_talpa 10y ago
that was a bad choice of words, i explained in the other commend below