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