I’m writing an app that manages sensitive data. It might be nice to segregate each customer’s data into a separate Sqlite database. I’ve done different flavors of multi-tenancy in Postgres, and have configured apps that use a pre-defined group of databases. But never have seen anyone attach, crea…

Ecto also allows you dynamic repositories .

I’ve done it in Rust and Golang but not in Elixir yet. Very common practice in certain businesses.

[image] AndyL: I’m writing an app that manages sensitive data. It might be nice to segregate each customer’s data into a separate Sqlite database. In general Sqlite does not provide strong security mechanisms. It might be inappropriate to handle sensitive data. On the other hand, I do see th…

I’m pretty sure everything you need can be achieved in Elixir/Phoenix, yet, I must say, I have no experience with it. Having said that, if instead of calling Repo in your project, you do something akin to get_repo(user, team), where you lazy create that database if it doesn’t exist (and check permi…

At scale this becomes less appealing. There is a cost to open/close each db. At scale you won’t be able to keep all of them open all the time. With any kind of concurrent usage of a single db, your app will need to coordinate who the “writer” is. If your app moves to multiple nodes, the work w…

Ecto also allows you dynamic repositories . This looks promising. Thanks for the tip !!

:dets might be an option since it uses one file per key-value store and has simple commands to open and close the files.

@dimitarvp thanks again for the reference to dynamic repos. Using this info, I wrote an prototype library called DynDb to manage Dynamic Sqlite databases. Interested to get feedback re: API design and potential gotchas. Have a look! #!/usr/bin/env elixir Mix.install([ {:dyn_db, github: "andy…

Looks alright for a start. I’d have 80% of the code be tests though. :grin: But that’s for later stage.

Alex Koutmos played with something similar previously, maybe this is useful? Alex Koutmos on X: "Using Ecto dynamic repositories, a DynamicSupervisor, and a Registry, I was able to create a SQLite powered Phoenix app where every user has their own SQLite db and interacts with their own repo instance…

Elixir Programming Language Forum

Separate Sqlite Database per Customer?

Questions & Help Questions

AndyL March 26, 2023, 2:58pm 9

:dets is simple to use for dynamic k/v stores…

Yes! Also CubDB.