How to view the data in sqlite file running in iphone application? [closed] How to view the data in sqlite file running in iphone application? [closed] sqlite sqlite

How to view the data in sqlite file running in iphone application? [closed]


If you want to view your database when running on Simulator it is located at the following location

user/Library/Application Support/iPhone Simulator/version of SDK(4.2eg)/Applications/4AF938D6-E981-4971-A588-3424B64E7EE7(eg)/Documents/yourdatabase.sqlite

If you want to view the database in your device then you can use a software like iExplorer.

Cheers

Edit : The location of sqlite file has changed.

It currently resides in :

/User/Library/Application Support/iPhone Simulator/version of SDK(eg-7.0)/Applications/4AF938D6-E981-4971-A588-3424B64E7EE7(eg)/Library/Application Support/app_name/yourdatabase.sqlite

Edit : The location has changed again. It now resides in:

/User/Library/Developer/CoreSimulator/Devices/789A1317-6C55-4615-A72E-65C824D8C6B9(eg)/data/Containers/Data/Application/0470F5FC-0043-46B7-A21C-A436A56ED714(eg)/Documents/yourdatabase.extension


The Firefox extension SQLite Manager is good and free. Another good, free Mac option is SQLite Database Browser.


If you want to see data base while app is running in simulator

  1. Open finder
  2. open Go in toolbar
  3. Then Press and hold command+option you can see Library option

then process like this

Library/Developer/CoreSimulator/Devices/8FA9F307-45DC-48EC-89ED-E4BDC34CB628/data/Containers/Data/Application/B6105584-49BF-4C0C-BC72-C97FA9B1C194/Documents/database.db