spacebat
Concurrent access to several Ecto Dynamic Repositories
I’d like to connect to different databases on the fly based on details obtained at runtime. The application could be talking to several of these simultaneously.
The advice given in the Ecto documentation on using put_dynamic_repo sounds like it would be fine for talking to a single runtime-configured database at a time - the Ecto repo module, let’s call it MyApp.DynamicRepo, can be pointed at or use different databases at different times. However it would be only one at a time.
I could put a genserver in front of it to serialise access but that’s likely to be a bottleneck. Or I could hard code (or generate at runtime) a group of repo modules to serve as a “repo pool” and have all the database access code receive a repo module to use for its calls.
Are there saner alternatives that I’m missing here?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Error tracking, logs, APM, uptime and cron monitoring in one dev-friendly platform. Find and fix problems before your users notice.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #performance
- #security
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Develop your skills with books, videos, and courses.
Bringing learning, work and compliance together since 1987.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Marked As Solved
voughtdq
put_dynamic_repo/1is per-process, so you can spin up 100 processes and all 100 can use a different repo by callingput_dynamic_repo/1.One thing you could do is use ETS (or Registry, which IIRC uses monitors so automatically handles process bookkeeping) to look up the repo you want and set the dynamic repo to the returned pid.
Last Post!
spacebat
Right, I see it uses
Process.put/2, definitely missed that, thanks!