Local SQLite Database for Expo React Native App with Import and Export Database from Device Files

[@lanigoespew]

Your content is simple and straight to the point, PLEASE don't stop making React-Native tutorials I'm actually begging hahaha.

[@indecisive.m]

Just wanted to leave a message to say thanks. This helped me so much. The Expo docs for this are really not overly helpful but you walked through it and thanks to you I managed to convert my app from using async storage to this.

[@chippandenga6722]

This was amazing. Phew! So much packed into 38 minutes. Loved the video and its content.💙

[@MissCoding]

Glad it helped!

[@kingogamer4358]

I was really for the need of local database and when i was searching for it you uploaded the video and that really helped aloooot thanks for that video

[@isurujn]

I came across your videos when I was searching for React Native tutorials. You have videos on some great topics and your teaching style is great too. Unfortunately I'm not using Expo. I wish there were more videos on React Native CLI as well.

[@wanwan-swagg]

React native have alot of bugs in it. Can't even symlink because it's unsupported.

[@corybcromer]

Love your tutorials!!! Question, how did you find out that the openDatabase func looks in the SQLite directory. I didnt see that anywhere in the docs, and I was looking forever. ahah.

[@sherlockbhone5268]

Thank you, you are a Sage , may you be prosperous and happy

[@realworldcodingapplications]

awesome, learned a lot from this, first time working w database for mobile app! very cool

[@henriqueantonio3019]

Thank you very much, here from Brazil :)))

[@emmanuelareiza9699]

Thanks bro suchs a great video you made , Greates wishes from COLOMBIA

[@andrejkling3886]

Excellent tutorial… thank you 💯

[@honoriotovela3029]

como se ja actualizaram

[@emilieclair]

thank you it is very useful but can you update it with the new functionalities of expo-sqlite? thank you, i'm stuggling with the documentation, more promesses are made and they added sync and async to functions. Thank you!

[@Evalionn]

Hi, Anyone tested this in release build? It’s not working when I build for release

[@mintmikasa]

Nice content! I'm considering using a local or remote database in my app data, mostly for cost reasons. I was wondering how much data is considered "too much" to be stored locally as far as performance and acceptable app sizes go? It's hard to get a gauge of that without actually ingesting my data into my own sqlite db first, so I was wondering if you had any experience with that. Thanks!

[@supp3rv1ctor]

Do you know anything about SQLite working perfectly on Expo Go, and after generating a build it doesn't work on the device?

[@Hari-xu1zb]

How to get example.db file path? and how to example.db file open DB browser for Sqlite tool

[@Tony-jr3ki]

Thank you for the awesome video. How would you go about accessing the database from different components? Is it necessary to use some sort of global state for that? So we wouldn't create an instance of db access in each component? Or is there some other way to do that?

[@Sparrow-tn9jj]

Nice tutorial. Thank you very much

[@mrwenr0347]

Thank you! Very helpful video!❤

[@shehzadpasha6583]

Thank you for explaining SQLite. I followed the steps mentioned in the video, on iOS it works fine, but on Android I am unable to import the database. It exports well, import is done without errors, but the database table shows no record. Any suggestions?

[@AK-kq1mk]

Did you figure it out?

[@MunibDalati]

same problem here

[@failogy]

same problem. pls tell me if you know.

[@QianZhiwei]

Cool! Thank you!

[@jeka2233]

Thank you so much for the tutorial miss coding,could you tell me please how to delete the database from sqlite?

[@ricardoyanez9464]

wow! awesome video, thanks. Good voice.

[@zelvrs]

please make import and export sqlite for wal mode cause i've already set the mode to wal mode and now i've got 3 different file .db, -wal, and -shm 🙏

[@AlejandroHernandez-mh5om]

I hope you can help me, I'm making an app and I have to download information with an API and host it locally, but I have a question, is there any way to know when the information I'm downloading finished and was saved in the SQLite table? By the way, the video is great.

[@alirezascript]

Thanks for that

[@argames1578]

Great Video thank you very much :)

[@erdincparlak7092]

Teşekkürler. Çok güzel bir bir anlatım.

[@veleskarlsruhe]

Hi MissCoding, thank for the video. I was looking for a longer time how do I integrate an SQLite into React Native Expo app. And finally came across to you :). I have an issue TypeError: undefined is not an object (evaluating 'ExponentSQLite.exec') when running the app locally (Windows). On the Snack it runs fine. Do you have any idea what it could be? On the internet is only one (?!) post on this topic, which does not have the solution for an expo managed workflow.

[@veleskarlsruhe]

Hi again, I solved the issue "ExponentSQLite.exec" by myself. It was about running "npx expo start" in the GitBash-Terminal. As soon as I started the terminal out of the Visual Studio Code everything was fine. I am using the Android simulator

[@Evalionn]

Hii Did you build your app for release?

[@veleskarlsruhe]

@@Evalionn Hi, no, I am not that far yet.

[@nunomonteiro9808]

for some reason, i did like you, but i can't get the names from database....

[@AKProductionsTelugu]

😂😂

[@johnkumar958]

Very useful

[@9alotaibi]

Greate Work Thank you

[@programmingwithnit5308]

Thank you so much 🎉❤

[@desainad]

Under which folder does it store the database? If I have to select from an existing database, where should I place this in the project folder? I am using Windows 10.

[@Sparrow-tn9jj]

import * as FileSystem from 'expo-file-system' const FOLDER_PATH = `${FileSystem.documentDirectory}`

[@tienphanmemtinh8207]

Can you share this demo code ?

[@GeorgeFlorian12]

Unfortunately, Expo moves so fast that nothing from this video works now. Even `expo` as a command is deprecated. Not to mention expo-sqlite had an overhaul.

[@tabata2680]

Hey do you know some place that made this (sqlite crud in js for react native)but with the new update? I tried to follow the new expo-sqlite doc but I'm still new with this and cant do it by myself with just the documentation to follow

[@yassinesaid4687]

Thank ya sis

[@AlejandroHernandez-mh5om]

Hello, thank you very much for your tutorial, it is excellent, but I have an error and I don't know what it refers to: [Error: no such table: names (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT * FROM names, (OS error - 2:No such file or directory)] Could anyone help me

[@anyahayes3601]

Can you show the code surrounding your select statement?

[@AlejandroHernandez-mh5om]

@@anyahayes3601 Hello, thank you for answering, but I have already been able to see what happened, it was my mistake when writing the statement to create the table. Apologies.

[@nazmossakib2540]

@@AlejandroHernandez-mh5om I am facing the same problem....can u please help me to fix this?

[@kingogamer4358]

Can you upload a video on expo in app purchase how to do that thanks in advance

[@amiribrahim01]

thank you

[@chrisnk7066]

Unable to resolve "expo-sqite"

[@MissCoding]

Try expo-sqlite 😀

[@Lee95pl]

Hey! Thanks for the video, very informative :) It seems that link to your repo is broken.

[@MissCoding]

Thank you very much, I accidentally had it as private but I’ve fixed that now :)

[@xgcwrought3346]

Love the content wanna network on linkdin?

[@draigan]

why does your filetree take up half the screen so u have to keep going back and fourth...

[@mikhailman]

The person is creating a free tutorial on a specific topic helping others with their developer journeys for nothing in return, and the only thing you could come up with is a half-assed critique of their IDE layout? Pathetic.

[@carloojeda-e1e]

What a waste of time

[@neerajtangariya4067]

Hey hi , Nice video. In this demo application you've used the expo-sqlite. what if I prefer to use this npm package instead of expo-sqlite? react-native-sqlite-storage because if i use the react native with cli then we have to do lot of configuration with expo in bare application.

[@espial5789]

Hello, I really liked the video. I ask you a question, I am trying to create 2 tables in the same transaction, is this possible? I do the following: const db = SQLite.openDatabase('acm1pt.db'); var sql = ` CREATE TABLE IF NOT EXISTS users ( guid INTEGER PRIMARY KEY AUTOINCREMENT, id TEXT, user_name TEXT, session TEXT, date_init TEXT ); CREATE TABLE IF NOT EXISTS orders ( guid INTEGER PRIMARY KEY AUTOINCREMENT, id TEXT, account_id TEXT, account_name TEXT, case_number TEXT ); `; db.transaction(tx => { tx.executeSql(sql, [], (tx, result) => { resolve('The database was created ' + name + ' en ' + dbPath); }, (error) => { reject('Error executing SQL query - Error: ' + error.message); }); }); Only the first table is created and the second one is not created....