Please help me make a design decision for my bachelor job. I have a small Symfon
ID: 3583896 • Letter: P
Question
Please help me make a design decision for my bachelor job. I have a small Symfony with Doctrine ORM web app for physical education teachers and I want to make it available for offline use in mobile devices.
Typical scenario:
In mobile app, teacher should login via google(in web app it's implemented with hwioauthbundle), insert students results into some local data storage and then, when there is an internet connection, send these results from local storage to mysql database.
Making a solution:
My idea is to create API and have an react native app that calls it. React native should have some local data storage like sqlite database (I have been searching and found realm.io, maybe that's an option too). I'm writing here because I am very new to these tools (even REST), don't know any of react native, just a little bit of react and I don't want to feel stupid spending a lot of time on wrong design decisions. So my questions are: Is there an easier way? What are some useful resources to learn and make this work? How to make login on mobile? I have no idea.
Explanation / Answer
As far as my knowledge sqlite is the only easiest option to create an API. It is also very dynamic but it is the weekly typed sql language and also it supports the ACID properties.
To learn sqlite internet is the best option, there is many best websites to get good knowledge on sqlite
And sqllite database system design and implementation is the best book to learn and sqlite for mobile apps simplified is another book which is also good to learn.