{"action":"created","issue":{"url":"https://api.github.com/repos/openhab/openhab/issues/2670","labels_url":"https://api.github.com/repos/openhab/openhab/issues/2670/labels{/name}","comments_url":"https://api.github.com/repos/openhab/openhab/issues/2670/comments","events_url":"https://api.github.com/repos/openhab/openhab/issues/2670/events","html_url":"https://github.com/openhab/openhab/pull/2670","id":83064518,"number":2670,"title":"H2 SQL Persistence","user":{"login":"cdjackson","id":1041475,"avatar_url":"https://avatars.githubusercontent.com/u/1041475?v=3","gravatar_id":"","url":"https://api.github.com/users/cdjackson","html_url":"https://github.com/cdjackson","followers_url":"https://api.github.com/users/cdjackson/followers","following_url":"https://api.github.com/users/cdjackson/following{/other_user}","gists_url":"https://api.github.com/users/cdjackson/gists{/gist_id}","starred_url":"https://api.github.com/users/cdjackson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdjackson/subscriptions","organizations_url":"https://api.github.com/users/cdjackson/orgs","repos_url":"https://api.github.com/users/cdjackson/repos","events_url":"https://api.github.com/users/cdjackson/events{/privacy}","received_events_url":"https://api.github.com/users/cdjackson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openhab/openhab/labels/awaiting-feedback","name":"awaiting-feedback","color":"fbca04"},{"url":"https://api.github.com/repos/openhab/openhab/labels/new-binding-action-service","name":"new-binding-action-service","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"cdjackson","id":1041475,"avatar_url":"https://avatars.githubusercontent.com/u/1041475?v=3","gravatar_id":"","url":"https://api.github.com/users/cdjackson","html_url":"https://github.com/cdjackson","followers_url":"https://api.github.com/users/cdjackson/followers","following_url":"https://api.github.com/users/cdjackson/following{/other_user}","gists_url":"https://api.github.com/users/cdjackson/gists{/gist_id}","starred_url":"https://api.github.com/users/cdjackson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdjackson/subscriptions","organizations_url":"https://api.github.com/users/cdjackson/orgs","repos_url":"https://api.github.com/users/cdjackson/repos","events_url":"https://api.github.com/users/cdjackson/events{/privacy}","received_events_url":"https://api.github.com/users/cdjackson/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/openhab/openhab/milestones/10","html_url":"https://github.com/openhab/openhab/milestones/1.8.0","labels_url":"https://api.github.com/repos/openhab/openhab/milestones/10/labels","id":1127272,"number":10,"title":"1.8.0","description":"","creator":{"login":"teichsta","id":2108636,"avatar_url":"https://avatars.githubusercontent.com/u/2108636?v=3","gravatar_id":"","url":"https://api.github.com/users/teichsta","html_url":"https://github.com/teichsta","followers_url":"https://api.github.com/users/teichsta/followers","following_url":"https://api.github.com/users/teichsta/following{/other_user}","gists_url":"https://api.github.com/users/teichsta/gists{/gist_id}","starred_url":"https://api.github.com/users/teichsta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teichsta/subscriptions","organizations_url":"https://api.github.com/users/teichsta/orgs","repos_url":"https://api.github.com/users/teichsta/repos","events_url":"https://api.github.com/users/teichsta/events{/privacy}","received_events_url":"https://api.github.com/users/teichsta/received_events","type":"User","site_admin":false},"open_issues":30,"closed_issues":46,"state":"open","created_at":"2015-05-24T06:23:20Z","updated_at":"2015-09-07T17:57:43Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2015-05-31T11:10:55Z","updated_at":"2015-09-09T10:03:01Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/openhab/openhab/pulls/2670","html_url":"https://github.com/openhab/openhab/pull/2670","diff_url":"https://github.com/openhab/openhab/pull/2670.diff","patch_url":"https://github.com/openhab/openhab/pull/2670.patch"},"body":"This is a simple, high performance embedded SQL persistence service. The only installation required is to put the JAR into the addons folder and add a h2sql.persist file (see wiki on the .persist files).\r\n\r\nThis requires further testing - I've tested it on a Linux box, and on a BeagleBone Black and performance looks good (better than mySQL server running on the same machine). I've not tested all item types, so any feedback is welcome - the schema might require some adjustment for some items...\r\n\r\n@teichsta - please don't merge this just yet."},"comment":{"url":"https://api.github.com/repos/openhab/openhab/issues/comments/138861834","html_url":"https://github.com/openhab/openhab/pull/2670#issuecomment-138861834","issue_url":"https://api.github.com/repos/openhab/openhab/issues/2670","id":138861834,"user":{"login":"mdbergmann","id":2143978,"avatar_url":"https://avatars.githubusercontent.com/u/2143978?v=3","gravatar_id":"","url":"https://api.github.com/users/mdbergmann","html_url":"https://github.com/mdbergmann","followers_url":"https://api.github.com/users/mdbergmann/followers","following_url":"https://api.github.com/users/mdbergmann/following{/other_user}","gists_url":"https://api.github.com/users/mdbergmann/gists{/gist_id}","starred_url":"https://api.github.com/users/mdbergmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdbergmann/subscriptions","organizations_url":"https://api.github.com/users/mdbergmann/orgs","repos_url":"https://api.github.com/users/mdbergmann/repos","events_url":"https://api.github.com/users/mdbergmann/events{/privacy}","received_events_url":"https://api.github.com/users/mdbergmann/received_events","type":"User","site_admin":false},"created_at":"2015-09-09T10:03:01Z","updated_at":"2015-09-09T10:03:01Z","body":"Hi Guys.\n\nA generic DBMS binding based on JDBC?\nI assume this requires quite a bit of work for customizations for each DBMS.\nIsn’t this what JPA or Hibernate already have done?\n\n\nManfred\n\n> Am 06.09.2015 um 17:03 schrieb Helmut Lehmeyer <notifications@github.com>:\n> \n> Hello @cdjackson, @teichsta ,\n> *sqlTypes are missing \"CALLITEM\" and \"LOCATIONITEM\".\n> *\"SWITCHITEM\" should be VARCHAR(3) because you get \"ON\" and \"OFF\" as String back. CHAR(3) we will get \"ON \" with an additional space.\n> (Thought I had changed this in Mysql-Service, but now it is back to CHAR(3))\n> \n> It seems H2 Binding is bases on an an older version of Mysql Binding, there are some more changes i think.\n> OpenHub gets some more redundancy in Persistence services with a new \"single-Database-Binding\" based on Mysql-Binding. @teichsta convinced me to take back my PostgreSQL Binding (also based on Mysql).\n> \n> You and me talked about a generic SQL Binding, which can be extended.\n> \n> So I have prepared a generic DBMS Binding (including H2), which is already working on my PC. \n> But it takes a few days to ripen, then I will introduce it ;-)\n> \n> Rgds\n> Helmut\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n\n"}}