Can't find SQLite tables in Android


#1

I was able to find Expo’s SQLite database under /data/data/packagename/databases/. But opening with sqlite3 and running .tables doesn’t show my tables. Or select * from my_table says that my_table doesn’t exist. I’m sure the commands to create the tables did run though as I see success messages printed in the console, as well as the inserted data in the app. In iOS I’m also able to see the database with all its contents.


#2

Hey @ischuetz,

What SDK version is your project? Also, just for clarity since I saw your other post regarding ejecting, is this problem occurring in a standard or ejected project?

Cheers,
Adam


#3

In a standard project. I had not ejected yet. Which SDK do you mean, where do I find the version?


#4

Got it. Thanks! You can find it in your app.json.


#5

All I see in app.json is 2 fields for the name of the app (displayName and name).

In case you mean package.json, these are the contents

{
  "scripts": {
    "start": "react-native start",
    "android": "react-native run-android",
    "ios": "react-native run-ios",
    "lint": "tslint src/**/*.ts",
    "tsc": "tsc",
    "clean": "rimraf build",
    "build": "yarn run clean && yarn run tsc --",
    "watch": "yarn run build -- -w",
    "watchAndRunAndroid": "concurrently \"yarn run watch\" \"yarn run android\"",
    "buildRunAndroid": "yarn run build && yarn run watchAndRunAndroid ",
    "watchAndRunIOS": "concurrently \"yarn run watch\" \"yarn run ios\"",
    "buildRunIOS": "yarn run build && yarn run watchAndRunIOS ",
    "watchAndStart": "concurrently \"yarn run watch\" \"yarn run start\"",
    "buildAndStart": "yarn run build && yarn run watchAndStart ",
    "test": "jest"
  },
  "dependencies": {
    "@expo/vector-icons": "8.0.0",
    "@types/expo": "^31.0.5",
    "@types/jest": "^23.3.11",
    "@types/react-native-datepicker": "^1.7.0",
    "@types/react-native-draggable-flatlist": "^1.1.0",
    "@types/react-native-modal": "^4.1.1",
    "@types/react-native-navbar": "^2.1.1",
    "@types/react-native-popup-dialog": "^0.16.1",
    "@types/react-navigation": "^3.0.1",
    "@types/react-redux": "^6.0.12",
    "@types/redux": "^3.6.0",
    "@types/redux-devtools-extension": "^2.13.2",
    "@types/redux-thunk": "^2.1.0",
    "@types/victory": "^31.0.6",
    "fast-deep-equal": "^2.0.1",
    "moment": "^2.23.0",
    "moment-timezone": "^0.5.23",
    "react": "16.5.0",
    "react-native": "https://github.com/expo/react-native/archive/sdk-31.0.0.tar.gz",
    "react-native-datepicker": "^1.7.2",
    "react-native-draggable-flatlist": "^1.1.7",
    "react-native-modal": "^7.0.2",
    "react-native-navbar": "^2.1.0",
    "react-native-popup-dialog": "^0.17.0",
    "react-navigation": "^3.0.9",
    "react-redux": "^6.0.0",
    "redux": "^4.0.1",
    "redux-devtools-extension": "^2.13.7",
    "redux-thunk": "^2.3.0",
    "ts-node": "^7.0.1",
    "ts-optchain": "^0.1.2",
    "typesafe-actions": "^3.0.0",
    "typescript": "^3.2.2",
    "victory-native": "^31.0.0"
  },
  "devDependencies": {
    "@types/expo__vector-icons": "^8.0.0",
    "@types/moment-timezone": "^0.5.10",
    "@types/react": "^16.7.18",
    "@types/react-dom": "^16.0.11",
    "@types/react-native": "^0.57.23",
    "babel-preset-expo": "^5.0.0",
    "concurrently": "^4.1.0",
    "jest": "^23.6.0",
    "jest-cli": "^23.6.0",
    "rimraf": "^2.6.2",
    "ts-jest": "^23.10.5"
  },
  "private": true,
  "prettier": {
    "trailingComma": "es5",
    "tabWidth": 2,
    "semi": false,
    "singleQuote": false,
    "printWidth": 120
  }
}