What database to use for android application?

Question

Android

Hello.
I plan to create an application for Andoid (Directory of Drugs).
What database would be desirable to use for these purposes, if presumably there will be quite a lot of drugs?
Choosing between SQLite, MySQL, Apache Derby, PostgreSQL
Which one would you choose?

Answer 1

If on the device - then from all this only SQLite. +storIO.
On the server, it doesn't matter at all which one I worked with more. For API communication.

Answer 2

In general, the answer to this question strongly depends on the functionality of your application and what kind of data and how much you plan to store in the database. Without this detail, the question turns out to be very general, and the same answer can be expected.
If we are talking about several thousand records, then this can also be stored in SQLite on the client side. If we are talking about millions of records, then it is better to take it to the server side. The type and weight of this data is also important. If you plan to store only texts, then this can be stored on the client side as well. If you have files (for example, instructions for medicines) and images there, then such a database will weigh more and it is better to put it on the server.
If the functionality of your application does not involve a large load or specific work with data, then I would advise you to stop at SQLite. Subjectively, I get the impression that using MySQL or PostgreSQL for a drug directory is a cannonball. In any case, if the project "takes off", then you will rewrite everything from scratch and think carefully about the architecture :)

Answer 3

If to start and without problems - any ORM will help you. Google recommends Room, I personally prefer DBFlow.
If speed is important, but it's not a pity to spend time on trial - Realm. In terms of the speed of the application - Realm will wipe its nose even native SQLite