Add database migration
Closed, ResolvedPublic



We need an automated way to update the database, especially for -- but it'll also be helpful for us.

Implementation (ideas)

Add an app_config database table with fields similar to user/collection attributes table. Upon app start, SELECT FROM app_config WHERE attribute = 'db_version';

If it isn't there, add it and set it to 1. Otherwise check it against a DB migrations module, and run any necessary migrations.

Also add this version number to schema.sql in the repo.

Revisions and Commits

Related Objects


Event Timeline

matt triaged this task as Low priority.Jan 24 2018, 7:35 PM
matt created this task.
matt moved this task from Backlog to Oct - Dec 2018 on the Web board.Mar 2 2018, 8:48 PM
matt edited projects, added Web (Oct - Dec 2018); removed Web.
matt changed the visibility from "Restricted Project (Project)" to "Public (No Login Required)".Nov 7 2018, 5:30 PM
matt added a project: WriteFreely.
matt moved this task from Backlog to v1.0 on the WriteFreely board.Nov 18 2018, 3:40 PM
matt edited projects, added WriteFreely (v1.0); removed WriteFreely.
matt claimed this task.Jan 17 2019, 9:16 PM
matt closed this task as Resolved.Jan 24 2019, 1:45 PM