0

I am using expo-sqlite in my Expo App like this in App.js

import * as SQLite from "expo-sqlite";

const db = SQLite.openDatabase("tasks.db");

export default function App() {
  useEffect(() => {
    db.transaction((txt) => {
      txt.executeSql(
        "create table if not exists tasks (id integer primary key not null, status int, description text, date text, imageURI text, notificationID text);"
      );
    });
    checkForFailedTasks();
  }, []);
.
.
.

And then I am using Transaction throughout my App. The problem is that if I am debugging the App in Expo Go it works as intended, but in the on my phone installed .apk build version of the app the database does not work. I am using expo-sqlite: "~10.3.0" and eas for building.

I tried updating all modules to the latest versions because I thought maybe it is a old bug.

MichaelB
  • 1
  • 3
  • I have the same problem on SDK 47, at expoGo everyhing works great but on apk not. The apk crashes after open the scren with SqlIte "expo-sqlite": "~11.0.0" "expo": "^47.0.0" – Bruno Luiz May 03 '23 at 17:28

0 Answers0