Capacitor Storage, Ionic Storage or SQLite - What’s the difference?

[@gokuldev3014]

Despite limitations, Ionic is the best framework ! even though there is documentation and stuffs, you do make it easy for us to understand and code super fast 🔥 awesome ! ☺️

[@fjerbi]

I’ve been working with Ionic the last two years, but with all due respect react-native is far better. Ionic is dying, that’s sad, but yeah .

[@galaxies_dev]

My pleasure!

I would really like some video about security inside ionic, like some basics about the best way and process to safely store data on web application, storing data in preferences and stuff like that, where to store conection string or sensible data and how to make a safe login enviroment. All of this just to make a safer app

[@galaxies_dev]

Thanks for the recommendations Gustavo, good and valid points!

[@serjmalko6246]

@@galaxies_dev, Yes, it is will be very use full!

[@JaroNavales]

Pouchdb + ionic please :)

[@elenanikolovska1270]

If i plan on making a chat and storing it locally is sqlite the best way?

[@samucancld]

Which plugin do you recommend to use SQLite with ionic 7 on capacitor 4?

[@adeelali5948]

Hi sir Can you make a video on web rtc video calling in ionic.. Really need that one .

[@kelubboy]

Yes please I would really appreciate this. Ionic + capacitor + webrtc

[@tobiasrappo]

Thanks for this. Just doing SQLite ;)

[@thamindujanaka1261]

Hi Simon, Your channel is really help full for me as a Hybrid application developer. I have watch almost all videos you post. I Have one request that is really for my project i need to manage versions in automatic way. i recently heard that there is a project (Trapeze). which will allow to manage versions in both Android and ios. i just check the documentation but not able to find any solution with real implementation. I m using ionic capacitor for my hybrid project. will you be able to post a video on how can this be done in ionic capacitor project Thanks in Advance

[@galaxies_dev]

You can search my video "Capacitor configure" because it was called like that before, and I also explained Trapeze in the livestream from yesterday (video should be available as well!)

[@EvTIC]

hi ok i have a question. But sometimes we want to store the trafic data on an external database. by myself i use phpmyadmin, but i find to much difficulties to connect ionic to phpmyadmin to save information. I am on ubuntu

[@gabrielamaralpassos9537]

I'm really finding it really hard to use SQLite in my ionic react app, but i need it. Wish me luck

[@xigbar02]

Maybe I missed something but if I want to save 2,3 pictures and some string data for an ionic capacitor project, ionic storage is an option, no?

[@galaxies_dev]

Sure Ionic Storage is a very valid option in that case!

[@scottmcmahon7209]

Will I need to use something like capacitor to enable the app that I built with ionic5 to upload photos such as profile pictures that I will then send to my server?

[@maximusmmax]

Which one would you use to store images?

[@galaxies_dev]

I would actually store images as files on the FS and store a reference to them!

[@usanzadunje]

I have auth token to store and use ionic storage without sqlite. Should i install adapter for it for better security? Does sqlite provide vetter security? Thanka for info!

[@galaxies_dev]

SQLite gives more persistence on a device, so it's maybe not more secure but definitely more reliable!

[@_back_to_the_time_]

Waiting for this😍

[@TheRealSharky]

Hi Simon, when accessing a SQLite with Ionic Storage, is it also "cleaned up" from time to time by Android or iOS? Or is the data stored securely and permanently in this case? And how can I check if SQLite is actually used in the background?

[@galaxies_dev]

SQLite won't be cleared by the OS like localstorage of the browser can, so its a permanent solution! You can actually extract the .db file from the simulator or device. See how here at the end: devdactic.com/ionic-4-sqlite-queries

[@sandeepkolli1219]

how to get printers list in my network and show as dropdown to set as default printer. Thanks in Advance

[@ConstantLANGNITO]

hello I have an application that works well with versions below Android 11 and 12 for the storage part. but for version 11 and 12 it does not work. I would like to know if : local storage ionic capacitor need permission in android 12 for API Level sdk 32?

[@marisolreyes3170]

What is the ionic capacity? Can it support about 50 mb data in query with SQLite?

[@galaxies_dev]

It's not a question of Ionic but of SQLite I think, but I'm not sure about its limitations.

[@KRYoung_dev]

Thank you for the great explanation, Simon! I wish it was possible to use SQLite with the browser, I am used to SQL for work so being able to run queries instead of constantly iterating JS objects would be awesome.

[@galaxies_dev]

Yeah there's no good fallback for that yet :/

[@RealAppsniksviks]

Thanks for the video

[@ferbai1]

Nice video👍

[@galaxies_dev]

Thanks Fer 👍

[@GamingwithTTfires]

How to save 100mb or larger size data?Can ionic storage save 100mb Or larger data?

[@galaxies_dev]

If you use the SQLite plugin you are only limited by the SQLite database limits - which afaik doesn't come with other limitation than your device storage!

[@pchasco]

The solution to the problem of SQLite missing on the web is to implement the repository pattern for data access. When running on capacitor provide the SQLite implementation in dependency injection. When running on the web, provide a different implementation that works in memory and persists to browser storage, or calls an external API hosted elsewhere.

[@galaxies_dev]

I actually think for the SQLite plugin there's now a web implementation available, at least I saw something on Github...

[@pchasco]

@@galaxies_dev Yes, I see that web is now supported!

[@JaroNavales]

Thanks!

[@galaxies_dev]

No problem!

[@KrelfallahHichem]

Thanks