Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I access SQLite database instance on iPhone?

Tags:

sqlite

ios

iphone

I'm developing an iPhone app that uses the built-in SQLite database. I'm trying to view and open the database via the sqlite3 command line tool so I can execute arbitrary SQL against it.

When I run my app in the simulator, the .sqlite file it creates is located at ~/Library/Application Support/iPhone Simulator/User/Applications/.

How can I see that file on the physical iPhone?

like image 933
Keith Fitzgerald Avatar asked Oct 01 '08 21:10

Keith Fitzgerald

People also ask

How do I access SQLite database on Iphone?

Step 1 − Open Xcode -→ Single View Application -→ Let's name is DBSqlite. Step 2 − Let's develop our UI, Open Main. storyboard and add one text field and two buttons as shown below. Step 3 − Create @IBAction for both the buttons and @IBOutlet for text field and name them btnInsert, btnShowData and name respectively.

Does SQLite work on Iphone?

The database that can be used by apps in iOS (and also used by iOS) is called SQLite, and it's a relational database. It is contained in a C-library that is embedded to the app that is about to use it.

Where is SQLite database stored iOS?

-Navigate to /Users/jk/Library/Developer/CoreSimulator/Devices/ and select the simulator file that matches the ID you found. -In the finder search, search for The current Model Version name.

2 Answers

Instructions for Xcode 6.0.1

  1. Xcode > Open > YourProject
  2. Xcode > Product > Run
  3. Xcode > Window > Devices
  4. (Column 1 - select) Devices > YourDeviceName
  5. (Column 2 - select) Installed Apps > YourAppName
  6. (Column 2 - select) Cog under 'Installed Apps' list
  7. (Pop-Up - select) Download Container...
  8. Save to location
  9. Right click on 'YourAppName.xcappdata'
  10. Select 'Show Package Contents'
  11. AppData > Documents > YourDatabase.sqlite

enter image description here

like image 142
Tr0yJ Avatar answered Oct 05 '22 18:10

Tr0yJ

In Xcode select window->organizer and expand the node next to your application in the applications section on your phone. Select the black downward pointing arrow next to application data and save the file anywhere on your desktop. Your sqlite database should be in there somewhere.

As for how to go about getting it back on the phone once your done i have no clue.

like image 21
Lounges Avatar answered Oct 05 '22 18:10

Lounges
Sign in to Comment

Related questions

The iOS 8.1 simulator runtime is not available error in Xcode 6.1
Changing activity indicator color to black
How can I check if my AVPlayer is buffering?
iOS build number in Cordova app
How to detect when UIView size is changed in swift ios xcode?
No Assistant Results
Native Android/iOS development vs Marmalade SDK [closed]
How can I change text font in UIPickerView in iOS 7?
How to send a silent Push Notification payload
NSData from Byte array in Swift
Firebase Analytics setScreenName deprecated
How to make UIView animation sequence repeat and autoreverse
Check if User is Logged into iCloud? Swift/iOS
Change colour of dark grey highlight when holding down custom UIButton?
How to set the height of a Today Widget Extension?
How to exchange elements in swift array?
Custom Google Sign-In button - iOS
Reasons for rejecting iPhone application by Apple store [closed]
CLLocationManager startUpdatingLocation not calling locationManager:didUpdateLocations: or locationManager:didFailWithError:
iPhone - Draw transparent rectangle on UIView to reveal view beneath

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!