iOS - a way to browse sqlite database

Question

Possible Duplicate:
Is there a good Core Data browsing tool out there?

Is there a way to browse an sqlite database on iOS?

I use CoreData to store entities in one of my applications, and I would like to browse the tables to be sure that the database saves what I want. I'm thinking about a kind of database viewer.

maybe this is what you are looking for: http://stackoverflow.com/questions/1609683/is-there-a-good-core-data-browsing-tool-out-there — tkanzakic, Jan 16 '13 at 10:05
You can also have a look on the tools posted here http://stackoverflow.com/questions/2624573/viewer-query-analyzer-for-sqlite-databases — gazzola, Jan 16 '13 at 10:24
Core Data Editor seems to be good to browse device database, thank you. — ragu89, Jan 16 '13 at 10:39

score 4 · Accepted Answer · edited Aug 12 '17 at 15:05

4

If you run your application inside the simulator on your Mac, you can get to your files inside

/Users/username/Library/Application Support/iPhone Simulator/version/appid/Documents

Just open your database there with any tool like Base or SQLiteManager.

UPDATE:

Since IOS 8 they put it in a different folder:

Library/Developer/CoreSimulator/Devices/(numbers and letters)/data/Containers/Data/Application/(numbers and letters)/Documents/

edited Aug 12 '17 at 15:05

dmaulikr

458
5
20

answered Jan 16 '13 at 10:21

Trausti Thor

3,722
31
41

Thank you I will use this solution – ragu89 Jan 16 '13 at 10:38
Also, check out SimPholders for quick access to your app's folders when using the simulator. – Jeff Apr 18 '15 at 06:11
Hello sir there is not file in my document directory i don;t know why? – sandeep tomar Mar 02 '16 at 09:19
Either you have no created a file, or the file is someplace else. Just create a file called xxx.sql and then use terminal and do 'find . -name xxx.sql' – Trausti Thor Mar 09 '16 at 14:52

score 0 · Answer 2 · answered Jan 16 '13 at 10:19

0

I've used SQLite Manager addon for Firefox and it worked well for SQLite databases.

answered Jan 16 '13 at 10:19

Brian Liang

7,734
10
57
72

iOS - a way to browse sqlite database

2 Answers2