{"action":"created","issue":{"url":"https://api.github.com/repos/grafana/grafana/issues/1542","repository_url":"https://api.github.com/repos/grafana/grafana","labels_url":"https://api.github.com/repos/grafana/grafana/issues/1542/labels{/name}","comments_url":"https://api.github.com/repos/grafana/grafana/issues/1542/comments","events_url":"https://api.github.com/repos/grafana/grafana/issues/1542/events","html_url":"https://github.com/grafana/grafana/issues/1542","id":59347338,"number":1542,"title":"Grafana 2.0: SQL Data source","user":{"login":"torkelo","id":10999,"avatar_url":"https://avatars.githubusercontent.com/u/10999?v=3","gravatar_id":"","url":"https://api.github.com/users/torkelo","html_url":"https://github.com/torkelo","followers_url":"https://api.github.com/users/torkelo/followers","following_url":"https://api.github.com/users/torkelo/following{/other_user}","gists_url":"https://api.github.com/users/torkelo/gists{/gist_id}","starred_url":"https://api.github.com/users/torkelo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/torkelo/subscriptions","organizations_url":"https://api.github.com/users/torkelo/orgs","repos_url":"https://api.github.com/users/torkelo/repos","events_url":"https://api.github.com/users/torkelo/events{/privacy}","received_events_url":"https://api.github.com/users/torkelo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":70,"created_at":"2015-02-28T16:26:02Z","updated_at":"2016-02-11T02:10:14Z","closed_at":null,"body":"With the backend comes the possibility to have SQL data source. \r\n\r\nMy thinking is that when you add the data source you\r\n- db type (initially only mysql and postgres and sqlite3)\r\n- db connection details\r\n- specify a metric query template (basically a SQL query with params)\r\n- specify a annotation query template \r\n\r\nMaybe also an option to allow RAW SQL queries from the panel metric query interface. \r\n\r\nAny other ideas? "},"comment":{"url":"https://api.github.com/repos/grafana/grafana/issues/comments/182673031","html_url":"https://github.com/grafana/grafana/issues/1542#issuecomment-182673031","issue_url":"https://api.github.com/repos/grafana/grafana/issues/1542","id":182673031,"user":{"login":"mpmlj","id":6718777,"avatar_url":"https://avatars.githubusercontent.com/u/6718777?v=3","gravatar_id":"","url":"https://api.github.com/users/mpmlj","html_url":"https://github.com/mpmlj","followers_url":"https://api.github.com/users/mpmlj/followers","following_url":"https://api.github.com/users/mpmlj/following{/other_user}","gists_url":"https://api.github.com/users/mpmlj/gists{/gist_id}","starred_url":"https://api.github.com/users/mpmlj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mpmlj/subscriptions","organizations_url":"https://api.github.com/users/mpmlj/orgs","repos_url":"https://api.github.com/users/mpmlj/repos","events_url":"https://api.github.com/users/mpmlj/events{/privacy}","received_events_url":"https://api.github.com/users/mpmlj/received_events","type":"User","site_admin":false},"created_at":"2016-02-11T02:10:14Z","updated_at":"2016-02-11T02:10:14Z","body":"+1 Cassandra"}}