No video :(

React Native Tutorial #25 - SQLite Database - How to make an Offline Login with SQLite

Подписаться 22 тыс.

Просмотров 84 тыс.

50% 1

🔥 Get a discount on 'The Complete React Native Course 2023: from Zero to Hero' on Udemy by using the promo code D782E3. As the instructor, I'll be there to answer any technical questions you may have. Plus, you'll get access to more exams and coding exercises, updated content, and no background music or ads. After completing the course, you can get a valid certificate on Udemy to showcase your skills. Click the link below to enroll now with the discount.
www.udemy.com/...
--------------------------------------------------------------------------------
🌟 In this session, we learn about SQLite as a local database and use it to build an offline login.
--------------------------------------------------------------------------------
🔥 The Complete React Native Course:
• The Complete React Nat...
💻 Project Source Code in GitHub:
github.com/mah...
🔗 SQLite module:
github.com/and...
🔗 SQLite useful links:
www.sqlite.org
www.sqlitetuto...
--------------------------------------------------------------------------------
😍 Subscribe my channel for more React Native Tutorials:
www.youtube.co...
💝 Join my channel to get access to perks:
/ @mashschool
--------------------------------------------------------------------------------
⏱️ Timestamps:
React Native Tutorial #25 - SQLite Database - How to make an Offline Login with SQLite
00:00 Intro
00:54 install react-native-sqlite-storage
01:33 Open Database
02:24 Create Table
03:50 Insert Into Table
05:30 Select From Table
08:04 Update Table
09:23 Delete From Table
10:37 SQLite Browser
--------------------------------------------------------------------------------
#ProgrammingWithMash #ReactNative #SQLite

Опубликовано:

18 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 73

@mashschool 3 года назад

If you have any questions about this or request tutorials in this style, be sure to leave a comment below, and thank you for liking the video. 😉

@nakidm 3 года назад

Hey Mash nice video, im new on RN and im "old" programmer php html u think is better this? or use firebase/aws for RN apps ? :) thanks

@mashschool 3 года назад

@@nakidm It's my pleasure! Here SQLite is used for offline purpose. Firebase and AWS are definitely used for online purposes.

@saileklaj 2 года назад

hello, how can i connect react-native with sqlserver, thanks

@swathyraja04swa24 Год назад

hi, How do work search bar?

@sangsokea 2 года назад

Your tutorial clearer than the course I bought on Udemy.

@mashschool 2 года назад

Great to hear!

@geoffreyngugi6144 2 года назад

This is the best and my first tutorial that actually works. It made you just made sqlite super simple. I also have already checked tutorial #28 and #29. Local and remote notifications have never been that simple. Asante(thanks)

@mashschool 2 года назад

Glad it helped! You're welcome.

@MedlegNem 8 месяцев назад

Absolutely perfect tutorial. Thank You very much and good wishes for you.

@tom-vq1bj 2 года назад

It helped me a lot, congratulations on the class!

@voldemore6300 Год назад

Hi Mash, I do have a question, where would you put the "MainDB.db" file on ?? it seemed like you just created it from the empty file. Basically, when I use SQL on react.js we specify items such as localhost, username, password and database_name. but for sqlite they are not required ?? Im so confused TT

@SangNguyen-ej1ef 2 года назад

Thanks God! Thanks to your video I solved some database bugs in my project.

@mashschool 2 года назад

You're welcome!

@sanilkp6180 2 года назад

Thank you very much!

@karthiknandula8702 2 года назад

How did u connect the database to the SQLite browser? I want to view that DB on the SQLite browser...

@gastonecappuccio7864 Год назад

did you found a way to do that?

@blanf7559 3 года назад

Thank you! Very good video!

@mashschool 3 года назад

Glad you liked it!

@aigirimedia 6 месяцев назад

very good

@muhammadsuleman9342 Год назад

Awesome content but Not Satisfied with such time consuming things. If you are creating tutorial on specific topic you should write code from start for it. Why you are making it mandatory to watch your previous videos of navigation for proper understanding. not everyone here is expert and use same method. hope you get my point. your tutorial should be independent on the previous ones. if you want to add navigation in sqlite tutorial then kindly write it from start so that we can have better understanding. Thanks.

@ericlol1337 2 года назад

thanmks maush

@joanneko3953 2 года назад

this is for react native cli right? what about expo? how do we integrate sqlite on expo?

@aazamheidari4689 2 года назад

Your tutorial is great and clear, and how can I use cascading delete . I search a lot but, I can not find the right code

@asimnehal3953 8 месяцев назад

very helpful....how to export my db file from my react native app..?

@Mrkhan-yz8to 2 года назад

always the best tutorial ever

@mashschool 2 года назад

Glad you think so!

@purnamasrahayu6850 2 года назад

how to connect to database in device / emulator?

@deepakkiriti5932 Год назад

hi mash great tutorial can you help me how to store the pedometer data coz there wont be any buttons to set update data

@arikmosfor4907 3 года назад

wow!! great tutorial 🔝🔝

@mashschool 3 года назад

Thanks! 😃

@mememonster2370 5 месяцев назад

why copy pasting db = opendatabase in each files?

@bartdiako1 3 года назад

Hi Mash! Thanx for making these videos theay have realy halped me out withe school .A bigg high five to you bro. Could you makee a video about SecureStore?

@mashschool 3 года назад

You're welcome. Yes, I will explain it on an expo project.

@bartdiako1 3 года назад

@@mashschool And also Testig/jest in react native expo and cli?

@mashschool 3 года назад

@@bartdiako1 We will have it at the end of this series.

@weixiangng8279 17 дней назад

Mine has lots of errors like cannot open the database.

@80Vikram 2 года назад

Thanks for this tutorial, can you please clarify if SQLite DB gets installed on emulator or your laptop ?

@santuclicks8169 Год назад

How do you access db in Home page.

@ahmedsiddique863 11 месяцев назад

p.SQLite is undefined giving this error when creating the database

@abhijeetshikharvlog1444 2 года назад

In emulator is working fine but when i test in mobile its not working.Please tell the solution

@realtorBG 3 года назад

if you do some series with netlify, context or firebase will be great Mash

@mashschool 3 года назад

That's a good idea! I will work on it.

@bobbycheema5168 3 года назад

Can you show an example with date and time field

@thebeatifulnature3142 3 года назад

Please bro continue this series

@mashschool 3 года назад

You can find the continuation of the series in the playlist. We have a new session every week.

@codebase_dev Год назад

How to pre-populated database in react-native ?

@muhammadhamzaqadri1548 3 года назад

This database is better to use for confidential things like password? Another thing is that it can be use alternative to local storage

@mashschool 3 года назад

Anyone can read the file of this database, so it's not suitable for many confidential cases. Instead of storing passwords, it's better to use token-based authentications. If you have a lot of data to store and need to fetch the information you need, then local databases like SQLite are the best local storage.

@akashwaghule 3 года назад

Hello Mash, big fan, could you help us with the setup process.

@mashschool 3 года назад

Hi, If you mean setting up a react native project, watch video # 3 and tell me if there is a problem.

@darrellleong4780 Год назад

This doesn't work with Expo?

@user-yk8ce2zj1y 3 года назад

i have an error when npm install .................. npm ERR! Unexpected token d in JSON at position 0 while parsing near 'dEasing, // @ts-i...' How I can fix it.

@user-yk8ce2zj1y 3 года назад

it's already fix

@tienphanmemtinh8207 4 месяца назад

Can you share the code for this video ?

@arjunpatidar4295 2 года назад

Unable to open database getting this error "[Error: Could not open database]"

@michaeljameslao4599 2 года назад

Any way to connect to an MSSQL server database?

@mashschool 2 года назад

It's not safe to connect directly to the MS SQL database. But you can do it by this module in Android. www.npmjs.com/package/react-native-mssql

@pablo9658 3 года назад

Hi, is it the same process for IOS?

@mashschool 3 года назад

Yes, it works in iOS.

@gustavojuantorena 3 года назад

👏👏

@sahaphonmukphet6336 2 года назад

i found error "message" no such table Users.. how to fix?

@pradyumnakubear8561 2 года назад

same here how to solve it if you have solution could you please reply me bro

@mehmeteminozen6203 Год назад

Its been a long time but i got same error, and i just realized i typed name wrong in the second page. You should check your names.

@muhammetaydinn Год назад

make new table with different name or delete table and make new table

@vantungpham159 3 года назад

can you answer my question in the previous video ?

@mashschool 3 года назад

I answered it. Good luck.

@vantungpham159 3 года назад

@@mashschool next video you can guide about Reactotron debugger ?

@nunomonteiro9808 4 месяца назад

i did just like you, but it is not inserting neither selecting.... and I did just like you...

@movierockers3452 3 года назад

How we can export sqlite file using react native ? Is it possible to connect ms sql ?

@mashschool 3 года назад

You can use the createFromLocation option in the openDatabase method to save the database to your desired path and use its file. You can connect to ms sql remotely using the react-native-mssql module.