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!

#############################

❤️ You can also find me on:

#############################

[ellenweng]

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

[eliphasmasuka]

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.

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

[juanarielbrusco]

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

[GamerNut]

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.

[yanntrad]

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.

[eduardasslutas]

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?

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

[tamhuynh]

Hi Simon,

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

Thank you!

[nodiced]

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

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

[bennyzimmer]

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

[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

[AGUNGKAYA]

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

[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

[gabrielamaralpassos]

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

[neura]

what is that extension that suggests the code? anyone?

[zearwinandallo]

Do you have a guide to how to upload file?

[alexreyes-cnru]

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

[marxman]

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.