I'm looking at Apache Cayenne as my ORM layer for a new application.
Part of my DB model will be defined in a fixed model which will be known at compile time.
However, another part of the model will be defined at runtime by certain limited user operations. So, these operations will have the effect of creating certain simple tables, adding and removing columns from these tables, deleting tables etc.
It does seem that Cayenne is well-suited to this, based on its generic persistent objects feature.
https://cayenne.apache.org/docs/3.1/cayenne-guide/persistent-objects-objectcontext.html
I'm looking for some examples of how I would introduce the user-defined DbEntitys into the Cayenne runtime, generate and run the CREATE / ALTER / DROP SQL, and then specify that certain generic persistent objects are backed by certain user-defined tables.
Yes, Cayenne generic objects make it possible to alter your model in runtime. You have an additional challenge to update the actual schema. There are a few unknowns in the description (is the underlying DB shared by multiple apps/users; concurrency of the schema changes; do the changes need to be preserved in the underlying Cayenne model after they are applied). But here is a rough idea of how I would approach this:
Whenever a user is ready to make new changes, load the affected cayenne-project.xml separately from ServerRuntime using cayenne-project.jar library.
Make changes:
Save back to file system:
Now you might create a second ServerRuntime using a fresh model, and then run migrations against DB using API from org.apache.cayenne.merge package. You can create MergeToken's based on the changes you've made above using DbAdapter.mergerFactory() and then execute them:
Finally replace your original ServerRuntime that had the old model, with the 'newRuntime'.