egze
I’m using horde for distributed supervision and registry. My current challenge is to implement state handoff. I want to avoid any external systems like redis and use the tools I already have: either the BEAM or Postgres.
I’m thinking to use postgres like a KV store and store the state as binary. https://medium.com/@kaisersly/storing-any-elixir-data-in-postgres-e8f93367f473
Is this a crazy idea, or I should use json instead of binary? Or not use Postgres at all?
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #blog-post
- #ai
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
tristan
Erleans, GitHub - erleans/erleans: Erlang Orleans · GitHub, also supports Postgres for state storage for stateful grains.
I use binary term for this in the 2 provided state backends:
https://github.com/erleans/erleans_provider_pgo
https://github.com/erleans/erleans_provider_ecto
But the providers themselves decide whether to use a binary term or something else like json (or protobuf, etc). There certainly could be advantages to json, like if you for some reason wanted to query the state of grains (your processes) in the postgres table, but I think
term_to_binarysuits most needs.The only issue with
term_to_binaryis technically you could run into problems when moving between versions of OTP. And definitely would if records were used (but since you are in Elixir you don’t have that worry). Which is why Orleans suggests JSON https://dotnet.github.io/orleans/Documentation/grains/grain_persistence/index.html#recommendationsegze
Thanks. Probably not going to use Erleans (not sure if you were implying I should use it
), but glad that the concept of using Postgres for state is used somewhere.
I’ll start with something simple, without any extra libraries, and see how it goes.
tristan
Oh yea, I just thought prior art could be of help
dimitarvp
Having a Postgres table with just
idandmetadatafield (jsonbPostgres type for maps) worked quite fine for me in the past.