{"action":"created","issue":{"url":"https://api.github.com/repos/capistrano/rails/issues/118","repository_url":"https://api.github.com/repos/capistrano/rails","labels_url":"https://api.github.com/repos/capistrano/rails/issues/118/labels{/name}","comments_url":"https://api.github.com/repos/capistrano/rails/issues/118/comments","events_url":"https://api.github.com/repos/capistrano/rails/issues/118/events","html_url":"https://github.com/capistrano/rails/issues/118","id":70166376,"node_id":"MDU6SXNzdWU3MDE2NjM3Ng==","number":118,"title":"Deploy new applications with db:schema:load","user":{"login":"Odaeus","id":2150,"node_id":"MDQ6VXNlcjIxNTA=","avatar_url":"https://avatars3.githubusercontent.com/u/2150?v=4","gravatar_id":"","url":"https://api.github.com/users/Odaeus","html_url":"https://github.com/Odaeus","followers_url":"https://api.github.com/users/Odaeus/followers","following_url":"https://api.github.com/users/Odaeus/following{/other_user}","gists_url":"https://api.github.com/users/Odaeus/gists{/gist_id}","starred_url":"https://api.github.com/users/Odaeus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Odaeus/subscriptions","organizations_url":"https://api.github.com/users/Odaeus/orgs","repos_url":"https://api.github.com/users/Odaeus/repos","events_url":"https://api.github.com/users/Odaeus/events{/privacy}","received_events_url":"https://api.github.com/users/Odaeus/received_events","type":"User","site_admin":false},"labels":[{"id":364467835,"node_id":"MDU6TGFiZWwzNjQ0Njc4MzU=","url":"https://api.github.com/repos/capistrano/rails/labels/discuss!","name":"discuss!","color":"5319e7","default":false},{"id":42294952,"node_id":"MDU6TGFiZWw0MjI5NDk1Mg==","url":"https://api.github.com/repos/capistrano/rails/labels/new%20feature","name":"new feature","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":18,"created_at":"2015-04-22T15:54:42Z","updated_at":"2018-11-20T21:21:36Z","closed_at":null,"author_association":"NONE","body":"Hello,\n\nI see that [someone requested this feature for a different reason](https://github.com/capistrano/rails/issues/62) and it was denied. I don't understand the reason for dismissal, as the [source of truth for the database schema](http://guides.rubyonrails.org/active_record_migrations.html#schema-dumping-and-you) is the `/db/schema.rb` or `/db/structure.sql` file. Migrations are only designed to manage changes to the database and it seems a waste to run the entire migration history when deploying a new application. Also it should be possible to delete old migrations if an application has a great many.\n\n> There is no need (and it is error prone) to deploy a new instance of an app by replaying the entire migration history. It is much simpler and faster to just load into the database a description of the current schema. - [Rails guide](http://guides.rubyonrails.org/active_record_migrations.html#schema-dumping-and-you)\n\nAny chance you would reconsider this position?\n"},"comment":{"url":"https://api.github.com/repos/capistrano/rails/issues/comments/440433810","html_url":"https://github.com/capistrano/rails/issues/118#issuecomment-440433810","issue_url":"https://api.github.com/repos/capistrano/rails/issues/118","id":440433810,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MDQzMzgxMA==","user":{"login":"vifreefly","id":42641380,"node_id":"MDQ6VXNlcjQyNjQxMzgw","avatar_url":"https://avatars3.githubusercontent.com/u/42641380?v=4","gravatar_id":"","url":"https://api.github.com/users/vifreefly","html_url":"https://github.com/vifreefly","followers_url":"https://api.github.com/users/vifreefly/followers","following_url":"https://api.github.com/users/vifreefly/following{/other_user}","gists_url":"https://api.github.com/users/vifreefly/gists{/gist_id}","starred_url":"https://api.github.com/users/vifreefly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vifreefly/subscriptions","organizations_url":"https://api.github.com/users/vifreefly/orgs","repos_url":"https://api.github.com/users/vifreefly/repos","events_url":"https://api.github.com/users/vifreefly/events{/privacy}","received_events_url":"https://api.github.com/users/vifreefly/received_events","type":"User","site_admin":false},"created_at":"2018-11-20T21:21:36Z","updated_at":"2018-11-20T21:21:36Z","author_association":"NONE","body":"I think all what we need here is to call `rails db:create` at the first deploy before `db:migrate`. Use `db:schema:load` is a bit dangerous. \r\n\r\nAnyway, this issue should be resolved. It is an official rails tasks for Capistrano. Having the first deploy always to be failed (because database is not created) and going to the server to manually type `rails db:create` doesn't seems for me like automation.\r\n\r\nOr at least add to the README info about the assuming fail at the first deploy, so the Capistrano newbies will not be so scared when it's happen."}}
{"actor":{"display_login":"vifreefly"}}