You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/08/03 11:55:31 UTC

[GitHub] [dolphinscheduler] zhongjiajie opened a new issue, #11286: [Feature][database] Find better way to upgrade database instead of bare sql script

zhongjiajie opened a new issue, #11286:
URL: https://github.com/apache/dolphinscheduler/issues/11286

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement.
   
   
   ### Description
   
   currently we using bare sql script to init or upgrade our databases which we can see in https://github.com/apache/dolphinscheduler/tree/dev/dolphinscheduler-dao/src/main/resources/sql/upgrade
   
   and it is face some issue
   
   * have to write multiple database type and multiple place
     * multiple database type: to adopt different database: currently we support postgres, mysql, h2
     * multiple place: we have to change multiple sql script files when we need to upgrade it, and have consistency issues
   * do not support downgrade: if user just want to test the latest versions, we should better have downgrade command
   * can not rerun: for ddl we can use store process to fix it(complex), but dml like insert may have error(duplicate key), or insert some record without uk.
   
   ### Use case
   
   _No response_
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [dolphinscheduler] lushaorong commented on issue #11286: [Feature][database] Find better way to upgrade database instead of bare sql script

Posted by GitBox <gi...@apache.org>.
lushaorong commented on issue #11286:
URL: https://github.com/apache/dolphinscheduler/issues/11286#issuecomment-1231536966

   Maybe Liquibase is a good way？


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [dolphinscheduler] zhongjiajie commented on issue #11286: [Feature][database] Find better way to upgrade database instead of bare sql script

Posted by "zhongjiajie (via GitHub)" <gi...@apache.org>.
zhongjiajie commented on issue #11286:
URL: https://github.com/apache/dolphinscheduler/issues/11286#issuecomment-1645242476

   > Maybe Liquibase is a good way？
   
   sound good, will take a look, or maybe we can use https://atlasgo.io/declarative/diff to detect the diff to make sure the change it is correct


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #11286: [Feature][database] Find better way to upgrade database instead of bare sql script

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11286:
URL: https://github.com/apache/dolphinscheduler/issues/11286#issuecomment-1203852992

   Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
   * If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org