Re: [sqlite] SQLite database on the android phone

[Roger Binns]

-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

[Pavel Ivanov]

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