Ionic React SQLite - Working With Ionic Framework And Capacitor

[@thepudgealicious]

Quick question with create connection.. If i have database versioning, would i have to input the latest version number instead of one, or is this handled? If so would store the latest version elswhere or grab it via a different connection first?

[@wsajjadh]

This is what I am looking for

[@AaronSaundersCI]

Glad it was helpful, please like, subscribe and share

[@ecliptic-day]

Thank you so much!

[@AaronSaundersCI]

glad you found the content helpful, please be sure to like and subscribe

[@gabrielamaralpassos9537]

There's just a little problem i'm facing that when i make more inserts in the same page, i have to chained useEffects or it just doesn't work. Not quite sure why still. I just observed this when building to Android by now, when using it in the browser it works fine.

[@AaronSaundersCI]

*SOURCE CODE* - github.com/aaronksaunders/ionic7-react-sqlite

[@sanatansam8424]

Is there a sample sqlite integration with ionic and angular, i.e. for the sqlite wasm integration ?

[@AaronSaundersCI]

I have one for react that I am working on, will post something soon

[@prenaysaidiska9603]

good explanation perfectyle understood , can u plzz make a video with same Ionic React SQLite - Working With Ionic Framework And Capacitor using how to register user and login by generating tokens

[@AaronSaundersCI]

thanks for coming through, appreciate it and please sub if you haven't yet. Are you trying to authenticate on the local device?

[@prenaysaidiska9603]

@@AaronSaundersCI thankyou for the reply . yes i want to authenticate user registration and login using jwt tokens store in localstorage with the help of ionic sqlite capacitor in reactjs

[@shafiqciku]

Where does the db in this project stored?sqlite file (.db)

[@AaronSaundersCI]

In root directory

[@RoseMiller-tv9jz]

hi! will you please make a similar thing with Angular??

[@AaronSaundersCI]

I will see if I can

[@davisdimalen3912]

Hi. I'm a getting a CapacitorSQLitePlugin: null error.

[@davisdimalen3912]

it happens when I call your custom hook useSQLiteDB

[@AaronSaundersCI]

Does the source code I provided work? If you are have an error, you will need to reproduce it in a minimal project, thanks

[@fuwamage1290]

All works in browser, but why in real android device not working?

[@AaronSaundersCI]

Did you download the code from the original project and run it? You can see from the repo there is an android folder so I know it was tested and running on device… did you watch the entire video you might have missed something

[@fuwamage1290]

I found the problem. It's because I didn't put the loadData() function in a useEffect (I put it in IonViewWillEnter). thank you anyway.

[@AaronSaundersCI]

@@fuwamage1290 glad you got it working

[@divpolitics9520]

Thank you, the documentation is a hot mess

[@AaronSaundersCI]

I think they are just trying to do way to much in one sample app and assuming a lot of domain knowledge

[@aksharparmar6599]

@@AaronSaundersCI yes Documentation of sqlite needs to improve. I'm having a hard time doing task