This app was mentioned in 6 comments, with an average of 1.17 upvotes
thanks for your feedback!
Adding timestamps and GPS coords to entries is a good point indeed, I'm adding your idea to the ToDo list.
The functional heap window is currently ~30Kb (130Kb heap free after init, and becomes unstable under 100Kb), it offers up to an hour of stability before the heap runs out and the ESP restarts. Without this protection the .db file eventually gets corrupted and data is lost.
Moreover, the sqlite3 implementation has a hard limit on the amount of writes you can make on a single file and produces all sort of symptoms (including data loss) over this limit.
Because of this effect, I have to choose very carefully what code/library I add until I find what's leaking memory (probably my bad code, but could also be sqlite3 or the BLE library itself).
Maybe a GATT characteristic could provide that feature too?
What's funny is that the initial motivation of this project was to replicate the ESP8266 HoBo Clock idea by using BLE services while I had absolutely no idea if it could do it.
A) Get an external Bluetooth GPS receiver and pair it to your switch running Android (pricey but easier to configure)
B) Use an app to share GPS signal between your phone and the switch, something like Share GPS
C) ?
Sowas wäre auch noch eine Möglichkeit.
https://play.google.com/store/apps/details?id=com.jillybunch.shareGPS&hl=en
Damit dient dein Android Smartphone über Bluetooth als GPS-Maus.
Wenn du ohnehin ein x-beliebiges Notebook holst und bereits ein Android-Smartphone zur Verfügung steht, könnte man das Mal testen.
There are apps that will share your phone's GPS via bluetooth or similar local connection with the Fire. I've found they go right through your phone's battery since the combination of constant GPS + bluetooth tends to be very taxing.
It could be worth experimenting with a USB GPS module going right into the Fire (cheapest option), or perhaps a purpose built bluetooth GPS puck for the Fire. But if you're going to invest in a purpose built GPS device, it's worth just upgrading to a Stratux (not compatible with GP unfortunately).
I have used the application Share GPS on the android store for this very application. Granted, I was talking with a computer rather than a Arduino, but it shouldn't matter too much.
Try this one too perhaps
https://play.google.com/store/apps/details?id=com.jillybunch.shareGPS