Re:System design hack: Postgres is a great pub/sub and job s...
by dplgk on Saturday November 09, 2019 @10:05AM
(#21491907)
Forgive my ignorance, how is this specific to postgres? Or what are the advantages of doing this in pg rather than mysql or redis?
[ Parent
| on HN ]
Re:System design hack: Postgres is a great pub/sub and job s...
by nostrademons on Saturday November 09, 2019 @11:43AM
(#21492527)
It's not really, although you really want to do it with a data store that supports transactional semantics. Postgres, MySQL with InnoDB,Redis, Amazon SQS, DynamoDB will all work. First time I used this pattern was with Amazon SQS; second time was MySQL with InnoDB tables. The article's about Postgres hacks, though, and Postgres is pretty commonly used for other parts of your system.