How to use SQLite in Ionic with Capacitor
Вставка
- Опубліковано 15 вер 2024
- Learn to add SQLite with Capacitor to your Ionic app to create offline apps with their own SQL Database included!
🔥 Learn Ionic FAST: ionicacademy.com/
👨💻 Full tutorial: ionicacademy.c...
#############################
❤️ You can also find me on:
Twitter: / schlimmson
TikTok: / simongrimm_
Instagram: / simongrimm_
#############################
Learn to build epic IONIC apps FAST by joining the Ionic Academy: ionicacademy.com/
Great video Simon! I believe that the best approach for sharing the private signal from the service is creating a public property that returns computed(this.users) or computed( () => this.users()); that way you get a read only version of the signal. Keep up the good work!
Yes indeed good idea Juan!
You read my mind, Simon. I am just looking for tutorials on SQLite. Thank you!
Happy to help!
aren't your Insert/delete queries prone for sql injection? also, why do you pass id as string in "updateUserById" when id in db schema is integer?
Obviously. This is for storing app data not vulnerable data. You are giving whole sqlite data to user through app.
For private data, u need to host own api and consume on frontend
Great video! Thanks a lot for all your content, Simon :) cheers from Argentina
My pleasure Juan!
Thank you for using signals
You're welcome!
I need help with my app I’m working on. And unsure if I will get what I need if I sign up with your website.
We have a private Discord channel for support of Ionic Academy members, yes!
wow this is great! SQL! I lv it
thanks, but what about the synchronization with a remote DB? for example each 5 minutes to sync the locally stored DATA with the Remote DB
this is what I was looking for😀
The sqlite introduced in the video is not the sqlite generally referred to. There is no sqlite file, rather this ionic sqlite is stored in the indexeddb. The naming is very confusing.
The fact you expect us to send your code to gpt to convert to React and don't provide the code make everything harder
How can I use the upgrade statement function to modify table structure for users that also have the app running?
Hi @Simon , wich extension did you use for generate code automatic. I special part of the video you say " uu compile you are very smart" wich extension is that?
That must be Github Copilot!
Man you're the best, but i got an error message, reading the query property, I think it's caused by the newUser=' '
did you solve it ?
Hi Simon,
I was wondering if you know of any ORM framework for Ionic (with Capacitor) that is compatible with Sqlite?
Thank you!
I'm also still looking for the best way to handle this, usually Prisma covers most cases..
I think TypeORM might be what you are looking for
Do you have a guide to how to upload file?
I have a problem, I follow the same steps but to React and by some reason the database dont work, the function is like dont be called
Same
Please please do it in react without typescript
excuse me but i want to know the difference between sqlite and mysql sever (like phpmyadmin). is it not possible to use mysql server and ionuc capacitor?
If you have a MySQL server you need an API to connect to the database from any app/website. SQLite is already bundled with any native app and can be used local and offline directly!
@@galaxies_dev it is very difficult for me to send data from ionic react capacitor page to my api
in my physical phone, it just showed the navbar, the rest is blank white screen. Why?
i have this same error, did you end up fixing it?
Yo my guy, you probs figured it out, but this guy fails to mention that there needs to be at least one entry in the db for it to show, he also forgets to show that he added an input to add new users, i just added them in and now it works like his.
@@JakebKnowles i forgot to fix it. May I see the github repo of it? Thanks
Awesome tutorial, thanls!
how do i use an existing .db file -- currently it is in the assets folder ? how can I run a .sql file?
you fix the problem or not ?
@@saadnatiqnori6543 yes
@@saadnatiqnori6543 If you need any pointers, I can help
what is that extension that suggests the code? anyone?
copilot
This example doesn't work with web applications.