Hi fellow elixir developers, Are you able to add dynamic fields to the database schema from the html User Interface such that they are also been added to the Database Schema. If so how can that be done and if possible please may you show me a sample repository.
Ecto does support querying tables dynamically and you can build schemaless changesets for dynamic sets of data, but schemas itself cannot have dynamic fields. You can put an untyped map field into a schema, but that’s still another layer. So if your users can alter the database columns/tables you likely need to build your own code around ecto’s dynamic options for dealing with sets of data.