{"id":16732,"date":"2022-10-22T00:40:05","date_gmt":"2022-10-21T19:10:05","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/"},"modified":"2022-10-22T00:40:05","modified_gmt":"2022-10-21T19:10:05","slug":"solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/","title":{"rendered":"[Solved] How to go about developing an Android app with SQLite database? [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n
\n

The last commit in the library is also in Dec. 2014.<\/p>\n<\/blockquote>\n

That library does not do very much, and so I would not expect it to be changing. SQLiteAssetHelper<\/code> works just fine.<\/p>\n

However, SQLiteAssetHelper<\/code> is a solution for a specific problem: shipping a database with an app.<\/p>\n

\n

On the other hand, in this official guide, they are saying that the recommended method for creating an SQLite database is to subclass SQLiteOpenHelper, from which one can infer that Google is now recommending the use of native Android API to create and work with databases.<\/p>\n<\/blockquote>\n

Um, SQLiteAssetHelper<\/code> extends SQLiteOpenHelper<\/code><\/a>, and it uses the “native Android API to create and work with databases”.<\/p>\n

Furthermore, SQLiteOpenHelper<\/code>, on its does, does nothing for a specific problem: shipping a database with an app.<\/p>\n

\n

now as of 2016, what is the recommended way of creating and working with and shipping an SQLite database in an Android application?<\/p>\n<\/blockquote>\n

Given the “and shipping” bit, I strongly recommend SQLiteAssetHelper<\/code>.<\/p>\n

Conversely, if you are not<\/em> shipping a database with your app \u2014 which computer programmers would define as “having a database with a schema and data that you want to include in the shipped app to use as a starting point” \u2014 then just use SQLiteOpenHelper<\/code> and define your database on the fly.<\/p>\n<\/p><\/div>\n

<\/div>\n<\/div>\n

<\/span> <\/p><\/div>\n<\/div>\n

[ad_2]<\/p>\n

solved How to go about developing an Android app with SQLite database? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"

[ad_1] The last commit in the library is also in Dec. 2014. That library does not do very much, and so I would not expect it to be changing. SQLiteAssetHelper works just fine. However, SQLiteAssetHelper is a solution for a specific problem: shipping a database with an app. On the other hand, in this official … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[452,4224,1352,707],"class_list":["post-16732","post","type-post","status-publish","format-standard","hentry","category-solved","tag-android","tag-android-database","tag-android-sqlite","tag-sqlite"],"yoast_head":"\n[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] The last commit in the library is also in Dec. 2014. That library does not do very much, and so I would not expect it to be changing. SQLiteAssetHelper works just fine. However, SQLiteAssetHelper is a solution for a specific problem: shipping a database with an app. On the other hand, in this official ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-21T19:10:05+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to go about developing an Android app with SQLite database? [closed]\",\"datePublished\":\"2022-10-21T19:10:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\"},\"wordCount\":229,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"android\",\"android-database\",\"android-sqlite\",\"sqlite\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\",\"name\":\"[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-21T19:10:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to go about developing an Android app with SQLite database? [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb","og_description":"[ad_1] The last commit in the library is also in Dec. 2014. That library does not do very much, and so I would not expect it to be changing. SQLiteAssetHelper works just fine. However, SQLiteAssetHelper is a solution for a specific problem: shipping a database with an app. On the other hand, in this official ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-21T19:10:05+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to go about developing an Android app with SQLite database? [closed]","datePublished":"2022-10-21T19:10:05+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/"},"wordCount":229,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["android","android-database","android-sqlite","sqlite"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/","name":"[Solved] How to go about developing an Android app with SQLite database? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-21T19:10:05+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-go-about-developing-an-android-app-with-sqlite-database-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to go about developing an Android app with SQLite database? [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/16732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=16732"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/16732\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=16732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=16732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=16732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}