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

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 73

  • @mashschool
    @mashschool  3 роки тому +4

    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
      @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
      @mashschool  3 роки тому +1

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

    • @saileklaj
      @saileklaj 2 роки тому

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

    • @swathyraja04swa24
      @swathyraja04swa24 Рік тому

      hi, How do work search bar?

  • @sangsokea
    @sangsokea 2 роки тому +11

    Your tutorial clearer than the course I bought on Udemy.

  • @geoffreyngugi6144
    @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
      @mashschool  2 роки тому

      Glad it helped! You're welcome.

  • @MedlegNem
    @MedlegNem 9 місяців тому

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

  • @tom-vq1bj
    @tom-vq1bj 2 роки тому +1

    It helped me a lot, congratulations on the class!

  • @SangNguyen-ej1ef
    @SangNguyen-ej1ef 2 роки тому

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

  • @voldemore6300
    @voldemore6300 Рік тому +6

    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

  • @sanilkp6180
    @sanilkp6180 2 роки тому

    Thank you very much!

  • @blanf7559
    @blanf7559 3 роки тому

    Thank you! Very good video!

  • @aigirimedia
    @aigirimedia 6 місяців тому

    very good

  • @karthiknandula8702
    @karthiknandula8702 2 роки тому +3

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

  • @ericlol1337
    @ericlol1337 2 роки тому

    thanmks maush

  • @aazamheidari4689
    @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

  • @Mrkhan-yz8to
    @Mrkhan-yz8to 2 роки тому

    always the best tutorial ever

  • @asimnehal3953
    @asimnehal3953 8 місяців тому

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

  • @joanneko3953
    @joanneko3953 2 роки тому +1

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

  • @bartdiako1
    @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
      @mashschool  3 роки тому +1

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

    • @bartdiako1
      @bartdiako1 3 роки тому

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

    • @mashschool
      @mashschool  3 роки тому +1

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

  • @deepakkiriti5932
    @deepakkiriti5932 2 роки тому

    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
    @arikmosfor4907 3 роки тому

    wow!!
    great tutorial 🔝🔝

  • @muhammadsuleman9342
    @muhammadsuleman9342 Рік тому +2

    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.

  • @purnamasrahayu6850
    @purnamasrahayu6850 2 роки тому +1

    how to connect to database in device / emulator?

  • @realtorBG
    @realtorBG 3 роки тому

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

    • @mashschool
      @mashschool  3 роки тому

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

  • @thebeatifulnature3142
    @thebeatifulnature3142 3 роки тому

    Please bro continue this series

    • @mashschool
      @mashschool  3 роки тому

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

  • @akashwaghule
    @akashwaghule 3 роки тому

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

    • @mashschool
      @mashschool  3 роки тому

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

  • @bobbycheema5168
    @bobbycheema5168 3 роки тому

    Can you show an example with date and time field

  • @mememonster2370
    @mememonster2370 6 місяців тому

    why copy pasting db = opendatabase in each files?

  • @80Vikram
    @80Vikram 2 роки тому

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

  • @weixiangng8279
    @weixiangng8279 Місяць тому

    Mine has lots of errors like cannot open the database.

  • @muhammadhamzaqadri1548
    @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
      @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.

  • @ahmedsiddique863
    @ahmedsiddique863 11 місяців тому

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

  • @codebase_dev
    @codebase_dev Рік тому

    How to pre-populated database in react-native ?

  • @santuclicks8169
    @santuclicks8169 Рік тому

    How do you access db in Home page.

  • @abhijeetshikharvlog1444
    @abhijeetshikharvlog1444 2 роки тому

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

  • @user-yk8ce2zj1y
    @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.

  • @darrellleong4780
    @darrellleong4780 Рік тому

    This doesn't work with Expo?

  • @arjunpatidar4295
    @arjunpatidar4295 2 роки тому

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

  • @tienphanmemtinh8207
    @tienphanmemtinh8207 5 місяців тому

    Can you share the code for this video ?

  • @movierockers3452
    @movierockers3452 3 роки тому

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

    • @mashschool
      @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.

  • @gustavojuantorena
    @gustavojuantorena 3 роки тому

    👏👏

  • @michaeljameslao4599
    @michaeljameslao4599 2 роки тому

    Any way to connect to an MSSQL server database?

    • @mashschool
      @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
    @pablo9658 3 роки тому

    Hi, is it the same process for IOS?

  • @sahaphonmukphet6336
    @sahaphonmukphet6336 2 роки тому

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

    • @pradyumnakubear8561
      @pradyumnakubear8561 2 роки тому

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

    • @mehmeteminozen6203
      @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
      @muhammetaydinn Рік тому

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

  • @vantungpham159
    @vantungpham159 3 роки тому

    can you answer my question in the previous video ?

    • @mashschool
      @mashschool  3 роки тому

      I answered it. Good luck.

    • @vantungpham159
      @vantungpham159 3 роки тому

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

  • @nunomonteiro9808
    @nunomonteiro9808 5 місяців тому

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