dynamic-models | Example project demonstrating dynamic models in Django

Goal: Have a phoenix app (#1), that has empty (no tables) Postgres and on first boot waits to be further setup. Once it receives migration and model/schema files via http from other phoenix app (#2), it runs migrations, starts a supervisor(App1.Repo, []), and all received models/schemas from app #2 puts in state in worker(App1.Models, []), so that app #1 can process queries like Repo.all(User). Then, app #1 listens for requests from the app #2 and performs changes in Postgres.

Reason: Idea is to isolate DB completely from app #2, so that when it needs something from db, it just sends Ecto queries to app #1, and app #1 is able to perform that query and return a result. However, app #1 copy can be spawned for different apps, i.e. app #2, #3, #4, which all have different models/schemas, and on first connection provide their db settings (models/migrations) to app #1, which prepares its Postgres with those settings, and then just accept db queries.

Step 1: App #1 receives User model and respective migration file from app #2.

Step 2: App #1 runs migration file to prepare Postgres.

Step 3: App #1 starts a GenServer (process?) with Ecto, Repo and newly received User model from app #2 and listens for incoming requests.

Step 4: App #1 receives request, runs query, and returns list of all users in its db.