Simplify migrations

[johnmartins]

A neater way of building and updating the database is needed.

Currently, the SQL-script in core needs to be run. But this script can't contain table alterations, because if it does then the script will fail anytime somebody who already has those alterations in place. Works fine for docker, but not for development.

Alternatives:

• ORM-less mutation: https://medium.com/building-the-system/dont-be-a-sucker-and-stop-using-orms-190add65add4
• DB migration handling software
• ?

[johnmartins]

dbmate seems like a promising alternative

[johnmartins]

@mujakob I noticed that you are still using the ORM. This change will heavily affect you. Make sure that you follow the documented way of making modules (strict separation of route, implementation and storage), so that the transition to the standard will be as smooth as possible. We will be converting everything to SQL to avoid multiple migration systems.