Geek Answers Handbook

How can I find the SQLite database file on my computer?

I implemented my first application using Xamarin Studio (Mono for Android). This application stores some data in SQLite db, which works fine on Sony Tablet S.

My question is: is there a way to get the db file and see, for example, its size?

I looked at the next path

/data/data/My-Application-Package-Name/databases/My-database-name

but it does not seem to exist.

Thanks for any help!

+4
source share
2 answers

You can use Eclipse to navigate to it using the sqlite manager plugin ( http://www.coderzheaven.com/2011/04/18/sqlitemanager-plugin-for-eclipse/ )

  • Download the * .jar file from the website that I link above the "dropins" folder in eclipse (open your eclipse folder and you should see it)
  • Then restart eclipse and go to DDMS. You may need windows-> views-ddms if it is not already displayed ...
  • Select a device from the left pane, then use the file explorer to navigate to your data

    Directory / YourApp / Databases. Hopefully an icon appears that appears when you select a database. If not, rename your database to use the "db" ext.
  • Click on it and it will open on the manager tab.
+2
source

This is a valid database location (// data / data / My-Application-Package-Name / databases / My-database-name), but you can access it from file managers if you only have root access. See how this can be done here . Otherwise, if you want to get some information through the code, you are doing something wrong, so post the code and logcat.

0
source

More articles:


All Articles