Which database to choose for an Android application?

Question

Java

I am creating an android application on android studio using the Java language, the essence of the application is to search for gas stations throughout the country with fuel prices and the ability to edit prices by the user, what database can be used to store information about the user, and gas stations with their information?
Is it possible to use firebase realtime database for this?

Answer 1

If per device, then there are no alternatives to SQLite. If on the backend, then any.

Answer 2

If you want to store data in an application, use the Room library. It is a wrapper for a SQLite database, but it has limited functionality.
If you store data on a remote server, then MariaDB or MySQL will most likely be installed there.

Answer 3

A little off: what's the point for a user from Moscow to know the price at some kind of gas station in Krasnoyarsk? Maybe you should not store this data on the device itself, but just get by with Webview on the client + MySQL on the server? Strongly (many times) simplify the task of writing (useless - crossed out) application.