Re: [sqlite] SQLite database on the android phone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/06/12 05:23, Pavel Ivanov wrote: > And if you include your populated database into application package > before installation and don't see any data after installation check > that you open your database with an absolute path otherwise you could > be opening some other database file, not the one you think you're > opening. Note that advice is not applicable to Android. Android applications are distributed as APK files which behind the scenes are just a zip file. When your application is installed and running it is from that intact zip file, although the contents feel as though they are local files. SQLite cannot open a database that is a member of a zipfile. The application would explicitly have to create the database on storage populating it via SQL queries ideally. You could also write the binary file image, but Android is somewhat fussy about databases it didn't create as it does some behind the scenes shenanigans with versioning and collations/locales. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk/l7IoACgkQmOOfHg372QS8hgCfRi/ApEil2f/H5XwKPF/5Kaag LSAAn3ZhZkUF9y2HJnOYiv/3/0gJjFvM =tzSi -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite database on the android phone
Ask this on Android-related mailing list. And if you include your populated database into application package before installation and don't see any data after installation check that you open your database with an absolute path otherwise you could be opening some other database file, not the one you think you're opening. Pavel On Thu, Jun 21, 2012 at 9:42 AM, kabugi esbon wrote: > Dear Sir/Madam, > > I have developed an android application which have an sqlite database with > some data which i had imported from a CVS file and its working well on the > emulator virtual machine but when i install the application on the android > phone it does not come with the data on the database. my request is to > assist me on how to import the CVS file or SQL file which contain my data > to my sqlite database when am installing the application on the phone. > > Thank you in advance. > > Esbon Kabugi > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite database on the android phone
Dear Sir/Madam, I have developed an android application which have an sqlite database with some data which i had imported from a CVS file and its working well on the emulator virtual machine but when i install the application on the android phone it does not come with the data on the database. my request is to assist me on how to import the CVS file or SQL file which contain my data to my sqlite database when am installing the application on the phone. Thank you in advance. Esbon Kabugi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users