question requirement v1.0
avatar mbabker
mbabker
22 Sep 2014

It's going to be impractical to always depend on someone to synchronize the live website with the git repository master branch or to automate deployments to the live environment. Prior to officially tagging a 1.0.0 stable release, we should establish a workflow with regards to how patches will be merged between tags (releases), how architectural changes will be handled (files will work OK when checking out git tags or revisions, but database schema updates will need some thinking), and how languages will be managed for releases. Any other concerns should be addressed within this issue too.

avatar mbabker mbabker - open - 22 Sep 2014
avatar mbabker mbabker - change - 22 Sep 2014
Labels Added: reoccurring
avatar mbabker mbabker - change - 22 Sep 2014
Labels Removed: reoccurring
avatar mbabker mbabker - change - 22 Sep 2014
Labels Added: question requirement
avatar mbabker mbabker - change - 22 Sep 2014
Labels Added: v1.0
avatar b2z
b2z - comment - 25 Sep 2014

I can't imagine how to manage SQL changes :confused:

Do you think we need to sync so often? Now when people have started to use new tracker we are having a little more job with fixing bugs and implementing hot features. But I do not think that it will continue forever ;)

avatar mbabker
mbabker - comment - 25 Sep 2014

I can't imagine how to manage SQL changes

The simplest thing would be that we have a folder with SQL files for each version there are changes in, somewhat similar to the CMS. So we tag 1.0.0 and 1.0.1 has a database change, then we'd have something like etc/updates/1.0.1.sql and that would have whatever queries are needed to alter the database. It doesn't need to be incorporated into any deploy script, but it surely would make running updates easier if we had a process where only tagged versions were deployed.

avatar b2z
b2z - comment - 27 Sep 2014

Sounds like solution.

and how languages will be managed for releases

Is it possible to update them on Transifex automatically?

avatar allenzhao
allenzhao - comment - 2 Mar 2015

About SQL or DB versioning, since I've started to work with Rails recently, I think we can implement a db migration module (or maybe there is already a similar solution like dbv ) which mangaes a db scheme file to log the whole db generate file(just like the sql file in /etc currently.
And everytime a change should be versioned to get every developer's working copy of JTracker working under the correct version of db and make deploy easier.

avatar mbabker
mbabker - comment - 30 Oct 2015

This never caught priority anyway.

avatar mbabker mbabker - change - 30 Oct 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-10-30 18:15:54
Closed_By mbabker
avatar mbabker mbabker - close - 30 Oct 2015

Add a Comment

Login with GitHub to post a comment