{"action":"created","issue":{"url":"https://api.github.com/repos/graphile/postgraphile/issues/579","repository_url":"https://api.github.com/repos/graphile/postgraphile","labels_url":"https://api.github.com/repos/graphile/postgraphile/issues/579/labels{/name}","comments_url":"https://api.github.com/repos/graphile/postgraphile/issues/579/comments","events_url":"https://api.github.com/repos/graphile/postgraphile/issues/579/events","html_url":"https://github.com/graphile/postgraphile/issues/579","id":256057164,"number":579,"title":"Using GraphQL Schema to generate Postgres migrations","user":{"login":"flux627","id":5218949,"avatar_url":"https://avatars2.githubusercontent.com/u/5218949?v=4","gravatar_id":"","url":"https://api.github.com/users/flux627","html_url":"https://github.com/flux627","followers_url":"https://api.github.com/users/flux627/followers","following_url":"https://api.github.com/users/flux627/following{/other_user}","gists_url":"https://api.github.com/users/flux627/gists{/gist_id}","starred_url":"https://api.github.com/users/flux627/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/flux627/subscriptions","organizations_url":"https://api.github.com/users/flux627/orgs","repos_url":"https://api.github.com/users/flux627/repos","events_url":"https://api.github.com/users/flux627/events{/privacy}","received_events_url":"https://api.github.com/users/flux627/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-09-07T20:14:56Z","updated_at":"2018-03-16T18:38:48Z","closed_at":null,"author_association":"NONE","body":"We are in early stages for planning the architecture for our startup, and I am evaluating this as an option. Something that occurred to me while reading this:\r\n\r\nhttps://www.graphile.org/postgraphile/postgresql-schema-design/\r\n\r\nSince there is such a close relationship to how schemas are defined in Postgres and how they map to the generated GraphQL schema, it seems to me that it would be a big simplification (in terms of developer experience) if we could programmatically generate Postgres migration files from a human-generated GraphQL Schema, rather than the other way around. This would allow for an easier \"GraphQL First\" experience, could open up possibilities for extending functionality through custom directives, and even pave the way for Django's South-style automatic creation of migrations. Does this resonate with the goals of this project?\r\n\r\nPlease excuse me if this is completely off-base, as all this is still a bit new to me. Input appreciated."},"comment":{"url":"https://api.github.com/repos/graphile/postgraphile/issues/comments/373807482","html_url":"https://github.com/graphile/postgraphile/issues/579#issuecomment-373807482","issue_url":"https://api.github.com/repos/graphile/postgraphile/issues/579","id":373807482,"user":{"login":"micimize","id":8343799,"avatar_url":"https://avatars1.githubusercontent.com/u/8343799?v=4","gravatar_id":"","url":"https://api.github.com/users/micimize","html_url":"https://github.com/micimize","followers_url":"https://api.github.com/users/micimize/followers","following_url":"https://api.github.com/users/micimize/following{/other_user}","gists_url":"https://api.github.com/users/micimize/gists{/gist_id}","starred_url":"https://api.github.com/users/micimize/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/micimize/subscriptions","organizations_url":"https://api.github.com/users/micimize/orgs","repos_url":"https://api.github.com/users/micimize/repos","events_url":"https://api.github.com/users/micimize/events{/privacy}","received_events_url":"https://api.github.com/users/micimize/received_events","type":"User","site_admin":false},"created_at":"2018-03-16T18:38:48Z","updated_at":"2018-03-16T18:38:48Z","author_association":"NONE","body":"One route towards this would be to use [graphql-code-generator](https://medium.com/@dotansimha/graphql-code-generator-a34e3785e6fb) to generate [sqlalchemy models](http://docs.sqlalchemy.org/en/latest/orm/tutorial.html), then use that to [autogenerate](http://alembic.zzzcomputing.com/en/latest/autogenerate.html) migrations, only using postgraphile to run the server itself.\r\n\r\nVery appealing prospect, but pretty disjoint from postgraphile's own design goals"}}
{"actor":{"display_login":"micimize"}}