I am creating an iphone app within XCODE the makes use of an SQLite3 database. I am creating the database programmatically if it does not exist. I am not getting any errors when I run the program.
How can I check the contents of the database to ensure that the data has been inserted correctly into the correct columns? Where does Xcode place the table within my system where I can view it?
The SQLite database will be created in your apps Documents folder, in the simulator's base directory.
Before Xcode 6, you can check in:
~/Library/Application Support/iPhone Simulator/4.2/Applications/GUID/Documents
There is also a Mac OS X application called SQLiteBrowser that you can use to browse the database your app created.
As of Xcode 6, the new iOS simulator's directory is located here :
~/Library/Developer/CoreSimulator
Ultimately, you can find your app's database under a location like this (Replace UIDs by yours) :
~/Library/Developer/CoreSimulator/Devices/4D2D127A-7103-41B2-872B-2DB891B978A2/data/Containers/Data/Application/0323215C-2B91-47F7-BE81-EB24B4DA7339/Documents/MyApp.sqlite
Source: SO: Xcode 6 iPhone Simulator Application Support Location
~/Library/Developer/CoreSimulator. To find the unique path add the following statement to the AppDelegate.m file applicationDocumentsDirectory method: NSLog(@"%@",[[[NSFileManager defaultManager] URLsForDirectory:NSDocumentDirectory inDomains:NSUserDomainMask] lastObject]);
If you want to view the database that you are created,
Open finder press Command+g "~/Library/Application Support/iPhone Simulator" then go.
Open 5.0 (as per your version of simulator)-> Application-> select the pgm folder
-> Documents
Then you can see the database
~/Library/Developer/CoreSimulator. To find the unique path add the following statement to the AppDelegate.m file applicationDocumentsDirectory method: NSLog(@"%@",[[[NSFileManager defaultManager] URLsForDirectory:NSDocumentDirectory inDomains:NSUserDomainMask] lastObject]);The simulator directory has been moved with Xcode 6 to: ~/Library/Developer/CoreSimulator. To find the unique path add the following statement to the AppDelegate.m file, applicationDocumentsDirectory method:
NSLog(@"%@",[[[NSFileManager defaultManager] URLsForDirectory:NSDocumentDirectory inDomains:NSUserDomainMask] lastObject]);
Xcode 9.1:
Open Terminal, type:
cd ~ & find -name "YourModelName.sqlite"
You'll most likely be presented with such a path:
~/Library/Developer/CoreSimulator/Devices/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/data/Containers/Data/Application/YYYYYYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY/Library/Application Support/
There are a bunch of standalone programs that look at sqllite files. A very popular one for the Mac is called "Base":
