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
- Open finder
- open
Go
intoolbar
- 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