Local SQLite Database for Expo React Native App with Import and Export Database from Device Files
HTML-код
- Опубликовано: 17 окт 2024
- Hi everyone!
Today I am going to show you how to create an app that connects to a local database. I will cover the basic CRUD operations of creating (insert), reading (select), updating (update) and deleting (delete) records. I will also cover creating a table.
Sometimes you may want to import/export your database so I will also cover this.
If you would like to see my expo-sqlite example, the source code is available on my GitHub:
github.com/che...
For the expo-sqlite documentation you can see the expo documentation:
docs.expo.dev/...
To learn about sqlite queries:
www.sqlitetuto...
You’ve clearly come here to learn and a free audible trial allows you to increase your learning potential in situations where you may be hands free like at the gym or on your commute. It allows you to spend more time on theory when you aren’t able to watch a screen, so that you can maximise your screen time to pick up technical skills. Try it for free today:
amzn.to/49NX6Xe
// ABOUT ME
My name is Chelsea and I started studying software engineering in 2010. I have been working commercially full time since 2014 and have been in various positions from graduate developer to tech lead to solution architect.
I'm a full stack developer with a lot of experience in C# and Javascript but my passion is for mobile development; specifically native iOS development and cross platform using React Native.
I always have many things on the go and am always trying out a new side hustle and failing at it; perhaps you can learn from my mistakes!
Please like and subscribe if you enjoyed this video and want to see more like it!
Have any suggestions on topics you would like to learn more about? Please suggest them in the comments... I would love to help you out while doing a bit of learning myself!
// PRODUCTS USED
I use the following products in the creation of my videos:
Boya MM1 Microphone - amzn.to/3uupmOB
A reasonable quality and reasonably sturdy but cost effective microphone that can be used by both DSLR cameras, mobile phones and laptops
Canon 18-55mm Lens - amzn.to/3QYYdLk
A kit lens but a decent quality lens for beginners getting used to a DSLR
Canon EOS Rebel T7 with 18-55mm Lens - amzn.to/3GdRPuq
This is the kit I started with it includes the lens linked above and is a great starter camera.
I love Apple devices... These are the ones I use for my channel content creation:
Apple iPhone 13 - amzn.to/3G8pHcl
A good all round phone, good for Apple development and recording videos with enough high quality features but at a cheaper price point than the pro versions.
Apple MacBook Pro - amzn.to/3MUuPV8
A nice portable computer for working from anywhere and perfect for iOS development
Apple iPad Air - amzn.to/49LvYrY
Really easy to use for graphic design if required for logos as part of my app development or editing the videos on the go.
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!
//CONTACT:
Please contact me at: hello@tripwiretech.com
//CRAVING MORE:
You can find links to all my different sites and social media over on Linktree: linktr.ee/miss...
Your content is simple and straight to the point, PLEASE don't stop making React-Native tutorials I'm actually begging hahaha.
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.
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.
This was amazing. Phew! So much packed into 38 minutes. Loved the video and its content.💙
Glad it helped!
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
Do you know anything about SQLite working perfectly on Expo Go, and after generating a build it doesn't work on the device?
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!
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?
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.
React native have alot of bugs in it. Can't even symlink because it's unsupported.
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!
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.
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?
Did you figure it out?
same problem here
same problem. pls tell me if you know.
Hi,
Anyone tested this in release build? It’s not working when I build for release
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.
Thank you so much for the tutorial miss coding,could you tell me please how to delete the database from sqlite?
How to get example.db file path? and how to example.db file open DB browser for Sqlite tool
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.
import * as FileSystem from 'expo-file-system'
const FOLDER_PATH = `${FileSystem.documentDirectory}`
Thank you, you are a Sage , may you be prosperous and happy
awesome, learned a lot from this, first time working w database for mobile app! very cool
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 🙏
for some reason, i did like you, but i can't get the names from database....
😂😂
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.
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
Hii
Did you build your app for release?
@@Evalionn Hi, no, I am not that far yet.
Thanks bro suchs a great video you made , Greates wishes from COLOMBIA
Excellent tutorial… thank you 💯
como se ja actualizaram
Thank you very much, here from Brazil :)))
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
Can you show the code surrounding your select statement?
@@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.
@@AlejandroHernandez-mh5om I am facing the same problem....can u please help me to fix this?
Can you share this demo code ?
Nice tutorial. Thank you very much
Thank you! Very helpful video!❤
Can you upload a video on expo in app purchase how to do that thanks in advance
Unable to resolve "expo-sqite"
Try expo-sqlite 😀
wow! awesome video, thanks. Good voice.
Hey! Thanks for the video, very informative :) It seems that link to your repo is broken.
Thank you very much, I accidentally had it as private but I’ve fixed that now :)
Teşekkürler. Çok güzel bir bir anlatım.
why does your filetree take up half the screen so u have to keep going back and fourth...
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.
Cool! Thank you!
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.
Great Video thank you very much :)
Thanks for that
Thank you so much 🎉❤
Very useful
Greate Work Thank you
Thank ya sis
thank you
Love the content wanna network on linkdin?
What a waste of time
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....