Please state your opinion, and preferably reasoning. why you think NixOS modules should automatically run database schema updates or not.
Some relevant discussion points:
- Some software doesn’t give you a choice and run schema updates automatically when the main binary starts.
- Numerous modules in NixOS automatically run schema updates, while others do not.
- At least several pieces of software in NixOS which don’t run schema updates automatically do not mention the need to run schema updates manually, sometimes resulting in failures which go unnoticed for a while.
- Database schemas can take a while to run and often times can’t be backed out, leaving the unprepared sysadmin with a headache when things go wrong.
I don’t think we have an official stance on whether automatically running schema updates is the right thing to do or not so I would love to hear everyone’s thoughts and opinions.