{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/625","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/625/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/625/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/625/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/625","id":160297688,"number":625,"title":"Add SQLCipher saved passwords","user":{"login":"revolter","id":5748627,"avatar_url":"https://avatars.githubusercontent.com/u/5748627?v=3","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},"labels":[{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/SQLCipher","name":"SQLCipher","color":"fbca44"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":37,"created_at":"2016-06-14T22:19:19Z","updated_at":"2016-07-14T12:55:32Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/pulls/625","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/625","diff_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/625.diff","patch_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/625.patch"},"body":"This PR adds the option to save a password per database file name and upon trying to open an encrypted database for which the password was saved in the Preferences, it opens up automatically, without the need for user input.\r\n\r\nFixed #486."},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/232657291","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/pull/625#issuecomment-232657291","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/625","id":232657291,"user":{"login":"justinclift","id":406299,"avatar_url":"https://avatars.githubusercontent.com/u/406299?v=3","gravatar_id":"","url":"https://api.github.com/users/justinclift","html_url":"https://github.com/justinclift","followers_url":"https://api.github.com/users/justinclift/followers","following_url":"https://api.github.com/users/justinclift/following{/other_user}","gists_url":"https://api.github.com/users/justinclift/gists{/gist_id}","starred_url":"https://api.github.com/users/justinclift/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinclift/subscriptions","organizations_url":"https://api.github.com/users/justinclift/orgs","repos_url":"https://api.github.com/users/justinclift/repos","events_url":"https://api.github.com/users/justinclift/events{/privacy}","received_events_url":"https://api.github.com/users/justinclift/received_events","type":"User","site_admin":false},"created_at":"2016-07-14T12:55:32Z","updated_at":"2016-07-14T12:55:32Z","body":"Ahhh, I probably explained the thought badly then. :smile:\r\n\r\nSo, imagine that the first time the user clicks the \"Add Password\" button, a dialog pops up and says something like:\r\n\r\n```\r\n   Hi, before storing your passwords we need to create a safe place to keep them.\r\n\r\n   We'll do that by creating an encrypted database in [some path name], and we'll\r\n   lock it with a master password of your selection.\r\n\r\n                                                    [OK][Cancel]\r\n```\r\n\r\nIf they click OK, then it asks for a password to use for encrypting this \"password vault\" database.\r\n\r\nThis \"password vault\" database is a simple SQLite database (with SQLCipher encryption), containing the fields you are showing in the images above:\r\n\r\n* Filename\r\n* Password\r\n* Page size\r\n\r\nWhen the user has given the \"master password\" to use, the code (in this PR) creates the database and encrypts it.\r\n\r\nFrom then on, when a user presses the \"Add Password\" button, the info gets stored into this database.\r\n\r\nIs that making sense so far?"}}
{"actor":{"display_login":"justinclift"}}