Retrieving large string from Expo SQLite not working

Expo SDK
1

Please provide the following:

  1. SDK Version: 38.0.10
  2. Platforms(Android/iOS/web/all): Android

Hey everyone,

I’m currently working with a long string (~2.173.544 characters) and want to store and request it with expo-sqlite. Storing works fine, I can access the string when exporting the *.db file and opening it in the SQLiteBrowser. Unfortunately I can’t access it in my app like I usually can with the following code. The same code works fine for a slightly shorter string (2.039.712 characters).

this.db.transaction(tx => {
        tx.executeSql(
            query, 
            [], 
            (a,b) => console.log(b), 
            (a, b) => console.log(b),
        );
    }, 
    error => { 
      console.log(error); 
    }, 
    () => { 
      console.log("tx succes"); 
    }
    );

When it’s not working I get this error message printed by the second last console.log statement:

Attempt to get length of null array
- node_modules/react-native/Libraries/BatchedBridge/NativeModules.js:103:50 in promiseMethodWrapper
- node_modules/@unimodules/react-native-adapter/build/NativeModulesProxy.native.js:15:23 in moduleName.methodInfo.name
* http://192.168.0.204:19001/node_modules/expo/AppEntry.bundle?platform=android&dev=true&hot=false&minify=false:131857:27 in exec
* http://192.168.0.204:19001/node_modules/expo/AppEntry.bundle?platform=android&dev=true&hot=false&minify=false:132431:33 in runBatch
* http://192.168.0.204:19001/node_modules/expo/AppEntry.bundle?platform=android&dev=true&hot=false&minify=false:132475:12 in runAllSql
- node_modules/@expo/websql/lib/websql/WebSQLTransaction.js:130:0 in <global>
* http://192.168.0.204:19001/node_modules/expo/AppEntry.bundle?platform=android&dev=true&hot=false&minify=false:132284:20 in <unknown>
- node_modules/immediate/lib/index.js:42:29 in nextTick
- node_modules/react-native/Libraries/Core/Timers/JSTimers.js:135:14 in _callTimer
- node_modules/react-native/Libraries/Core/Timers/JSTimers.js:387:16 in callTimers
- node_modules/react-native/Libraries/BatchedBridge/MessageQueue.js:425:19 in __callFunction
- node_modules/react-native/Libraries/BatchedBridge/MessageQueue.js:112:6 in __guard$argument_0
- node_modules/react-native/Libraries/BatchedBridge/MessageQueue.js:373:10 in __guard
- node_modules/react-native/Libraries/BatchedBridge/MessageQueue.js:111:4 in callFunctionReturnFlushedQueue
* [native code]:null in callFunctionReturnFlushedQueue

I couldn’t find information about limitations of the SQLite DB in expo. Does anyone know about any limitations for the SQLite DB in Expo or has another explanation for this behavior?

Thanks in advance.

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.