Instead of just app_public, we need to app_test and app_live. Also two knex migration tracking tables in the cozemble schema, one for test and the other for live.
Applying migrations happens in app_test, and promoting to live applies them to the app_live schema.
Keep this abstract and data driven. Some contexts might be best served with only live, others by test and live and others still maybe by dev, test and live.
Core idea is a chain of logic environments, possibly of length one, the last one is production
Instead of just app_public, we need to app_test and app_live. Also two knex migration tracking tables in the cozemble schema, one for test and the other for live.
Applying migrations happens in app_test, and promoting to live applies them to the app_live schema.
Keep this abstract and data driven. Some contexts might be best served with only live, others by test and live and others still maybe by dev, test and live.
Core idea is a chain of logic environments, possibly of length one, the last one is production