7 ms·
Can you use postgres as a state store for a distributed application? It seems this article is trending toward that view: If you can maintain transactional cons
by evilturnip 3mo ago
Can you use postgres as a state store for a distributed application?
It seems this article is trending toward that view: If you can maintain transactional consistency along with application workflow state, then would this generalize to maintaining distributed application state in general?
The follow-up would be: Would this be preferable to Valkey/Redis?
- KraftyOne 3mo ago[dead]
- munk-a 3mo agoYes you can - usually I think it's advisable to wrap postgres in a shim application to provide a consistently defined surface you can control but postgres can absolutely serve as the authority node on data correctness. As to which technical solution would be optimal there are a bunch of factors to consider and I think preferences around features could lead you to a variety of options. Postgres is excellent as long as you're minimizing the amount of data piping directly through it or operating at a reasonable scale.
- mrkeen 3mo ago> then would this generalize to maintaining distributed application state in general? Yes, in the sense of 'too good to be true'