[android-developers] Re: How to add file .sqlite extension to our project
So you have a pre-populated database that you'd like included with the application upon installation? I'm not sure what the preferred solution is for this, but it might be possible to accomplish this via a raw resource. In general, a raw resource is a file that can be bundled with your application and accessed via: R.raw.* See: http://developer.android.com/guide/topics/resources/resources-i18n.html I assume that you've already gotten SQLite to work in general. If not, I highly suggest the Notepad tutorial, which is a great primer: http://developer.android.com/guide/tutorials/notepad/index.html Hope this helps! -- PJ On Nov 3, 6:55 am, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: How to add file .sqlite extension to our project
(I'm reposting this response because I think I accidentally replied only to the original author.) Archana, So you have a pre-populated database that you'd like included with the application upon installation? I'm not sure what the preferred solution is for this, but it might be possible to accomplish this via a raw resource. In general, a raw resource is a file that can be bundled with your application and accessed via: R.raw.* See: http://developer.android.com/guide/topics/resources/resources-i18n.html I assume that you've already gotten SQLite to work in general. If not, I highly suggest the Notepad tutorial, which is a great primer: http://developer.android.com/guide/tutorials/notepad/index.html Hope this helps! -- PJ On Nov 3, 6:55 am, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. On Nov 3, 6:55 am, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: How to add file .sqlite extension to our project
My earlier suggestion was incomplete, assuming you want to continue to modify the database afterwards. This question has already been discussed and there's a great answer for it. Please see: http://groups.google.com/group/android-developers/browse_thread/thread/4ffd437aeb35d29e -- PJ On Nov 3, 7:44 am, sham shamcs shamc...@gmail.com wrote: I believe Android supports sqlite. There is a sqlite library in Android. I didnt use it.But normally we will add the file using adb command in Linux On Tue, Nov 3, 2009 at 6:25 PM, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en- Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: How to add file .sqlite extension to our project
Thanks Everybody... This information are really helpful for me.. On Nov 4, 4:29 am, PJ pjbar...@gmail.com wrote: My earlier suggestion was incomplete, assuming you want to continue to modify the database afterwards. This question has already been discussed and there's a great answer for it. Please see:http://groups.google.com/group/android-developers/browse_thread/threa... -- PJ On Nov 3, 7:44 am, sham shamcs shamc...@gmail.com wrote: I believe Android supports sqlite. There is a sqlite library in Android. I didnt use it.But normally we will add the file using adb command in Linux On Tue, Nov 3, 2009 at 6:25 PM, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en-Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Re: How to add file .sqlite extension to our project
But I am facing one more problem...This sqlite file size is 147 mb. So when i am running it showing error message like No space left on device.Is their any solution for this? On Nov 4, 10:04 am, Archana archana.14n...@gmail.com wrote: Thanks Everybody... This information are really helpful for me.. On Nov 4, 4:29 am, PJ pjbar...@gmail.com wrote: My earlier suggestion was incomplete, assuming you want to continue to modify the database afterwards. This question has already been discussed and there's a great answer for it. Please see:http://groups.google.com/group/android-developers/browse_thread/threa... -- PJ On Nov 3, 7:44 am, sham shamcs shamc...@gmail.com wrote: I believe Android supports sqlite. There is a sqlite library in Android. I didnt use it.But normally we will add the file using adb command in Linux On Tue, Nov 3, 2009 at 6:25 PM, Archana archana.14n...@gmail.com wrote: Hi.. Can anybody tell me whether android support file with .sqlite extension? how can we add this file to our project.?is it same as .db file?i have one file with .sqlite extension.I need to fetch data from that. i dont understand how to add it.Please help. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en-Hidequoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en