Stack Overflow
Stack Overflow

Questions tagged [expo-sqlite]

26 questions
4
votes
1 answer

RN: Class static side 'typeof *' incorrectly extends base class static side 'typeof BaseModel

In react native, I'm extending an ORM class (according to its documentation) but I'm getting following error in VSCode TypeScript checker: Class static side 'typeof Animal' incorrectly extends base class static side 'typeof BaseModel'. Types of…
jave.web
  • 13,880
  • 12
  • 91
  • 125
3
votes
0 answers

How to increase CursorWindow Size, Expo-SQLite?

Expo-SQL const printSearchTable = () => { db.transaction((tx) => { tx.executeSql( "select * from 'Literature'", [], (tx, res) => console.log( "Succeeded to get Contents From Table 'Literature'--->", …
Oliver Saintilien
  • 165
  • 1
  • 10
2
votes
1 answer

TypeError: undefined is not an object (evaluating 'ExponentSQLite.exec')

ive initiated a new react-native app using npx init where i transferred a code i was using on anothe react native app. this code uses react expo-sqlite. i installed expo-sqlite but when i run the app, i get this annoying error: TypeError: undefined…
Dennis
  • 158
  • 9
1
vote
0 answers

Why does my database load fully using expo-file-system in development with Expo Go, but it doesn't fully load using TestFlight?

I'm creating a simple app that uses data in a preloaded database from an assets folder ("../assets/worldEnglishBible.db" (4.8 MB). I'm utilizing expo-sqlite to query the data and expo-file-system to load the database so it can be used by…
Sam Sweetin
  • 11
  • 2
1
vote
1 answer

SQLite, Error NOT NULL constraint failed on Primary Key column

I have problem while using expo-sqlite. Whenever I tried to insert values to table (exclude the id), it always throw the NOT NULL constraint error. If I'm not mistaken, Primary Key will automatically auto_increment means that I don't really need to…
jted95
  • 1,084
  • 1
  • 9
  • 23
0
votes
0 answers

(React-Native, Expo) tx.executeSql() is not Working

useEffect(() => { // 테이블 생성 Chat_DB.transaction((tx) => { tx.executeSql( `create table if not exists ${RoomName} (id text primary key not null, date text, sender text, receiver text, peer_key_hash…
JHL
  • 1
  • 1
0
votes
0 answers

Expo typeorm migration commands throw Cannot use import statement outside a module

I have an Expo project with expo-sqlite and typeorm. Relevant configuration: package.json { "name": "testproject", "main": "expo-router/entry", //... "dependencies": { //... "expo-sqlite": "~11.3.2", //... "reflect-metadata":…
MrPlow
  • 1,295
  • 3
  • 26
  • 45
0
votes
0 answers

expo sqlite can't get new data after inserting sql query

So basically i am trying to insert a new data inside orders but for some reason i can't get new data when i try to select from orders all what i get is old data i only get new data if i refresh the app otherwise it is showing just old one import *…
GameOverAgain
  • 1
  • 1
0
votes
0 answers

SQLite-expo return nothing

When i try to connect and then get data from db i get nothing but i have records in database (SQLiteStudio records proof) I try all guids from Ethernet: get path with filesystem, use other derectory or only db name but it don`t help. This is my…
MagCyp
  • 1
  • 1
0
votes
1 answer

Expo SQLite not inserting values into the table

I am using expo-sqlite to create a table in a database. The database gets created/opened successfully and the table gets created too but when I insert some values into it, there's a strange error in log. Following is my code import * as SQLite from…
Artyom
  • 1
  • 2
0
votes
0 answers

react native expo sqlite issue

I am having issue in react native expo project with sqlite in showing some data from other table by using foreign key. I am trying to develop Point of sale app for practice purpose. I am beginner. I am trying to add products and while adding…
Muzzammil Ahmad
  • 1
0
votes
0 answers

Database (Expo SQLite) cannot be created in the apk file

So I recently made an app which uses Expo SQLite package to store items. My goal was obviously to keep the data saved when a user closes the app and then opens it again. It works perfectly fine inside the Expo Go app, but when I ran eas build -p…
majstorsmora
  • 3
  • 1
0
votes
0 answers

Storing base64 image within expo-sqlite results in 'null' reading database entries

Within my Android/iOS React Native (Expo managed) app I want a database to store my images which I encode to base64. Because I am using Expo, I use expo-sqlite within my React Native app. I initialize my database within my classes (extends…
Flippy
  • 202
  • 3
  • 12
0
votes
1 answer

React native - Expo SQLite - Unable to resolve module ../assets/terezeen.db

I installed the expo SQLite package with the expo filesystem and assets package. I am trying to load a pre-configured database but I keep getting these errors: Android Bundling failed 341ms Unable to resolve module ../assets/terezeen.db from…
Junek
  • 15
  • 8
0
votes
0 answers

React native expo-sqlite | Row too big to fit into CursorWindow

I encounter an error when I want to retrieve data from my expo-sqlite database Row too big to fit into CursorWindow requiredPos=0, totalRows=1 Data are images in base64 format, I am using react native and expo. Is it possible to increase this…
Camille
  • 1
  • 4
1
2