Rn I am writing my thesis work, it is mobile app like myfitpal/lose it. Basically it tracks your calories and workouts.
Thing is that stupid me wrote that I will handle offline sync, so when user is offline he/she still be able to use appplication. But for backend server, I used MySql and as I recently learned it is unavaible in mobile devices so I need to store data in some other db like SqlLite.
But I DONT KNOW HOW.
I finished my application except offline sync.
I wrote code in ktor framwork, for frontend jetpackCompose, I used retrofit for connection. I made restApi for interaction. I have MVVM arch.
I tried to look for courses but I did not find any.

Is there anyone willing to give me concultation? I can pay for that even.
I am open for any kind of help

I tried a chatgpt, asking some people on internet. I also asked same topic in reddit.
All I need someone to help me to make synch of at least one table me, after that I will learn and implement it to other tables.
OR
if u know video/source to implement it to my project that is fine too.