{"action":"closed","number":288,"pull_request":{"url":"https://api.github.com/repos/fguillot/miniflux/pulls/288","id":26800094,"html_url":"https://github.com/fguillot/miniflux/pull/288","diff_url":"https://github.com/fguillot/miniflux/pull/288.diff","patch_url":"https://github.com/fguillot/miniflux/pull/288.patch","issue_url":"https://api.github.com/repos/fguillot/miniflux/issues/288","number":288,"state":"closed","locked":false,"title":"switch config table to key/value store, introduce frontend update, cleanup","user":{"login":"mkresin","id":4547948,"avatar_url":"https://avatars.githubusercontent.com/u/4547948?v=3","gravatar_id":"","url":"https://api.github.com/users/mkresin","html_url":"https://github.com/mkresin","followers_url":"https://api.github.com/users/mkresin/followers","following_url":"https://api.github.com/users/mkresin/following{/other_user}","gists_url":"https://api.github.com/users/mkresin/gists{/gist_id}","starred_url":"https://api.github.com/users/mkresin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkresin/subscriptions","organizations_url":"https://api.github.com/users/mkresin/orgs","repos_url":"https://api.github.com/users/mkresin/repos","events_url":"https://api.github.com/users/mkresin/events{/privacy}","received_events_url":"https://api.github.com/users/mkresin/received_events","type":"User","site_admin":false},"body":"Any opinion on this Frédéric? The config table had a lot of changes the last time. Which is especially bad with sqlite, as it's not possible to alter or drop columns. The used query is explained here: http://www.karlrixon.co.uk/writing/update-multiple-rows-with-different-values-and-a-single-sql-query/\r\n\r\nIf you agree with the changes, I will send a PR against the picoDB repo and force update this PR.\r\n\r\n","created_at":"2015-01-04T21:56:14Z","updated_at":"2015-01-28T04:42:23Z","closed_at":"2015-01-28T04:42:23Z","merged_at":null,"merge_commit_sha":"50759cc04d591fa7fa0980150a352959395a2bdd","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/fguillot/miniflux/pulls/288/commits","review_comments_url":"https://api.github.com/repos/fguillot/miniflux/pulls/288/comments","review_comment_url":"https://api.github.com/repos/fguillot/miniflux/pulls/comments/{number}","comments_url":"https://api.github.com/repos/fguillot/miniflux/issues/288/comments","statuses_url":"https://api.github.com/repos/fguillot/miniflux/statuses/d2cfc7fd1535afcec352c05c99a318cd48325734","head":{"label":"mkresin:master","ref":"master","sha":"d2cfc7fd1535afcec352c05c99a318cd48325734","user":{"login":"mkresin","id":4547948,"avatar_url":"https://avatars.githubusercontent.com/u/4547948?v=3","gravatar_id":"","url":"https://api.github.com/users/mkresin","html_url":"https://github.com/mkresin","followers_url":"https://api.github.com/users/mkresin/followers","following_url":"https://api.github.com/users/mkresin/following{/other_user}","gists_url":"https://api.github.com/users/mkresin/gists{/gist_id}","starred_url":"https://api.github.com/users/mkresin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkresin/subscriptions","organizations_url":"https://api.github.com/users/mkresin/orgs","repos_url":"https://api.github.com/users/mkresin/repos","events_url":"https://api.github.com/users/mkresin/events{/privacy}","received_events_url":"https://api.github.com/users/mkresin/received_events","type":"User","site_admin":false},"repo":{"id":27314528,"name":"miniflux","full_name":"mkresin/miniflux","owner":{"login":"mkresin","id":4547948,"avatar_url":"https://avatars.githubusercontent.com/u/4547948?v=3","gravatar_id":"","url":"https://api.github.com/users/mkresin","html_url":"https://github.com/mkresin","followers_url":"https://api.github.com/users/mkresin/followers","following_url":"https://api.github.com/users/mkresin/following{/other_user}","gists_url":"https://api.github.com/users/mkresin/gists{/gist_id}","starred_url":"https://api.github.com/users/mkresin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkresin/subscriptions","organizations_url":"https://api.github.com/users/mkresin/orgs","repos_url":"https://api.github.com/users/mkresin/repos","events_url":"https://api.github.com/users/mkresin/events{/privacy}","received_events_url":"https://api.github.com/users/mkresin/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/mkresin/miniflux","description":"Minimalist web-based RSS reader","fork":true,"url":"https://api.github.com/repos/mkresin/miniflux","forks_url":"https://api.github.com/repos/mkresin/miniflux/forks","keys_url":"https://api.github.com/repos/mkresin/miniflux/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mkresin/miniflux/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mkresin/miniflux/teams","hooks_url":"https://api.github.com/repos/mkresin/miniflux/hooks","issue_events_url":"https://api.github.com/repos/mkresin/miniflux/issues/events{/number}","events_url":"https://api.github.com/repos/mkresin/miniflux/events","assignees_url":"https://api.github.com/repos/mkresin/miniflux/assignees{/user}","branches_url":"https://api.github.com/repos/mkresin/miniflux/branches{/branch}","tags_url":"https://api.github.com/repos/mkresin/miniflux/tags","blobs_url":"https://api.github.com/repos/mkresin/miniflux/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mkresin/miniflux/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mkresin/miniflux/git/refs{/sha}","trees_url":"https://api.github.com/repos/mkresin/miniflux/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mkresin/miniflux/statuses/{sha}","languages_url":"https://api.github.com/repos/mkresin/miniflux/languages","stargazers_url":"https://api.github.com/repos/mkresin/miniflux/stargazers","contributors_url":"https://api.github.com/repos/mkresin/miniflux/contributors","subscribers_url":"https://api.github.com/repos/mkresin/miniflux/subscribers","subscription_url":"https://api.github.com/repos/mkresin/miniflux/subscription","commits_url":"https://api.github.com/repos/mkresin/miniflux/commits{/sha}","git_commits_url":"https://api.github.com/repos/mkresin/miniflux/git/commits{/sha}","comments_url":"https://api.github.com/repos/mkresin/miniflux/comments{/number}","issue_comment_url":"https://api.github.com/repos/mkresin/miniflux/issues/comments/{number}","contents_url":"https://api.github.com/repos/mkresin/miniflux/contents/{+path}","compare_url":"https://api.github.com/repos/mkresin/miniflux/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mkresin/miniflux/merges","archive_url":"https://api.github.com/repos/mkresin/miniflux/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mkresin/miniflux/downloads","issues_url":"https://api.github.com/repos/mkresin/miniflux/issues{/number}","pulls_url":"https://api.github.com/repos/mkresin/miniflux/pulls{/number}","milestones_url":"https://api.github.com/repos/mkresin/miniflux/milestones{/number}","notifications_url":"https://api.github.com/repos/mkresin/miniflux/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mkresin/miniflux/labels{/name}","releases_url":"https://api.github.com/repos/mkresin/miniflux/releases{/id}","created_at":"2014-11-29T20:45:14Z","updated_at":"2015-01-28T04:42:23Z","pushed_at":"2015-01-28T04:42:23Z","git_url":"git://github.com/mkresin/miniflux.git","ssh_url":"git@github.com:mkresin/miniflux.git","clone_url":"https://github.com/mkresin/miniflux.git","svn_url":"https://github.com/mkresin/miniflux","homepage":"http://miniflux.net/","size":6060,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"fguillot:master","ref":"master","sha":"d2cfc7fd1535afcec352c05c99a318cd48325734","user":{"login":"fguillot","id":323546,"avatar_url":"https://avatars.githubusercontent.com/u/323546?v=3","gravatar_id":"","url":"https://api.github.com/users/fguillot","html_url":"https://github.com/fguillot","followers_url":"https://api.github.com/users/fguillot/followers","following_url":"https://api.github.com/users/fguillot/following{/other_user}","gists_url":"https://api.github.com/users/fguillot/gists{/gist_id}","starred_url":"https://api.github.com/users/fguillot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fguillot/subscriptions","organizations_url":"https://api.github.com/users/fguillot/orgs","repos_url":"https://api.github.com/users/fguillot/repos","events_url":"https://api.github.com/users/fguillot/events{/privacy}","received_events_url":"https://api.github.com/users/fguillot/received_events","type":"User","site_admin":false},"repo":{"id":8260546,"name":"miniflux","full_name":"fguillot/miniflux","owner":{"login":"fguillot","id":323546,"avatar_url":"https://avatars.githubusercontent.com/u/323546?v=3","gravatar_id":"","url":"https://api.github.com/users/fguillot","html_url":"https://github.com/fguillot","followers_url":"https://api.github.com/users/fguillot/followers","following_url":"https://api.github.com/users/fguillot/following{/other_user}","gists_url":"https://api.github.com/users/fguillot/gists{/gist_id}","starred_url":"https://api.github.com/users/fguillot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fguillot/subscriptions","organizations_url":"https://api.github.com/users/fguillot/orgs","repos_url":"https://api.github.com/users/fguillot/repos","events_url":"https://api.github.com/users/fguillot/events{/privacy}","received_events_url":"https://api.github.com/users/fguillot/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/fguillot/miniflux","description":"Minimalist web-based RSS reader","fork":false,"url":"https://api.github.com/repos/fguillot/miniflux","forks_url":"https://api.github.com/repos/fguillot/miniflux/forks","keys_url":"https://api.github.com/repos/fguillot/miniflux/keys{/key_id}","collaborators_url":"https://api.github.com/repos/fguillot/miniflux/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/fguillot/miniflux/teams","hooks_url":"https://api.github.com/repos/fguillot/miniflux/hooks","issue_events_url":"https://api.github.com/repos/fguillot/miniflux/issues/events{/number}","events_url":"https://api.github.com/repos/fguillot/miniflux/events","assignees_url":"https://api.github.com/repos/fguillot/miniflux/assignees{/user}","branches_url":"https://api.github.com/repos/fguillot/miniflux/branches{/branch}","tags_url":"https://api.github.com/repos/fguillot/miniflux/tags","blobs_url":"https://api.github.com/repos/fguillot/miniflux/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/fguillot/miniflux/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/fguillot/miniflux/git/refs{/sha}","trees_url":"https://api.github.com/repos/fguillot/miniflux/git/trees{/sha}","statuses_url":"https://api.github.com/repos/fguillot/miniflux/statuses/{sha}","languages_url":"https://api.github.com/repos/fguillot/miniflux/languages","stargazers_url":"https://api.github.com/repos/fguillot/miniflux/stargazers","contributors_url":"https://api.github.com/repos/fguillot/miniflux/contributors","subscribers_url":"https://api.github.com/repos/fguillot/miniflux/subscribers","subscription_url":"https://api.github.com/repos/fguillot/miniflux/subscription","commits_url":"https://api.github.com/repos/fguillot/miniflux/commits{/sha}","git_commits_url":"https://api.github.com/repos/fguillot/miniflux/git/commits{/sha}","comments_url":"https://api.github.com/repos/fguillot/miniflux/comments{/number}","issue_comment_url":"https://api.github.com/repos/fguillot/miniflux/issues/comments/{number}","contents_url":"https://api.github.com/repos/fguillot/miniflux/contents/{+path}","compare_url":"https://api.github.com/repos/fguillot/miniflux/compare/{base}...{head}","merges_url":"https://api.github.com/repos/fguillot/miniflux/merges","archive_url":"https://api.github.com/repos/fguillot/miniflux/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/fguillot/miniflux/downloads","issues_url":"https://api.github.com/repos/fguillot/miniflux/issues{/number}","pulls_url":"https://api.github.com/repos/fguillot/miniflux/pulls{/number}","milestones_url":"https://api.github.com/repos/fguillot/miniflux/milestones{/number}","notifications_url":"https://api.github.com/repos/fguillot/miniflux/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/fguillot/miniflux/labels{/name}","releases_url":"https://api.github.com/repos/fguillot/miniflux/releases{/id}","created_at":"2013-02-18T02:49:14Z","updated_at":"2015-01-28T01:13:21Z","pushed_at":"2015-01-28T01:13:20Z","git_url":"git://github.com/fguillot/miniflux.git","ssh_url":"git@github.com:fguillot/miniflux.git","clone_url":"https://github.com/fguillot/miniflux.git","svn_url":"https://github.com/fguillot/miniflux","homepage":"http://miniflux.net/","size":10567,"stargazers_count":364,"watchers_count":364,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":63,"mirror_url":null,"open_issues_count":25,"forks":63,"open_issues":25,"watchers":364,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/fguillot/miniflux/pulls/288"},"html":{"href":"https://github.com/fguillot/miniflux/pull/288"},"issue":{"href":"https://api.github.com/repos/fguillot/miniflux/issues/288"},"comments":{"href":"https://api.github.com/repos/fguillot/miniflux/issues/288/comments"},"review_comments":{"href":"https://api.github.com/repos/fguillot/miniflux/pulls/288/comments"},"review_comment":{"href":"https://api.github.com/repos/fguillot/miniflux/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/fguillot/miniflux/pulls/288/commits"},"statuses":{"href":"https://api.github.com/repos/fguillot/miniflux/statuses/d2cfc7fd1535afcec352c05c99a318cd48325734"}},"merged":false,"mergeable":false,"mergeable_state":"dirty","merged_by":null,"comments":2,"review_comments":0,"commits":0,"additions":0,"deletions":0,"changed_files":0}}