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

[@mashschool]

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]

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]

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

[@saileklaj]

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

[@swathyraja04swa24]

hi, How do work search bar?

[@sangsokea]

Your tutorial clearer than the course I bought on Udemy.

[@mashschool]

Great to hear!

[@tom-vq1bj]

It helped me a lot, congratulations on the class!

[@geoffreyngugi6144]

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]

Glad it helped! You're welcome.

[@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

[@MedlegNem]

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

[@sanilkp6180]

Thank you very much!

[@SangNguyen-ej1ef]

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

[@mashschool]

You're welcome!

[@blanf7559]

Thank you! Very good video!

[@mashschool]

Glad you liked it!

[@karthiknandula8702]

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?

[@aigirimedia]

very good

[@joanneko3953]

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

[@ericlol1337]

thanmks maush

[@aazamheidari4689]

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

[@purnamasrahayu6850]

how to connect to database in device / emulator?

[@asimnehal3953]

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

[@mememonster2370]

why copy pasting db = opendatabase in each files?

[@arikmosfor4907]

wow!! great tutorial 🔝🔝

[@mashschool]

Thanks! 😃

[@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

[@Mrkhan-yz8to]

always the best tutorial ever

[@mashschool]

Glad you think so!

[@weixiangng8279]

Mine has lots of errors like cannot open the database.

[@80Vikram]

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.

[@bartdiako1]

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]

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

[@bartdiako1]

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

[@mashschool]

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

[@abhijeetshikharvlog1444]

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

[@bobbycheema5168]

Can you show an example with date and time field

[@darrellleong4780]

This doesn't work with Expo?

[@tienphanmemtinh8207]

Can you share the code for this video ?

[@codebase_dev]

How to pre-populated database in react-native ?

[@realtorBG]

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

[@mashschool]

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

[@ahmedsiddique863]

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

[@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.

[@thebeatifulnature3142]

Please bro continue this series

[@mashschool]

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

[@akashwaghule]

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

[@mashschool]

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

[@arjunpatidar4295]

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

[@วีนารัตน์แสวงกิจ]

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.

[@วีนารัตน์แสวงกิจ]

it's already fix

[@muhammadhamzaqadri1548]

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

[@mashschool]

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.

[@movierockers3452]

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

[@mashschool]

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.

[@michaeljameslao4599]

Any way to connect to an MSSQL server database?

[@mashschool]

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

[@gustavojuantorena]

👏👏

[@pablo9658]

Hi, is it the same process for IOS?

[@mashschool]

Yes, it works in iOS.

[@sahaphonmukphet6336]

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

[@pradyumnakubear8561]

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]

can you answer my question in the previous video ?

[@mashschool]

I answered it. Good luck.

[@vantungpham159]

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

[@nunomonteiro9808]

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