How much data is your DB going to hold? Remember, you cannot force the user to download 10M of apk over GPRS. I also think there probably is a limit of the apk size on the Android Market.
Dictionary applications, for example, hold ~30MB in the database. The applications have a custom built in database downloader. So they do not pack these huge databases in the apk, but rather download the database on first use. Another example would be packing in the apk a CSV file containing NAME|ADDRESS|PHONE. You can then, at first use of the app, create an sqlite database from importing the data from the CSV file. I think you can play around to see what scenario fits you best. BR, Adrian Vintu http://adrianvintu.com On Sun, Mar 7, 2010 at 5:51 AM, Ben Orchard <[email protected]> wrote: > Hey, I wanted to say thanks for the information. > > Let me ask one more thing: I have a large amount of data that I want to use > in conjunction with my app. In my mind it seems more efficient to use a db > to store this data, but packing the db in android seems..odd. I think it > might be easier to pack the db using a better tool, then just access the > pre-packed db in the app. > > Any thoughts on this? > > Thanks again. > > On Sat, Mar 6, 2010 at 3:04 PM, Adrian Vintu <[email protected]>wrote: > >> Yes to all :) >> >> Typically, you will pack your DB in the Android project and unpack it on >> the device. >> >> BR, >> Adrian Vintu >> >> http://adrianvintu.com >> >> >> On Thu, Mar 4, 2010 at 7:36 PM, Ben Orchard <[email protected]>wrote: >> >>> Let me ask this, since I suspect it's the question that was on the mind >>> of the submitter, and it's on mine as well. >>> >>> Can I create an sqlite db on my computer, populate then use that as the >>> main data source for my app? That's the question that I think is most >>> pressing. If the answer is yes, then is it as simple as moving the file (I >>> don't know the sqlite extension) to the resources folder in your project? >>> >>> Thanks, Ben >>> >>> >>> On Wed, Mar 3, 2010 at 2:10 AM, Maxood <[email protected]> wrote: >>> >>>> Here are your required answers: >>>> >>>> Q.Which database i can use ? >>>> A. SQLite. You can download it free from www.sqlite.org >>>> >>>> Q. What should be connection string ? >>>> A. You can make a database adapter class instead. Go though these >>>> links >>>> >>>> http://developer.android.com/reference/android/database/sqlite/package-summary.html >>>> http://www.devx.com/wireless/Article/40842/1954 >>>> >>>> Q. How i can deploy queries ? >>>> A. You can write queries in your class using cursors >>>> >>>> Q. How i can parse recordsets etc ? >>>> A. Look into the Android SQLite API: >>>> >>>> http://developer.android.com/reference/android/database/sqlite/package-summary.html >>>> >>>> Hope this helps. >>>> >>>> Android Developer, >>>> Maqsood >>>> http://www.twitter.com/maxood >>>> On Feb 23, 11:51 pm, Harminder Singh <[email protected]> wrote: >>>> > Hello, >>>> > >>>> > I am newbie to Android application development. Can anybody help me >>>> > about to set up database related applications. >>>> > I have many questions into mind like: >>>> > Which database i can use ? >>>> > How i can use that ? >>>> > What should be connection string ? >>>> > How i can deploy queries ? >>>> > How i can parse recordsets etc ? >>>> > >>>> > Seeking your valuable comments >>>> > >>>> > Thank in Advance >>>> > Harminder >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Android Beginners" group. >>>> >>>> NEW! Try asking and tagging your question on Stack Overflow at >>>> http://stackoverflow.com/questions/tagged/android >>>> >>>> To unsubscribe from this group, send email to >>>> [email protected]<android-beginners%[email protected]> >>>> For more options, visit this group at >>>> http://groups.google.com/group/android-beginners?hl=en >>>> >>> >>> >>> >>> -- >>> I have no bit of wisdom to include as a signature. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Android Beginners" group. >>> >>> NEW! Try asking and tagging your question on Stack Overflow at >>> http://stackoverflow.com/questions/tagged/android >>> >>> To unsubscribe from this group, send email to >>> [email protected]<android-beginners%[email protected]> >>> For more options, visit this group at >>> http://groups.google.com/group/android-beginners?hl=en >>> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Android Beginners" group. >> >> NEW! Try asking and tagging your question on Stack Overflow at >> http://stackoverflow.com/questions/tagged/android >> >> To unsubscribe from this group, send email to >> [email protected]<android-beginners%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/android-beginners?hl=en >> > > > > -- > I have no bit of wisdom to include as a signature. > > -- > You received this message because you are subscribed to the Google > Groups "Android Beginners" group. > > NEW! Try asking and tagging your question on Stack Overflow at > http://stackoverflow.com/questions/tagged/android > > To unsubscribe from this group, send email to > [email protected]<android-beginners%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-beginners?hl=en > -- You received this message because you are subscribed to the Google Groups "Android Beginners" group. NEW! Try asking and tagging your question on Stack Overflow at http://stackoverflow.com/questions/tagged/android To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en
