44 questions
1
vote
1
answer
455
views
Expo SQLiteProvider is causing errors to be thrown when used
I'm attempting to work with expo-sqlite for the first time and I'm running into an issue where wrapping the provider around anything causes an error. If I'm using expo on my phone it says:
Warning: ...
- 365
2
votes
1
answer
120
views
expo-router + expo-sqlite blank screen after Android build with no database error
I'm using expo-router and expo-sqlite to build an Android app with Expo. The build finishes successfully using eas build, but when I install and run the app (APK) on an emulator, the app shows only a ...
- 21
2
votes
1
answer
130
views
How do define REGEX or REGEXP function in expo-sqlite
I am building an Expo app using expo-sqlite and TypeOrm through DataSource to interact with the mobile device built-in sqlite DB.
I need to use a regex matching function in a database query.
Here is ...
- 376
1
vote
1
answer
339
views
Drizzle Expo Database reset
I am working with expo-SQLite and and drizzle.
It hasn't happened yet, but incase a migration fails, I would like to just clear the local database and start over. For my use case its fine to clear the ...
- 25
1
vote
0
answers
389
views
Problem SQLite Module on Expo React Native
terminal Screenshot of error
I'm attempting to integrate SQLite into my Expo project using expo-sqlite. However, when I run the project, I encounter the following error:
(NOBRIDGE) ERROR Error: ...
- 11
1
vote
0
answers
468
views
SQLite 'NativeDatabase.prepareAsync' has been rejected
I am trying to find a record based on the following code,
await userDb.getFirstAsync(query);
But I am getting the following error randomly,
\[Error: Call to function 'NativeDatabase.prepareAsync' has ...
- 11
2
votes
0
answers
351
views
Cannot find native module 'ExpoSQLite'
I keep getting this error after trying all chatGPT solutions. I ran the expo-sqlite install command again and even reinstalled the npm packages.
- 33
0
votes
1
answer
84
views
Unable to fetch data from the expo-sqlite database efficiently
This is a function to get the data for a bar chart in my expo application using expo-sqlite but the sql query doesn't seem to work properly.
What i wanted was to create a function that can fetch the ...
- 143
1
vote
1
answer
283
views
Expo SQLite using assetSource cannot read existing tables
I have created a sqlite database file with a single table in it. I have added this file to the assets folder of my Expo project but when I query the database using the latest expo-sqlite I get a 'no ...
- 41
2
votes
1
answer
841
views
React Native - ExpoSQLite cannot open DB on iOS
I'm trying to load a pre-existing database using expo-sqlite. It works perfectly fine on Android, however on iOS I'm having a few problems.
My code for opening the DB is as follows:
return (
<&...
- 61
2
votes
1
answer
225
views
React Native - Expo SQLite returns mixed up values for columns
I am trying to read a pre-existing database generated in Python for a React Native app using Expo's SQLite library, expo-sqlite.
However, I am experiencing very weird behavior. Reading the database ...
- 61
0
votes
1
answer
2k
views
I get db.execAsync error even though I am using expo sqlite latest version
I am developing a project with Expo. I am using Expo Sqlite . I created a database . I am using the new version of Expo but I get the following error:
ERROR Failed to initialize database: [TypeError: ...
- 11
1
vote
1
answer
1k
views
Expo sqlite database rejection
i have been working on an app with expo for two months now testing with IOS only. My app runs multiple database async functions at an instance, i never had issues testing it on IOS but as soon as i ...
- 11
1
vote
1
answer
876
views
react native expo getting error _ExpoSQLiteNext.default.NativeDatabase is not a constructor in SQLite.openDatabaseAsync('db.testDb')
I'm getting below error when I used SQLite.openDatabaseAsync('db.testDb');
Error
TypeError: _ExpoSQLiteNext.default.NativeDatabase is not a constructor
Code snippets :-
import * as SQLite from '...
- 311
1
vote
0
answers
169
views
My expo-sqlite database is not storing my values
I am having a problem inserting my data into my sqlite database in expo. I have used every available technique I know, it just fails me.
I have already created the database in my App.js file, Now I am ...
- 11
0
votes
1
answer
540
views
Why do I get "no such table: <tablename>"?
I would like to implement an SQLite database in my Expo application. While following the official documentation I encountered this error:
→ Caused by: Error code: no such table: <tablename>]
...
- 191
1
vote
1
answer
139
views
A non-serializable value was detected in an action, in the path: payload
I am a novice developer, please tell me why an error occurs when calling initPayment: "A non-serializable value was detected in an action, in the path: payload. Value: [Error: Invalid hook call. ...
- 46
0
votes
1
answer
618
views
How to fix expo-sqlite problem in react-native app
sto sviluppando un applicazione mobile con react-native e volevo creare un database per memorizzare alcuni dati per non richiederli continuamente al server , ma sto avendo problemi .
these are the ...
0
votes
1
answer
507
views
how to use expo-sqlite react-native application problem
I’m developing an application and I would like to use a db to store data so I don’t constantly ask it to the server, but I’m having problems with expo-sqlite, can anyone explain me what I’m doing ...
0
votes
1
answer
818
views
How to handle errors in transactionAsync function of expo-sqlite properly?
I noticed that some errors are not being thrown.
Specifically errors caused by UNIQUE constraint, and duplicate primary keys.
export const insertMetricGroup = async (db: SQLite.SQLiteDatabase, name: ...
1
vote
2
answers
986
views
React native expo sqlite/next data is not showing in db file while file is open in DB Browser
I'm new to React Native Expo and I'm trying to use SQLite for storing data locally in my app. I followed a tutorial and managed to set up the database using the expo-sqlite package. Everything seems ...
1
vote
0
answers
60
views
Icons disappeared and expo image picker also not working in react native
I am working on expo-managed react native project. I am also using expo-sqlite for database purpose. Suddenly all icons from all screens in my project disappeared and expo image picker which was ...
- 19
0
votes
1
answer
1k
views
Where can I find the database for Expo-Sqlite? It's for my React Native activity
I am looking for the db file so that I can edit it with the db browser.
I tried looking for it but couldn't seem to find it. I heard that it's impossible to find with "expo-sqlite" instead ...
0
votes
0
answers
93
views
Issues using expo-sqlite in react native app to display records from a table
I'm doing a react native app to manage notes and tasks.
I have two tables for each one. The problem is:
I can save and display the notes without any problem. I try to do the same with the tasks. The ...
0
votes
1
answer
240
views
App "crashes" when navigating to a view with flatlist that renders data from sqlite
I'm a junior dev, I have a problem with an app I'm developing. I use react native, expo, and functional components.
The app crashes (goes to the default image set in the app.json) when I navigate to a ...
- 63
0
votes
1
answer
95
views
(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 ...
- 1
0
votes
0
answers
403
views
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",
//...
&...
- 1,497
1
vote
0
answers
961
views
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 ...
0
votes
1
answer
1k
views
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 ...
- 11
0
votes
1
answer
408
views
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 ...
- 35
2
votes
0
answers
242
views
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-...
- 21
1
vote
1
answer
840
views
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 ...
- 1,164
0
votes
0
answers
144
views
android app with react native expo doesn't work in offline mode
I've developed an android app with react native expo, this app depends on a static data where the database can be considered as a read only database where I've a (.db) file which contain all the data ...
- 1
0
votes
1
answer
387
views
Getting an sqlite error when running tests with Jest on react-native app
I am having trouble getting tests up and running with Jest for my react-native app (expo).
This is the simple test I am trying:
import React from 'react';
import renderer from 'react-test-renderer';
...
- 796
0
votes
0
answers
37
views
My app wasn't able to rerender on installation startup 'singleton' that I have created ONLY when I generate the apk file through eam build
My app wasn't able to rerender on installation startup 'singleton' that I have created ONLY when I generate the apk file through eam build.
It is working when I use expo-go I have click on one of the ...
- 436
-1
votes
1
answer
2k
views
expo: Cannot find find FileSystem properties and Asset while trying to import an existing database
I am new to react native.
I was trying to use expo-sqlite and following their guide under "Importing an existing database".
I have did 'expo install expo-file-system expo-asset`
I have ...
- 436
0
votes
1
answer
2k
views
Can local .db files be opened with Expo-Sqlite?
I'm building a react native application on mobile (IOS and Android) with Expo and already have a .db file created from SQLite in which to make transactions with.
I've seen examples of projects which ...
- 43
4
votes
1
answer
3k
views
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 ...
- 15.3k
0
votes
1
answer
1k
views
React Native app's expo-sqlite callback not executed until app refresh
I have a simple app that makes a connection to a sqlite database, reads results from that database, and displays them. Here is the app:
import React, { useEffect, useState } from 'react';
import { ...
- 371
0
votes
0
answers
167
views
How to use 'await/async' in react native?
I am getting isValidate value from sqlite and routing user to MainTabs or ValidateUser components. But I can not do it because it is not working async/await (Or I couldn't.).
initialRouteName will be ...
- 1
3
votes
0
answers
458
views
How to increase CursorWindow Size, Expo-SQLite?
Expo-SQL
const printSearchTable = () => {
db.transaction((tx) => {
tx.executeSql(
"select * from 'Literature'",
[],
(tx, res) =>
console.log(
...
0
votes
1
answer
2k
views
I encounter Error [Error: attempt to write a readonly database (code 1032 SQLITE_READONLY_DBMOVED)] using expo-sqlite
export async function insertAttempt() {
const db = await openDatabase()
try {
return await new Promise((resolve, reject) => {
db.transaction(
(tx) => {...
- 2,289
2
votes
1
answer
833
views
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, ...
- 158
0
votes
1
answer
1k
views
Delete query deletes entries from two tables with expo-sqlite
I have two really simple tables, without any constraint between them:
CREATE TABLE groups (groupId INTEGER PRIMARY KEY AUTOINCREMENT, groupName TEXT)
CREATE TABLE savedRuns (runId INTEGER PRIMARY KEY ...
- 3,808