New Homepage Forums Sensor Shields transmit GPS data from arduino to mysql using python

This topic contains 2 replies, has 3 voices, and was last updated by avatar PatenLowe 1 year, 7 months ago. This post has been viewed 799 times

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #47093
    avatarafnanbasir93
    Participant

    Currently my arduino is attached with 1sheeld board. How i can transmit the latitude and longitude to mysql database. Somebody please help me 🙁

    #47120
    avatarAhmed ismail
    Keymaster

    Hi Afnan,

    If you can get an API from your database you can push the data through it using the internet shield like here in this project: https://1sheeld.com/log-noise-level-on-cloud-using-arduino-1sheeld/

    #126750
    avatarPatenLowe
    Participant

    Hi…The benefit of putting data into a MySQL db is that you can do some processing at a later point. One potential option would be to insert all records as you get them (so every second) then have something in place that will remove records older than a particular age so that you keep one valid result each minute over the last hour, then one valid result per 10 minutes over the last day etc.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.