So I want to develop an online mobile application using android studio and java. A client mobile application that will send its location to the admin mobile application, so it will be using GPS. what is the best database to use here? I am currently choosing between firebase, postgresql and sqlite?
5
-
Do you want to run the database as part of an app on the Android inside the app or as a server on the internet?– RobertAug 27, 2022 at 11:06
-
it would be as a server on the internet, and also I want the database to be updated realtime, the faster the better– TimowAug 27, 2022 at 14:27
-
So when there's no network connection (e.g. tracking/hiking in the mountains), the app will be useless? I'd rather put it locally and use SQLite, which is well established with Android apps – then have the sync optional. And I'd avoid stuff that binds me to a specific provider – especially if that provider already has a history tracking its users (and not just restricted to location). If your app shall be FOSS, dependencies like Firebase would massively taint it (essentially it would no longer be FOSS as Firebase is not).– Izzy ♦Aug 27, 2022 at 16:17
-
PostgreSQL in combination with PostGIS is as far as I know a very common combination for a database with geo and location data. And for temporary local storage in the app (for offline times) SQLite is also common on Android.– RobertAug 27, 2022 at 20:06
-
so the application is for a school project and it would be intended to be use on emergency times only, so kind of like 911 but with geolocation tracking. based on you comments I wanted to use postgres and postgis but I cant seem to find tutorials on it. Thank you for you comments– TimowAug 28, 2022 at 5:15
Add a comment
|