Ionic Vue SQLite With Ionic Framework, and Capacitor

Ionic Vue SQLite With Ionic Framework, and Capacitor
#sqlite #ionic #vue

Build a CRUD App Using SQLite and the Capacitor Community Plugin for SQLite. We verify the application works on IOS, Android, and in the Browser.

This is a basic CRUD application and does not use any advanced plugin features like import, export, and encryption. I start with the vue + vite example from capacitor-community/sqlite documentation.

This example can work with the plugin and vue, there is no requirement for ionic framework, I just use it for the UI components

I am working on replacing the current Udemy course focusing on the basics here and the more advanced topics

💥 Chapters
--------------------------
00:00:00 - Intro
00:01:49 - Project Setup
00:06:55 - SQLite Setup In Application, and Test Basic Integration
00:27:00 - Verify SQLite Basic Integration In Browser
00:27:30 - Verify SQLite Basic Integration In IOS Simulator
00:31:00 - Add CRUD User Interface
00:32:24 - Add CRUD User Interface - Setup DB and Clean up on Component LifeCycle
00:41:40 - Add CRUD User Interface - Listing ( Read ) Database Data
00:46:24 - Add CRUD User Interface - Create Database Data
00:58:10 - Add CRUD User Interface - Delete Database Data
01:04:40 - Add CRUD User Interface - Update Database Data
01:23:12 - Clean up All "any" for better typescript
01:28:50 - Verify Application on Android

💥 Links
--------------------------

#ionicframework #vuejs

[PSnaki]

Thanks, I needed to find out how to use the plugin in capacitor 5. but receive error 'out of memory'

¿what functionality has the parameter "version" in the connection ?

[marxman]

Is there any tool to show tables and data created in the sqlite db? It seems created on indexeddb, but chrome only shows jeepsqlitestore.

[AyomideAfolabi-fc]

Hey man, great video. Really needed this for the project I'm working on. However, what do you do in the scenario there's a schema update and you need to run migrations, but there's data still saved in the using the previous schema?

[mamicadas]

Thanks a lot! You saved me, in the next week i gona start a project with this tech.

[buich]

Thanks a lot!
But is it possible to use any ORM's with this stack? Maybe TypeORM or Prisma?

[contentmatch]

God bless you ! Thank you for the knowledge

[aksharparmar]

Hey I hope you are doing well!
Can you Please make a detail video on with using react also?
Documentation is not beginner friendly, I am having a hard time, and the working example for capacitor-community/sqlite is something which is hard to understand.
It will be great if you can make a project using react with capacitor sqlite in detail.

[kyawzin]

I follow along the code however i got Error: out of memory error as soon as i call `await db.open();`

[RoseMiller-tvjz]

Hi! Will you make some for Angular as well please??

[AksoomHussain]

great tutorial, tried to implant the setup sqlite database work fine on android but don't save data on IOS device (restarting app and login don't save) and unable to debug that too,
any catch?, i use nuxt pinia and laravel backend

[Imaginativeone_DF]

Where does the database file get stored?

[AGUNGKAYA]

I tried many tutorial on ionic sqlite. Nothing's worked. I'll try this one

[andreshernandezlararwejioc]

can you give me some code or repo please