Schema change practices in nodeBB
Dear developers from nodeBB,
I'm a student at the University of Applied Sciences in Regensburg (Germany).
Currently I'm working on my master's thesis, contributing to a research project in the field quantitative software engineering.
By mining the software histories of popular open source projects, we want to get insight about current development practices and challenges. Our main focus here is to understand the co-evolution/change-coupling of software artifacts, especially in the case of database-related changes. Since there are hardly works or established tools considering the co-evolution of schema and the code accessing it, we are investigating this topic.
As nodeBB is one major project in the open-source-community and is also supporting several databases (especially of different types - RDBMS & NoSQL), I have some questions:
We found out that schema related changes were often committed together - across all databases.
So in your case, the changes were done for mongo, postgres and redis in the same commit.
- Could you describe the common process of introducing these schema changes or do you have a manual for that?
- Is there any tool in use, which supports this process automatically or is it done manually?
- How much time is consumed when introducing schema changes in your project?
- Which problems occur when changing the schema?
Hopefully you can spend some time to answer these questions, I would appreciate that!