I'm new to android development so I don't have a lot of experience. I am writing an application for a sewing workshop for two types of users: a technologist and a seamstress. The technologist sends the task to the seamstress. Is a sqlite suitable for such an application, or is it better to choose another one? If so, which one?

I have so far tried to write only simple applications where there was no need to use a database

CodePudding user response：

Yes and no. The problem is you don't just need a database. You also need a webservice in front of that database. The database can't just be on the device, because it needs to share data between the seamstress and technologist. That requires a DB in the cloud, and a webservice to protect access to that.

The DB can be SQLite, there's no reason that can't work. But in general it isn't- you generally would use MySQL, Posgres, or another open source db for this. SQLite is generally used where you need a local on device db and top performance is not a concern. For example storing data downloaded previously to your mobile phone. The other solutions perform much better, and will scale if you need to increase capacity in the future.

CodePudding user response：

My recommendation is to learn how to use Firebase database. You can store and retrive data with Realtime Database or Firestore Database using a data class, an adapter, a view model and a repository. You can start with this video: https://youtu.be/MFcMw9jJA9o