Shopify apps: how to install mysql in shopify react and php app and get table data from mysql table

Hey guys, im working on a shopify app with react and php template, in default sqllite came with the installation but i want to install mysql and get data from a table from my database.

  1. how to install mysql instead of sqlite?
  2. how to create connection and get data from table in php controller.

Are you using this template https://github.com/Shopify/shopify-app-template-php/.

Or any other, please specify, then can suggest the required changes to be make to connect with MySql instead sqlite

Hello,

You can use this package instead of SQLite one https://www.npmjs.com/package/@link-hooks/shopify-app-session-storage-mysql

Configure the configuration accordingly for MYSQL

yes im using this package

ok, after using this package, how can i use this to add, update records in db ?