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

Question

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

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

I looked up to the following path

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

but it doesn't seem to exist.

Thanks for any help!

Solution

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

• Download the *.jar file from the website I reference above to the "dropins" folder in eclipse (open your eclipse folder and you should see it)
• Then restart eclipse and go to the DDMS. You may have to do windows->views-ddms if it isn't already being displayed...
• Select your device from the left panel then use the file explorer to go to your data
  directory/YOURAPP/databases. Hopefully there will be an icon that
  shows up when you select your database. If not, rename your database to use the "db" ext.
• Click it and it should open in the manager tab.