IONIC REACT JS: How To Use SQLite For Preloading Content & Queries Full Tutorial

IONIC REACT JS: How To Use SQLite Capacitor Plugin In Ionic React Applications
#ionic #react #sqlite
Trying to get started with reactjs application using sqlite deployed to the mobile device. We cover database initialization, setup of loading content from JSON file, query for all items, and query for a specific item. This is all done on IOS device, android is similar but there are a few issues documented in the plugin documentation.

Part One – https://youtu.be/U65a0T3W6uY
Part Two – https://youtu.be/5cWn8y3z7c4

###
🚨Android is covered in the second part along with update and delete 🚨
https://youtu.be/5cWn8y3z7c4
###

🎓 Udemy Courses – https://www.udemy.com/user/aaronsaunders/
🎓 Gumroad Courses/Content – https://www.gumroad.com/fiwic

💥 CHAPTERS 💥
00:00:00 – Intro
00:00:50 – Courses Available on Udemy and Gumroad
00:02:15 – The Plugin we are using
00:03:00 – What has been installed and configure for LiveReload and App on IOS device
00:06:15 – Start Coding with Importin Files for Capacitor Plugin
00:07:08 – Connect to the database and open database
00:15:00 – Preloading Database Content using Plugin
00:24:00 – Query the database to get content out
00:33:00 – running into issues with useEffects, refactoring
00:38:00 – Rendering the results in the user interface
00:41:00 – Refactor all of the database functionality into a separate service
00:48:30 – Add function to get contact by id
00:55:08 – Adding the results to the user interface
01:02:10 – Refactor Home Page using smaller components starting with CurrentContact
01:05:10 – Refactor Home Page using smaller ContactList to render contacts
01:10:54 – Wrapup and review what we built

Code – https://github.com/aaronksaunders/ionic-react-sqlite-livestream
Plugin – https://github.com/capacitor-community/sqlite

🔥 Social Media 🔥
Twitter – https://twitter.com/aaronksaunders
Facebook – https://www.facebook.com/ClearlyInnovativeInc
Instagram – https://www.instagram.com/aaronksaunders/
Dev.to – https://dev.to/aaronksaunders
🌐 www.fiwic.com

-~-~~-~~~-~~-~-
Please watch: “Getting Started With Appwrite, Vue JS Ionic Framework & Capacitor”
https://www.youtube.com/watch?v=3d71O1zvlaw
-~-~~-~~~-~~-~-