Android GPS to PostgreSQL

Замовник: AI | Опубліковано: 24.09.2025

I need an Android app that runs quietly in the background, captures the phone’s current GPS latitude and longitude every 60 seconds, and writes each reading—along with a server-side timestamp—to a remote PostgreSQL table. No user login or signup screens are required; the app should start reporting as soon as it is installed and granted location permission. Key behaviour • Operates as a foreground-service or similar approach that survives screen-lock, task-switching, and the system’s battery optimisations. • Reconnects automatically after network drops and queues unsent records until a connection is restored. • Sends data through an HTTPS REST endpoint or direct JDBC-style call—use whichever method is simpler to keep the APK size light—as long as the final write lands in PostgreSQL. • Each row must include: autogenerated device identifier, latitude, longitude, and the server-side timestamp of insertion. Deliverables 1. Android Studio project (Kotlin or Java) with clean, well-commented code. 2. Signed release APK ready for sideloading. 3. SQL script to create the required PostgreSQL table plus a short README showing where to place the connection string and credentials in the code. 4. Quick test guide: steps I can follow to install, run for ten minutes, and confirm at least ten new rows appear in the database. I will consider the work complete once the app reliably pushes location updates every 60 seconds for at least one hour on my test device without manual intervention.