News for hackers. Stuff that matters.

A comment on System design hack: Postgres is a great pub/sub and job server. Parent comment

Re:System design hack: Postgres is a great pub/sub and job s... by gigatexal on Friday November 08, 2019 @03:36PM (#21486452)
Redis modifications are transactional: https://redis.io/topics/transactions

Though I agree on points 2 and 3, especially 3 since it adds complexity.

[ Parent | on HN ]
Re:System design hack: Postgres is a great pub/sub and job s... by erichocean on Saturday November 09, 2019 @03:36PM (#21494185)
> Redis modifications are transactional

That's only true if they do not error—there is no "rollback" feature in Redis, and if you do error, anything you've done up to that point remains.

That's not transactional, it's more "you can, sometimes, execute a bunch of separate statement atomically".

[ Parent | on HN ]
Re:System design hack: Postgres is a great pub/sub and job s... by gigatexal on Saturday November 09, 2019 @04:14PM (#21494393)
I’ll admit I don’t know the internals of Redis as well as I do relational databases. I’ve learned much from this thread.
[ Parent | on HN ]
Re:System design hack: Postgres is a great pub/sub and job s... by Rapzid on Friday November 08, 2019 @03:52PM (#21486604)
Internally but if the change causing the work is in PostgreSQL Redis would need to support 2-phase commits to commit the change and the work together atomically(and durably).
[ Parent | on HN ]