{"action":"closed","issue":{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/814","repository_url":"https://api.github.com/repos/couchbase/couchbase-lite-android","labels_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/814/labels{/name}","comments_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/814/comments","events_url":"https://api.github.com/repos/couchbase/couchbase-lite-android/issues/814/events","html_url":"https://github.com/couchbase/couchbase-lite-android/issues/814","id":141892642,"number":814,"title":"Arquitecture and performance NoSQL vs SQLite","user":{"login":"denebchorny","id":13120695,"avatar_url":"https://avatars.githubusercontent.com/u/13120695?v=3","gravatar_id":"","url":"https://api.github.com/users/denebchorny","html_url":"https://github.com/denebchorny","followers_url":"https://api.github.com/users/denebchorny/followers","following_url":"https://api.github.com/users/denebchorny/following{/other_user}","gists_url":"https://api.github.com/users/denebchorny/gists{/gist_id}","starred_url":"https://api.github.com/users/denebchorny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denebchorny/subscriptions","organizations_url":"https://api.github.com/users/denebchorny/orgs","repos_url":"https://api.github.com/users/denebchorny/repos","events_url":"https://api.github.com/users/denebchorny/events{/privacy}","received_events_url":"https://api.github.com/users/denebchorny/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/couchbase/couchbase-lite-android/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-18T15:07:26Z","updated_at":"2016-03-18T20:35:15Z","closed_at":"2016-03-18T20:35:15Z","body":"Hi Couchbase team,\r\nSorry for boder you, but, I am trying to make an investigation for my organization about NoSQL and SQLite (as deep as I can for a decision making). I hope you help me. Meaby the answer could help someone else.\r\n\r\nThe first question I did was \"Why NoSQL in the phone?\". This is easy to answer. \r\nAs we are using a document-oriented database, using the same engine in the phone could:\r\n\r\n1) This reduces decomposition time document to convert a non-relational structure to a relational structure to the case of using SQLite.\r\n\r\n2) This reduces efforts to make migration database whenever the application requires changes its attributes. And even more when the application is constantly changing.\r\n\r\nNow if android natively has an engine SQLite, I wonder Why has not one of natively documents?\r\n\r\nThis is why I want to know the following to have a better criteria between the two types of database:\r\n\r\n1) If I emit a document in a view, does the view duplicate the document?\r\n2) Does the revisions duplicate the documents?\r\n\r\nThanks in advance.\r\n\r\nDeneb Chorny"}}