{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1173","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1173/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1173/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1173/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1173","id":265566388,"number":1173,"title":"JSON mode for cell editor","user":{"login":"wmertens","id":54934,"avatar_url":"https://avatars2.githubusercontent.com/u/54934?v=4","gravatar_id":"","url":"https://api.github.com/users/wmertens","html_url":"https://github.com/wmertens","followers_url":"https://api.github.com/users/wmertens/followers","following_url":"https://api.github.com/users/wmertens/following{/other_user}","gists_url":"https://api.github.com/users/wmertens/gists{/gist_id}","starred_url":"https://api.github.com/users/wmertens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wmertens/subscriptions","organizations_url":"https://api.github.com/users/wmertens/orgs","repos_url":"https://api.github.com/users/wmertens/repos","events_url":"https://api.github.com/users/wmertens/events{/privacy}","received_events_url":"https://api.github.com/users/wmertens/received_events","type":"User","site_admin":false},"labels":[{"id":96964810,"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"mgrojo","id":13812910,"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},"assignees":[{"login":"mgrojo","id":13812910,"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}],"milestone":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/milestones/13","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/milestone/13","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/milestones/13/labels","id":2672383,"number":13,"title":"3.11.0 - Where we take over the world! :D","description":"Muaa Haaa Haaa 😀","creator":{"login":"justinclift","id":406299,"avatar_url":"https://avatars2.githubusercontent.com/u/406299?v=4","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},"open_issues":13,"closed_issues":30,"state":"open","created_at":"2017-07-31T21:27:05Z","updated_at":"2017-11-22T12:52:24Z","due_on":"2017-11-30T08:00:00Z","closed_at":null},"comments":14,"created_at":"2017-10-15T11:53:59Z","updated_at":"2017-11-23T22:29:56Z","closed_at":null,"author_association":"NONE","body":"### Details for the issue\r\n\r\nIt would be really handy if the cell formatter could handle JSON, much like for example http://jsoneditoronline.org/\r\n\r\n### Useful extra information\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [ ] DB4S has a bug\r\n- [x] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [x] Mac OS: ( _version:_ 10.13 )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [x] Other: 3.10.99\r\n\r\n#### I have also:\r\n\r\n- [x] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/346704842","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1173#issuecomment-346704842","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/1173","id":346704842,"user":{"login":"mgrojo","id":13812910,"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},"created_at":"2017-11-23T22:29:56Z","updated_at":"2017-11-23T22:29:56Z","author_association":"CONTRIBUTOR","body":"Hi, @wmertens, thanks for the feedback!\r\n\r\n> * [ ] IMHO, indent/compact can be the default. As long as you don't save, it doesn't make a difference anyway.\r\n\r\nI think that letting the user discover the preference is the safest approach, otherwise we can change his/her own format inadvertently.\r\n\r\n> * [ ] It would be great if text values are automatically checked for being parseable as JSON (if they are less than e.g. 100KB), and then the editor automatically switches to JSON.\r\n\r\nIt would make sense, but currently the mode is not changing automatically, even when image and binary data is already detected. Could be considered in a global way if nobody sees a problem for that.\r\n\r\n> * [ ] If using the `json()` function, minification and verification is done automatically by sqlite:\r\n\r\nI've used the Qt JSON class because Qt is already a requirement. On the other hand, we cannot assume that a given extension is available.\r\n\r\n> * [ ] Folding seems to have issues: folding an array with a nested array will fold to the close of the nested array: \r\n\r\nSeems a Scintilla issue. I cannot reproduced your problem. Could you provide the full JSON data? I've found this patch for a folding issue in the JSON lexer, but seems to be another one. We have the version previous to the patch. https://groups.google.com/forum/#!topic/scintilla-interest/w4sW3sM6Cek\r\n\r\n"}}
{"actor":{"display_login":"mgrojo"}}