iamwil
How to connect to user-specified DB config using Ecto?
Hi all,
I’m a bit new to Ecto and Elixir. I got a question about connecting to a database.
I have a Phoenix project where I want to allow my user to connect to a database of their choosing. However, I’m not sure how to use Ecto to connect to the DB, unless it’s set in the configuration of the project and run when the server is started up.
When I have a second repo module
defmodule MyApp.SecondRepo do
use Ecto.Repo, otp_app: :myapp
end
Elixir complains that it doesn’t have the right config to initialize this module. Can anyone point me to how to connect to a user-specified database after the Phoenix server has already been started up? Thanks.
Wil
Most Liked
michalmuskala
There are some configuration values that are required at compile-time. This is primarily the adapter - ecto inlines some functions in the repo, based on the adapter, in order to speed-up dome hot paths.
Most of the other configuration values can be passed to the repo’s start_link function (or as options in the supervisor).
There’s a list of compile-time options and runtime options in the documentation: https://hexdocs.pm/ecto/Ecto.Adapters.Postgres.html
NobbZ
Ecto does not allow dynamic configuration of the DB at runtime. Your only option is to directly use the DB-Adapter to go through connection and query.
Thats at least what I understand when reading github issue #1183
hubertlepicki
Can you tell us a bit more broadly what your end result should be? I mean, I suspect you may want to do multi-tenancy by connecting to multiple databases? If this is the case then Ecto has sort of different approach, by using namespaces/prefixes rather than connecting to multiple databases.
Last Post!
joefractal
Popular in Questions
Other popular topics
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
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex









