abhinavs
Hi all,
I’m trying to create a business intelligence tool in Elixir. It’s a multi-tenant app, and users can submit their database credentials so that queries are executed on their database. I will also persist these credentials in my own database (by encrypting them)
This might seem a very n00b question - however, I haven’t been able to figure out how to go about doing it.
I did try to see how livebook does it, it seem to be using a library called kino_db which does work for a session. However, I’m not sure if these credentials are persisted and are even used in the background for offline data reporting.
Any pointers on how to go about doing it will be great. To start with I’m willing to restrict the scope to Postgres and BigQuery.
Thanks,
Abhinav
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
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
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixirconf-us
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
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)
benwilson512
Hey @abhinavs can you elaborate as to where you are stuck? Is it the encryption and storage in postgres that has you stuck? Are you unclear on how to use these credentials to start new database connections? What are you stuck on?
abhinavs
Thanks for asking. I’m stuck on how to start new database connections.
I’m used to creating the usual Phoenix app in which database configuration settings are provided in the config file. I’m not sure how to create these db connections dynamically (that are user supplied) and maintain them.
I might be overthinking too, however, I have questions about how to manage these separate pools of DB connections, and security practices.
benwilson512
Gotcha! For starting repos dynamically you can do Replicas and dynamic repositories — Ecto v3.14.0. Depending on what you are doing with those, it may be easier to just use Postgrex directly Postgrex — Postgrex v0.22.2 at that point as well.
BigQuery doesn’t do connections in that same way at all. There you’d be making HTTP requests.
abhinavs
Thanks a lot, Ben. Let me explore Postgrex.