How to use SQLite in Ionic with Capacitor

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.com/sqlite-ionic...
#############################
❤️ You can also find me on:
Twitter: / schlimmson
TikTok: / simongrimm_
Instagram: / simongrimm_
#############################

[@galaxies_dev]

Learn to build epic IONIC apps FAST by joining the Ionic Academy: ionicacademy.com/

[@ellenweng3668]

You read my mind, Simon. I am just looking for tutorials on SQLite. Thank you!

[@galaxies_dev]

Happy to help!

[@eduardasslutas6624]

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?

[@juanarielbrusco]

Great video! Thanks a lot for all your content, Simon :) cheers from Argentina

[@galaxies_dev]

My pleasure Juan!

[@juanmluces]

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!

[@galaxies_dev]

Yes indeed good idea Juan!

[@jbwesleyster]

this is what I was looking for😀

[@AGUNGKAYA]

wow this is great! SQL! I lv it

[@bennyzimmer8342]

How can I use the upgrade statement function to modify table structure for users that also have the app running?

[@wespug]

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?

[@galaxies_dev]

That must be Github Copilot!

[@GamerNut999]

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.

[@galaxies_dev]

We have a private Discord channel for support of Ionic Academy members, yes!

[@DavidSchmidt07]

Thank you for using signals

[@galaxies_dev]

You're welcome!

[@tamhuynh772]

Hi Simon, I was wondering if you know of any ORM framework for Ionic (with Capacitor) that is compatible with Sqlite? Thank you!

[@galaxies_dev]

I'm also still looking for the best way to handle this, usually Prisma covers most cases..

[@edwinquaihoi8503]

I think TypeORM might be what you are looking for

[@user-fx4qq8ek2s]

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?

[@galaxies_dev]

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!

[@kangnifredable]

@@galaxies_dev it is very difficult for me to send data from ionic react capacitor page to my api

[@nodiced1]

how do i use an existing .db file -- currently it is in the assets folder ? how can I run a .sql file?

[@saadnatiqnori6543]

you fix the problem or not ?

[@nodiced1]

@@saadnatiqnori6543 yes

[@nodiced1]

@@saadnatiqnori6543 If you need any pointers, I can help

[@zearwinandallo1199]

Do you have a guide to how to upload file?

[@hazhohuman]

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

[@Julio_Bandeira]

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

[@gabrielamaralpassos9537]

Same

[@neura3964]

what is that extension that suggests the code? anyone?

[@XXsupersonicZZ]

copilot

[@isaiah-dev]

Awesome tutorial, thanls!

[@RavenXplod]

Please please do it in react without typescript

[@alexreyes-cn9ru]

Man you're the best, but i got an error message, reading the query property, I think it's caused by the newUser=' '

[@kotaibakd8300]

did you solve it ?

[@AGUNGKAYA]

in my physical phone, it just showed the navbar, the rest is blank white screen. Why?

[@user-wh1qq4eg7w]

i have this same error, did you end up fixing it?

[@user-wh1qq4eg7w]

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.

[@AGUNGKAYA]

@@user-wh1qq4eg7w i forgot to fix it. May I see the github repo of it? Thanks

[@marxman1010]

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.

[@gabrielamaralpassos9537]

The fact you expect us to send your code to gpt to convert to React and don't provide the code make everything harder

[@RealGamePanda]

This example doesn't work with web applications.