Automatic schema update in ejabberd
ejabberd 23.10 has a new feature that is currently in beta testing: Automatic relational schema creation and update.
Previously, if you were using ejabberd with an external relational database, you might have to manually apply some schema changes that come with new features when you upgrade to a new ejabberd release. ejabberd can now handle this schema upgrade automatically. It can also create the schema on an empty database during a new deployment. It works with both old and new schemas.
This feature paves the way for more changes to our schema in the future. It is currently in beta testing, we recommend backing up your database before using it. To enable it in ejabberd 23.10, set this top-level option in your ejabberd.yml configuration file and restart ejabberd:
update_sql_schema: true
This is compatible with the following relational databases:
Feel free to test it and report any problems on GitHub Issues.