|Subject||RE: [firebird-support] firebird schema changes during backup|
> ---- On Mon, 23 Jan 2017 15:48:15 -0500 Dimitry SibiryakovFirebird does support dynamic changes, you can change the database schema while users are connected.
> mailto:sd@... [firebird-support] <mailto:firebird-
> email@example.com> wrote ----
> Changing metadata is a bad idea in general.
> Continuous development is the worst thing that can happen to a database.
> And that is the traditional database's Achilles Heel because "change" is
> inevitable and rapid change is a fact of life today.
> If Firebird were to bolster its support for dynamic changes it would become a
> much more attractive beast.
Dmitry was referring more to the inherent risks of using a production database as a development platform -- schema changes need to be tested and carefully applied.
In our case, we use strict SQL script numbering process along with a CI process that ensures that all scripts are checked/tested against exemplar database*0*s before a master script is created/applied.