Comments Off on Dealing with SQLite files in mobile apps
Recently I found myself wanting to inspect what was in the application database outside of the mobile application I was working on, which as usual lead me to search for a solution on DuckDuckGo.
I found a great link here, which basically says:
- Download and install SQLite command line tools if necessary (OSX comes with one).
- Find the SQLite file you want to inspect
- Run the command to open the database and inspect it:
sqlite3 /Users/<username>/Library/Developer/CoreSimulator/Devices/<Simulator device ID>/data/Containers/Data/Application/<App id>/Library/Private\ Documents/_alloy_.sql sqlite> .tables user order item sqlite> .schema user CREATE TABLE user (id INETGER PRIMARY KEY, uname TEXT, fname TEXT, lname TEXT); sqlite>select * from user; 1|jsmith|John|Smith