{"action":"created","comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/comments/197084767","pull_request_review_id":130755388,"id":197084767,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5NzA4NDc2Nw==","diff_hunk":"@@ -13,6 +13,7 @@\n \n struct sqlite3;\n class CipherDialog;\n+class CipherSettings;","path":"src/sqlitedb.h","position":4,"original_position":4,"commit_id":"f9db3dc1f0be8d3b3677ab95fb2b33daeee80bef","original_commit_id":"f9db3dc1f0be8d3b3677ab95fb2b33daeee80bef","user":{"login":"MKleusberg","id":3153504,"node_id":"MDQ6VXNlcjMxNTM1MDQ=","avatar_url":"https://avatars3.githubusercontent.com/u/3153504?v=4","gravatar_id":"","url":"https://api.github.com/users/MKleusberg","html_url":"https://github.com/MKleusberg","followers_url":"https://api.github.com/users/MKleusberg/followers","following_url":"https://api.github.com/users/MKleusberg/following{/other_user}","gists_url":"https://api.github.com/users/MKleusberg/gists{/gist_id}","starred_url":"https://api.github.com/users/MKleusberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MKleusberg/subscriptions","organizations_url":"https://api.github.com/users/MKleusberg/orgs","repos_url":"https://api.github.com/users/MKleusberg/repos","events_url":"https://api.github.com/users/MKleusberg/events{/privacy}","received_events_url":"https://api.github.com/users/MKleusberg/received_events","type":"User","site_admin":false},"body":"You can delete the old ```class CipherDialog;``` line here.","created_at":"2018-06-21T10:28:56Z","updated_at":"2018-06-21T10:54:13Z","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404#discussion_r197084767","pull_request_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/comments/197084767"},"html":{"href":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404#discussion_r197084767"},"pull_request":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404"}}},"pull_request":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404","id":192219195,"node_id":"MDExOlB1bGxSZXF1ZXN0MTkyMjE5MTk1","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404","diff_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404.diff","patch_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404.patch","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1404","number":1404,"state":"open","locked":false,"title":"Add automatic crypted databases open via dotenvs","user":{"login":"revolter","id":5748627,"node_id":"MDQ6VXNlcjU3NDg2Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5748627?v=4","gravatar_id":"","url":"https://api.github.com/users/revolter","html_url":"https://github.com/revolter","followers_url":"https://api.github.com/users/revolter/followers","following_url":"https://api.github.com/users/revolter/following{/other_user}","gists_url":"https://api.github.com/users/revolter/gists{/gist_id}","starred_url":"https://api.github.com/users/revolter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolter/subscriptions","organizations_url":"https://api.github.com/users/revolter/orgs","repos_url":"https://api.github.com/users/revolter/repos","events_url":"https://api.github.com/users/revolter/events{/privacy}","received_events_url":"https://api.github.com/users/revolter/received_events","type":"User","site_admin":false},"body":"This adds support for `.env` files next to the crypted databases that\r\nare to be opened that contains the needed cipher settings.\r\n\r\nThe only required one is the plain-text password as a value for the key\r\nwith the name of the database like this:\r\n\r\n    myCryptedDatabase.sqlite = MyPassword\r\n\r\nThis way, databases with a different extension are supported too:\r\n\r\n    myCryptedDatabase.db = MyPassword\r\n\r\nYou can also specify a custom page size adding a different line\r\n(anywhere in the file) like this:\r\n\r\n    myCryptedDatabase.db_pageSize = 2048\r\n\r\nIf not specified, `1024` is used.\r\n\r\nYou can also specify the format of the specified key using the\r\nassociated integer id:\r\n\r\n    anotherCryptedDatabase.sqlite = 0xCAFEBABE\r\n    anotherCryptedDatabase.sqlite_keyFormat = 1\r\n\r\nwhere `1` means a Raw key. If not specified, `0` is used, which means a\r\nsimple text Passphrase.\r\n\r\nDotenv files (`.env`) are already used on other platforms and by\r\ndifferent tools to manage environment variables, and it's recommended\r\nto be ignored from version control systems, so they won't leak.\r\n\r\nRelated to #625.","created_at":"2018-06-02T21:43:55Z","updated_at":"2018-06-21T10:54:13Z","closed_at":null,"merged_at":null,"merge_commit_sha":"bde92de6fbfca3184574e58ca81018fb485da16c","assignee":null,"assignees":[],"requested_reviewers":[{"login":"mgrojo","id":13812910,"node_id":"MDQ6VXNlcjEzODEyOTEw","avatar_url":"https://avatars2.githubusercontent.com/u/13812910?v=4","gravatar_id":"","url":"https://api.github.com/users/mgrojo","html_url":"https://github.com/mgrojo","followers_url":"https://api.github.com/users/mgrojo/followers","following_url":"https://api.github.com/users/mgrojo/following{/other_user}","gists_url":"https://api.github.com/users/mgrojo/gists{/gist_id}","starred_url":"https://api.github.com/users/mgrojo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mgrojo/subscriptions","organizations_url":"https://api.github.com/users/mgrojo/orgs","repos_url":"https://api.github.com/users/mgrojo/repos","events_url":"https://api.github.com/users/mgrojo/events{/privacy}","received_events_url":"https://api.github.com/users/mgrojo/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[{"id":96964810,"node_id":"MDU6TGFiZWw5Njk2NDgxMA==","url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"milestone":null,"commits_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404/commits","review_comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404/comments","review_comment_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/comments{/number}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1404/comments","statuses_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/statuses/f9db3dc1f0be8d3b3677ab95fb2b33daeee80bef","head":{"label":"revolter:feature/sqlcipher-passwords","ref":"feature/sqlcipher-passwords","sha":"f9db3dc1f0be8d3b3677ab95fb2b33daeee80bef","user":{"login":"revolter","id":5748627,"node_id":"MDQ6VXNlcjU3NDg2Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5748627?v=4","gravatar_id":"","url":"https://api.github.com/users/revolter","html_url":"https://github.com/revolter","followers_url":"https://api.github.com/users/revolter/followers","following_url":"https://api.github.com/users/revolter/following{/other_user}","gists_url":"https://api.github.com/users/revolter/gists{/gist_id}","starred_url":"https://api.github.com/users/revolter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolter/subscriptions","organizations_url":"https://api.github.com/users/revolter/orgs","repos_url":"https://api.github.com/users/revolter/repos","events_url":"https://api.github.com/users/revolter/events{/privacy}","received_events_url":"https://api.github.com/users/revolter/received_events","type":"User","site_admin":false},"repo":{"id":52259848,"node_id":"MDEwOlJlcG9zaXRvcnk1MjI1OTg0OA==","name":"sqlitebrowser","full_name":"revolter/sqlitebrowser","owner":{"login":"revolter","id":5748627,"node_id":"MDQ6VXNlcjU3NDg2Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/5748627?v=4","gravatar_id":"","url":"https://api.github.com/users/revolter","html_url":"https://github.com/revolter","followers_url":"https://api.github.com/users/revolter/followers","following_url":"https://api.github.com/users/revolter/following{/other_user}","gists_url":"https://api.github.com/users/revolter/gists{/gist_id}","starred_url":"https://api.github.com/users/revolter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/revolter/subscriptions","organizations_url":"https://api.github.com/users/revolter/orgs","repos_url":"https://api.github.com/users/revolter/repos","events_url":"https://api.github.com/users/revolter/events{/privacy}","received_events_url":"https://api.github.com/users/revolter/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/revolter/sqlitebrowser","description":"Official home of the DB Browser for SQLite (DB4S) project. Previously known as \"SQLite Database Browser\" and \"Database Browser for SQLite\". Website at: ","fork":true,"url":"https://api.github.com/repos/revolter/sqlitebrowser","forks_url":"https://api.github.com/repos/revolter/sqlitebrowser/forks","keys_url":"https://api.github.com/repos/revolter/sqlitebrowser/keys{/key_id}","collaborators_url":"https://api.github.com/repos/revolter/sqlitebrowser/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/revolter/sqlitebrowser/teams","hooks_url":"https://api.github.com/repos/revolter/sqlitebrowser/hooks","issue_events_url":"https://api.github.com/repos/revolter/sqlitebrowser/issues/events{/number}","events_url":"https://api.github.com/repos/revolter/sqlitebrowser/events","assignees_url":"https://api.github.com/repos/revolter/sqlitebrowser/assignees{/user}","branches_url":"https://api.github.com/repos/revolter/sqlitebrowser/branches{/branch}","tags_url":"https://api.github.com/repos/revolter/sqlitebrowser/tags","blobs_url":"https://api.github.com/repos/revolter/sqlitebrowser/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/revolter/sqlitebrowser/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/revolter/sqlitebrowser/git/refs{/sha}","trees_url":"https://api.github.com/repos/revolter/sqlitebrowser/git/trees{/sha}","statuses_url":"https://api.github.com/repos/revolter/sqlitebrowser/statuses/{sha}","languages_url":"https://api.github.com/repos/revolter/sqlitebrowser/languages","stargazers_url":"https://api.github.com/repos/revolter/sqlitebrowser/stargazers","contributors_url":"https://api.github.com/repos/revolter/sqlitebrowser/contributors","subscribers_url":"https://api.github.com/repos/revolter/sqlitebrowser/subscribers","subscription_url":"https://api.github.com/repos/revolter/sqlitebrowser/subscription","commits_url":"https://api.github.com/repos/revolter/sqlitebrowser/commits{/sha}","git_commits_url":"https://api.github.com/repos/revolter/sqlitebrowser/git/commits{/sha}","comments_url":"https://api.github.com/repos/revolter/sqlitebrowser/comments{/number}","issue_comment_url":"https://api.github.com/repos/revolter/sqlitebrowser/issues/comments{/number}","contents_url":"https://api.github.com/repos/revolter/sqlitebrowser/contents/{+path}","compare_url":"https://api.github.com/repos/revolter/sqlitebrowser/compare/{base}...{head}","merges_url":"https://api.github.com/repos/revolter/sqlitebrowser/merges","archive_url":"https://api.github.com/repos/revolter/sqlitebrowser/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/revolter/sqlitebrowser/downloads","issues_url":"https://api.github.com/repos/revolter/sqlitebrowser/issues{/number}","pulls_url":"https://api.github.com/repos/revolter/sqlitebrowser/pulls{/number}","milestones_url":"https://api.github.com/repos/revolter/sqlitebrowser/milestones{/number}","notifications_url":"https://api.github.com/repos/revolter/sqlitebrowser/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/revolter/sqlitebrowser/labels{/name}","releases_url":"https://api.github.com/repos/revolter/sqlitebrowser/releases{/id}","deployments_url":"https://api.github.com/repos/revolter/sqlitebrowser/deployments","created_at":"2016-02-22T08:51:02Z","updated_at":"2018-06-09T13:47:12Z","pushed_at":"2018-06-10T08:43:19Z","git_url":"git://github.com/revolter/sqlitebrowser.git","ssh_url":"git@github.com:revolter/sqlitebrowser.git","clone_url":"https://github.com/revolter/sqlitebrowser.git","svn_url":"https://github.com/revolter/sqlitebrowser","homepage":"http://sqlitebrowser.org","size":12822,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"sqlitebrowser:master","ref":"master","sha":"48d3cc6c7e25de4e5f7616e98b70e50408175231","user":{"login":"sqlitebrowser","id":7454271,"node_id":"MDEyOk9yZ2FuaXphdGlvbjc0NTQyNzE=","avatar_url":"https://avatars2.githubusercontent.com/u/7454271?v=4","gravatar_id":"","url":"https://api.github.com/users/sqlitebrowser","html_url":"https://github.com/sqlitebrowser","followers_url":"https://api.github.com/users/sqlitebrowser/followers","following_url":"https://api.github.com/users/sqlitebrowser/following{/other_user}","gists_url":"https://api.github.com/users/sqlitebrowser/gists{/gist_id}","starred_url":"https://api.github.com/users/sqlitebrowser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sqlitebrowser/subscriptions","organizations_url":"https://api.github.com/users/sqlitebrowser/orgs","repos_url":"https://api.github.com/users/sqlitebrowser/repos","events_url":"https://api.github.com/users/sqlitebrowser/events{/privacy}","received_events_url":"https://api.github.com/users/sqlitebrowser/received_events","type":"Organization","site_admin":false},"repo":{"id":19416551,"node_id":"MDEwOlJlcG9zaXRvcnkxOTQxNjU1MQ==","name":"sqlitebrowser","full_name":"sqlitebrowser/sqlitebrowser","owner":{"login":"sqlitebrowser","id":7454271,"node_id":"MDEyOk9yZ2FuaXphdGlvbjc0NTQyNzE=","avatar_url":"https://avatars2.githubusercontent.com/u/7454271?v=4","gravatar_id":"","url":"https://api.github.com/users/sqlitebrowser","html_url":"https://github.com/sqlitebrowser","followers_url":"https://api.github.com/users/sqlitebrowser/followers","following_url":"https://api.github.com/users/sqlitebrowser/following{/other_user}","gists_url":"https://api.github.com/users/sqlitebrowser/gists{/gist_id}","starred_url":"https://api.github.com/users/sqlitebrowser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sqlitebrowser/subscriptions","organizations_url":"https://api.github.com/users/sqlitebrowser/orgs","repos_url":"https://api.github.com/users/sqlitebrowser/repos","events_url":"https://api.github.com/users/sqlitebrowser/events{/privacy}","received_events_url":"https://api.github.com/users/sqlitebrowser/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sqlitebrowser/sqlitebrowser","description":"Official home of the DB Browser for SQLite (DB4S) project. Previously known as \"SQLite Database Browser\" and \"Database Browser for SQLite\". Website at: ","fork":false,"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","forks_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/forks","keys_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/teams","hooks_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/hooks","issue_events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/events{/number}","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/events","assignees_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/assignees{/user}","branches_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/branches{/branch}","tags_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/tags","blobs_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/git/refs{/sha}","trees_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/statuses/{sha}","languages_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/languages","stargazers_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/stargazers","contributors_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/contributors","subscribers_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/subscribers","subscription_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/subscription","commits_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/commits{/sha}","git_commits_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/git/commits{/sha}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/comments{/number}","issue_comment_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments{/number}","contents_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/contents/{+path}","compare_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/merges","archive_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/downloads","issues_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues{/number}","pulls_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls{/number}","milestones_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/milestones{/number}","notifications_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels{/name}","releases_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/releases{/id}","deployments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/deployments","created_at":"2014-05-04T01:54:44Z","updated_at":"2018-06-21T09:52:52Z","pushed_at":"2018-06-21T09:53:10Z","git_url":"git://github.com/sqlitebrowser/sqlitebrowser.git","ssh_url":"git@github.com:sqlitebrowser/sqlitebrowser.git","clone_url":"https://github.com/sqlitebrowser/sqlitebrowser.git","svn_url":"https://github.com/sqlitebrowser/sqlitebrowser","homepage":"https://sqlitebrowser.org","size":13192,"stargazers_count":8880,"watchers_count":8880,"language":"C++","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1071,"mirror_url":null,"archived":false,"open_issues_count":285,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":1071,"open_issues":285,"watchers":8880,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404"},"html":{"href":"https://github.com/sqlitebrowser/sqlitebrowser/pull/1404"},"issue":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1404"},"comments":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1404/comments"},"review_comments":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404/comments"},"review_comment":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/1404/commits"},"statuses":{"href":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/statuses/f9db3dc1f0be8d3b3677ab95fb2b33daeee80bef"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"MKleusberg"}}