How to use SQLite in Ionic with Capacitor

[@galaxies_dev]

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

[@eliphasmasuka5730]

Thank you thats a great video. Is adding an ORM doable for Sqlite. I have an app that focuses on offline sync so quiet a lot sqlite usage.

[@ellenweng3668]

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

[@galaxies_dev]

Happy to help!

[@yanntrad2304]

tanks for it ! I'm trying to make two pages (listeOfClients and AddClientForm) but when I try to add clients and go back to the listeClient page, nothing got from the DBB. But when i implement the addclientform in the same page of listOfclients it works... Thank for your help.

[@Diego-rw5fs]

what was the home.page.html code?

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

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

[@ankit.chaurasia]

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

[@GamerNut420]

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!

[@juanarielbrusco]

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

[@galaxies_dev]

My pleasure Juan!

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

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

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

[@EvTIC]

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

[@bennyzimmer8342]

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

[@AGUNGKAYA]

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

[@JakebKnowles]

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

[@JakebKnowles]

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]

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

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

[@AGUNGKAYA]

wow this is great! SQL! I lv it

[@neura3964]

what is that extension that suggests the code? anyone?

[@XXsupersonicZZ]

copilot

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

[@DavidSchmidt07]

Thank you for using signals

[@galaxies_dev]

You're welcome!

[@jbwesleyster]

this is what I was looking for😀

[@isaiah-dev]

Awesome tutorial, thanls!

[@zearwinandallo1199]

Do you have a guide to how to upload file?

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

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

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

[@RavenXplod]

Please please do it in react without typescript

[@RealGamePanda]

This example doesn't work with web applications.