[android-developers] Re: Including SQLite database with application

2008-12-03 Thread Mark Murphy
burton miller wrote: these solutions will not work for me. i have a 4.5mb database, which i do not want to duplicate by copying it out of the apk and into a directory. copying it from the web could potentially be very slow as well. i can't believe that there is not a better solution to

[android-developers] Re: Including SQLite database with application

2008-12-03 Thread burton miller
i'm not trying to be difficult - i've been a desktop developer for many years - but the desktop systems have a LOT more storage, so the paradigm is fundamentally different than a phone. i'm very hesistant to ship a 4.5mb database and duplicate it all inside the tiny sliver of user storage

[android-developers] Re: Including SQLite database with application

2008-12-03 Thread Dianne Hackborn
Your best option is to copy it to the SD card. I don't see any chance if supporting SQLite on an database embedded in a .apk any time soon. Ignoring whatever issues there are in SQLite just to do this kind of thing, I wouldn't want to count on Android 3.x running who knows what later version of

[android-developers] Re: Including SQLite database with application

2008-12-03 Thread Semprebon
Downloading it once is probably the best approach, and also allows you to release updates to the database that your app can check for. You could reduce the bandwidth some by compressing it and having the app decompress it. On Dec 3, 1:50 pm, burton miller [EMAIL PROTECTED] wrote: i'm not trying

[android-developers] Re: Including SQLite database with application

2008-12-02 Thread burton miller
these solutions will not work for me. i have a 4.5mb database, which i do not want to duplicate by copying it out of the apk and into a directory. copying it from the web could potentially be very slow as well. i can't believe that there is not a better solution to this extremely common

[android-developers] Re: Including SQLite database with application

2008-11-16 Thread G
Do you think you could include some sample code for how to execute an sql script thats been included as raw? On Nov 15, 7:59 pm, Dan B. [EMAIL PROTECTED] wrote: I think your best 2 options are as the previous poster stated. 1) package the db file as a raw resource, then just use a file stream

[android-developers] Re: Including SQLite database with application

2008-11-15 Thread Mark Murphy
Stu wrote: I'm unable to find how I can ship my database with my application. I don't really want to populate the database at the first run, it just seems a bit pointless when I could prevent this time consuming activity by including a pre-populated db. AFAIK, applications are not unpacked

[android-developers] Re: Including SQLite database with application

2008-11-15 Thread Stu
Hi Mark, thanks for your help. I guess I'll just have a play around with a couple of those suggestions and see which one works for me. :) Regards, Stuart. On Nov 15, 9:57 pm, Mark Murphy [EMAIL PROTECTED] wrote: Stu wrote: I'm unable to find how I can ship my database with my application.