{"id":1526,"date":"2015-03-25T00:28:02","date_gmt":"2015-03-24T18:58:02","guid":{"rendered":"https:\/\/www.innovationm.com\/blog\/?p=1526"},"modified":"2015-03-25T00:34:49","modified_gmt":"2015-03-24T19:04:49","slug":"android-database-version-stored-in-database-file-header","status":"publish","type":"post","link":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/","title":{"rendered":"Android – Database version stored in Database file header"},"content":{"rendered":"

We specify a version of database in\u00a0SQLiteOpenHelper constructor. Where is this version stored in database? This version is used while upgrading the database to higher versions.<\/p>\n

It is stored in Database file header as user_version<\/strong> number. See below:<\/p>\n

Code<\/strong>
\n\"InnovationM<\/a><\/p>\n

SQLite Maestro Tool<\/strong>
\n\"InnovationM<\/a><\/p>\n

Database header description<\/strong>
\n\"InnovationM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

We specify a version of database in\u00a0SQLiteOpenHelper constructor. Where is this version stored in database? This version is used while upgrading the database to higher versions. It is stored in Database file header as user_version number. See below: Code SQLite Maestro Tool Database header description<\/p>\n","protected":false},"author":3,"featured_media":1527,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,71,8],"tags":[159,149,14,165],"class_list":["post-1526","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-android","category-mobile","category-mobile-architecture-and-design","tag-android","tag-database","tag-innovationm","tag-mobile"],"yoast_head":"\nAndroid - Database version stored in Database file header - InnovationM - Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Android - Database version stored in Database file header - InnovationM - Blog\" \/>\n<meta property=\"og:description\" content=\"We specify a version of database in\u00a0SQLiteOpenHelper constructor. Where is this version stored in database? This version is used while upgrading the database to higher versions. It is stored in Database file header as user_version number. See below: Code SQLite Maestro Tool Database header description\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/\" \/>\n<meta property=\"og:site_name\" content=\"InnovationM - Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-24T18:58:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-03-24T19:04:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png\" \/>\n\t<meta property=\"og:image:width\" content=\"473\" \/>\n\t<meta property=\"og:image:height\" content=\"113\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Manish Seth\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manish Seth\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/\"},\"author\":{\"name\":\"Manish Seth\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/#\\\/schema\\\/person\\\/03f59a9465a9f03b551985392f877ae8\"},\"headline\":\"Android – Database version stored in Database file header\",\"datePublished\":\"2015-03-24T18:58:02+00:00\",\"dateModified\":\"2015-03-24T19:04:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/\"},\"wordCount\":56,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/InnovationM-Android-Database-Version-Code.png\",\"keywords\":[\"Android\",\"Database\",\"InnovationM\",\"Mobile\"],\"articleSection\":[\"Android\",\"Mobile\",\"Mobile Architecture and Design\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/\",\"url\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/\",\"name\":\"Android - Database version stored in Database file header - InnovationM - Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/InnovationM-Android-Database-Version-Code.png\",\"datePublished\":\"2015-03-24T18:58:02+00:00\",\"dateModified\":\"2015-03-24T19:04:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/#\\\/schema\\\/person\\\/03f59a9465a9f03b551985392f877ae8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/InnovationM-Android-Database-Version-Code.png\",\"contentUrl\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/InnovationM-Android-Database-Version-Code.png\",\"width\":473,\"height\":113,\"caption\":\"InnovationM Android Database Version Code\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/android-database-version-stored-in-database-file-header\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Android – Database version stored in Database file header\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/\",\"name\":\"InnovationM - Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/#\\\/schema\\\/person\\\/03f59a9465a9f03b551985392f877ae8\",\"name\":\"Manish Seth\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g\",\"caption\":\"Manish Seth\"},\"sameAs\":[\"http:\\\/\\\/www.innovationm.com\\\/\"],\"url\":\"https:\\\/\\\/www.innovationm.com\\\/blog\\\/author\\\/manish-seth\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Android - Database version stored in Database file header - InnovationM - Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/","og_locale":"en_US","og_type":"article","og_title":"Android - Database version stored in Database file header - InnovationM - Blog","og_description":"We specify a version of database in\u00a0SQLiteOpenHelper constructor. Where is this version stored in database? This version is used while upgrading the database to higher versions. It is stored in Database file header as user_version number. See below: Code SQLite Maestro Tool Database header description","og_url":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/","og_site_name":"InnovationM - Blog","article_published_time":"2015-03-24T18:58:02+00:00","article_modified_time":"2015-03-24T19:04:49+00:00","og_image":[{"width":473,"height":113,"url":"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png","type":"image\/png"}],"author":"Manish Seth","twitter_misc":{"Written by":"Manish Seth"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#article","isPartOf":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/"},"author":{"name":"Manish Seth","@id":"https:\/\/www.innovationm.com\/blog\/#\/schema\/person\/03f59a9465a9f03b551985392f877ae8"},"headline":"Android – Database version stored in Database file header","datePublished":"2015-03-24T18:58:02+00:00","dateModified":"2015-03-24T19:04:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/"},"wordCount":56,"commentCount":0,"image":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#primaryimage"},"thumbnailUrl":"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png","keywords":["Android","Database","InnovationM","Mobile"],"articleSection":["Android","Mobile","Mobile Architecture and Design"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/","url":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/","name":"Android - Database version stored in Database file header - InnovationM - Blog","isPartOf":{"@id":"https:\/\/www.innovationm.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#primaryimage"},"image":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#primaryimage"},"thumbnailUrl":"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png","datePublished":"2015-03-24T18:58:02+00:00","dateModified":"2015-03-24T19:04:49+00:00","author":{"@id":"https:\/\/www.innovationm.com\/blog\/#\/schema\/person\/03f59a9465a9f03b551985392f877ae8"},"breadcrumb":{"@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#primaryimage","url":"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png","contentUrl":"https:\/\/www.innovationm.com\/blog\/wp-content\/uploads\/2015\/03\/InnovationM-Android-Database-Version-Code.png","width":473,"height":113,"caption":"InnovationM Android Database Version Code"},{"@type":"BreadcrumbList","@id":"https:\/\/www.innovationm.com\/blog\/android-database-version-stored-in-database-file-header\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.innovationm.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Android – Database version stored in Database file header"}]},{"@type":"WebSite","@id":"https:\/\/www.innovationm.com\/blog\/#website","url":"https:\/\/www.innovationm.com\/blog\/","name":"InnovationM - Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.innovationm.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.innovationm.com\/blog\/#\/schema\/person\/03f59a9465a9f03b551985392f877ae8","name":"Manish Seth","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5ed7a8bee434c0f1b851face1f5c946c36929374fd4627a3fc3958d67517eff?s=96&r=g","caption":"Manish Seth"},"sameAs":["http:\/\/www.innovationm.com\/"],"url":"https:\/\/www.innovationm.com\/blog\/author\/manish-seth\/"}]}},"_links":{"self":[{"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/posts\/1526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/comments?post=1526"}],"version-history":[{"count":0,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/posts\/1526\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/media\/1527"}],"wp:attachment":[{"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/media?parent=1526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/categories?post=1526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.innovationm.com\/blog\/wp-json\/wp\/v2\/tags?post=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}