Hey wanted to ask I am using MySQL as my DB and I plan to have a teammate to develop the mobile app. The mobile app is offline first. I just wanted to know from my end other than having the api controllers and writing all the requests in postman, should I use a different DB. I read that couchdb and pouchdb are good just haven’t seen updated repositories or use cases. Should I change my rdbms to nosql or just use sqllite. Maybe use mongodb. My main purpose is for mobile to have offline functionality so I know that it would be saved in android storage which is SQLite.
Basically the use case is there are forms that need to be filled and submitted let’s say for example a post. Basically the post will first be stored on the storage then synced. I think I need to recreate the dB structure in sqllite.
@devionti Why does offline functionality mean you need to change your database? What difference is the database choice going to make? Is MySQL available offline? No. But then neither is MariaDB, NoSQL databases, SQLite, etc.
The database choice doesn’t make a difference. The app is going to hold data locally until it gets an Internet connection and then send it to the server to be processed. The app doesn’t care if the server’s using a MySQL database or other once it’s back online.
