{"id":346,"date":"2016-02-16T12:18:03","date_gmt":"2016-02-16T11:18:03","guid":{"rendered":"https:\/\/mokrzycki.eu\/blog\/?p=346"},"modified":"2018-12-04T15:41:19","modified_gmt":"2018-12-04T14:41:19","slug":"simple-pulling-database-sqlite-to-desktop-and-preview-it","status":"publish","type":"post","link":"https:\/\/mokrzycki.eu\/blog\/2016\/02\/16\/simple-pulling-database-sqlite-to-desktop-and-preview-it\/","title":{"rendered":"Simple pulling database sqlite to desktop and preview it"},"content":{"rendered":"<p>All what we need is to make few steps:<\/p>\n<ol>\n<li>Add in our project this line to output in log current path to database\n<pre>Log.d(TAG, \"onCreate db: \" +  context.getDatabasePath(\"mydatabase.db\"));<\/pre>\n<\/li>\n<li>Create simple batch command to pull database (afik root is no needed)\n<pre>adb pull \"\/data\/data\/com.example.app\/databases\/mydatabase.db\" mydatabase_%date%.db.sqlite<\/pre>\n<\/li>\n<li>Download <a href=\"https:\/\/addons.mozilla.org\/pl\/firefox\/addon\/sqlite-manager\/\" target=\"_blank\" rel=\"noopener\">SQLiteManager <\/a> to firefox, run it, open our sqlite database<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38.png\" rel=\"attachment wp-att-347\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-347 size-full\" src=\"https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38.png\" alt=\"Zrzut ekranu 2016-02-16 12.15.38\" width=\"1903\" height=\"331\" srcset=\"https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38.png 1903w, https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38-300x52.png 300w, https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38-768x134.png 768w, https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38-1024x178.png 1024w, https:\/\/mokrzycki.eu\/blog\/wp-content\/uploads\/2016\/02\/Zrzut-ekranu-2016-02-16-12.15.38-656x114.png 656w\" sizes=\"(max-width: 1903px) 100vw, 1903px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Good luck!<\/p>\n<div id=\"link64_adl_tabid\" style=\"display: none;\" data-url=\"https:\/\/mokrzycki.eu\/blog\/wp-admin\/post.php?post=346&amp;action=edit\">405<\/div>\n","protected":false},"excerpt":{"rendered":"<p>All what we need is to make few steps: Add in our project this line&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[500],"tags":[246,5,249,11,247,248,245,18,244],"_links":{"self":[{"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/posts\/346"}],"collection":[{"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/comments?post=346"}],"version-history":[{"count":4,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"predecessor-version":[{"id":720,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/posts\/346\/revisions\/720"}],"wp:attachment":[{"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mokrzycki.eu\/blog\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}