{"action":"created","issue":{"url":"https://api.github.com/repos/QGEP/QGEP/issues/160","labels_url":"https://api.github.com/repos/QGEP/QGEP/issues/160/labels{/name}","comments_url":"https://api.github.com/repos/QGEP/QGEP/issues/160/comments","events_url":"https://api.github.com/repos/QGEP/QGEP/issues/160/events","html_url":"https://github.com/QGEP/QGEP/issues/160","id":115050360,"number":160,"title":"Profile plugin question","user":{"login":"bogdanvaduva","id":11473648,"avatar_url":"https://avatars.githubusercontent.com/u/11473648?v=3","gravatar_id":"","url":"https://api.github.com/users/bogdanvaduva","html_url":"https://github.com/bogdanvaduva","followers_url":"https://api.github.com/users/bogdanvaduva/followers","following_url":"https://api.github.com/users/bogdanvaduva/following{/other_user}","gists_url":"https://api.github.com/users/bogdanvaduva/gists{/gist_id}","starred_url":"https://api.github.com/users/bogdanvaduva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bogdanvaduva/subscriptions","organizations_url":"https://api.github.com/users/bogdanvaduva/orgs","repos_url":"https://api.github.com/users/bogdanvaduva/repos","events_url":"https://api.github.com/users/bogdanvaduva/events{/privacy}","received_events_url":"https://api.github.com/users/bogdanvaduva/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-11-04T13:20:09Z","updated_at":"2015-12-01T07:36:37Z","closed_at":"2015-12-01T07:36:37Z","body":"I've done a great job with that plugin, but I have a question. I wanted to integrate that plugin in my web application (I've done it, I'll add some screenshots) and I found that it would have been easier to integrate the plugin if you have created the JSON data with postgresql.\r\n\r\nI created a postgresql function that builds the JSON.\r\nIf you think it helps you I can send the postgresql function.\r\n\r\n![screenshot from 2015-11-04 15 09 02](https://cloud.githubusercontent.com/assets/11473648/10939030/53d9693e-8307-11e5-87c0-60e088d7a8ae.png)\r\n![screenshot from 2015-11-04 15 09 10](https://cloud.githubusercontent.com/assets/11473648/10939029/53d77930-8307-11e5-9592-f50b7d462d92.png)\r\n![screenshot from 2015-11-04 15 09 18](https://cloud.githubusercontent.com/assets/11473648/10939031/53d9c014-8307-11e5-89a9-f7816a872ba5.png)\r\n![screenshot from 2015-11-04 15 09 38](https://cloud.githubusercontent.com/assets/11473648/10939032/53dcb9e0-8307-11e5-83ea-56b84449b806.png)\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/QGEP/QGEP/issues/comments/160884633","html_url":"https://github.com/QGEP/QGEP/issues/160#issuecomment-160884633","issue_url":"https://api.github.com/repos/QGEP/QGEP/issues/160","id":160884633,"user":{"login":"bogdanvaduva","id":11473648,"avatar_url":"https://avatars.githubusercontent.com/u/11473648?v=3","gravatar_id":"","url":"https://api.github.com/users/bogdanvaduva","html_url":"https://github.com/bogdanvaduva","followers_url":"https://api.github.com/users/bogdanvaduva/followers","following_url":"https://api.github.com/users/bogdanvaduva/following{/other_user}","gists_url":"https://api.github.com/users/bogdanvaduva/gists{/gist_id}","starred_url":"https://api.github.com/users/bogdanvaduva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bogdanvaduva/subscriptions","organizations_url":"https://api.github.com/users/bogdanvaduva/orgs","repos_url":"https://api.github.com/users/bogdanvaduva/repos","events_url":"https://api.github.com/users/bogdanvaduva/events{/privacy}","received_events_url":"https://api.github.com/users/bogdanvaduva/received_events","type":"User","site_admin":false},"created_at":"2015-12-01T07:36:37Z","updated_at":"2015-12-01T07:36:37Z","body":"Hi @m-kuhn, basically the idea was to replace networkx with postgresql functions/procedures/views.\r\nAbout the name, usually I use fn for functions, vw for views and so one, but in this case the vw it didn't stand from vw :D (sorry for misunderstanding). \r\nI will look into materialized views and try to build the network according to it (but in the following weeks).\r\nAbout pgrouting, it's a great idea, I never thought about it (thanks for the idea).\r\n\r\nYes you're right about code proposal. It makes sense to do pull requests.\r\n\r\nThe last note, the profile function get as input reaches, but i added two functions that get as input a cover and builds the input string (reaches) for profile function. I will make the pull requests in the next days.\r\n\r\nRegards.\r\n"}}