Wireless sensor from Yun update MySQL

Official Hardware Classic Yún
1

Hi,

Please forgive my inexperience I am fairly new to all this.

I would like some guidance on approach for a project I am doing.

I have a number of large liquid tanks and I would like to read an ultrasonic sensor to find the depth of liquid and then send that data to a MySQL database (open to other database suggestions) on an external server. Currently
I have a yun and a weatherproof ultrasonic sensor from Maxbotix.

Because there are a number of tanks in different locations I will need a number of arduino boards and sensors which can update the database.

My initial thought was to have server side php code which would read the data from the sensor and them update the database but then I got the yun which has the Linux distribution on it, so in theory I could put the php (or other) code on there to update the database.

Once the data is in the database there will then be a website to read that data and display the information.

My questions are as follows:

  1. Do you reccomend using MySQL for this ?

  2. how do you suggest I go about updating the database?

  3. should I have separate tables for each tank location?

  4. what happens if a sensor loses wifi connection? Should I store it to an SD before it goes to a MySQL database

  5. can I also upload the date and time the reading was taken?

  6. where do I begin??

Thank you in advance ,

Charlie

2

(I have a can of time, and user forum, I hope you can facing a can on your questions.)
Edit: Holy **** traduction !
Hi! i'm here and waiting answer to my questions, hope can i help here !
I had a project like yours some years ago.

  1. Do you reccomend using MySQL for this ?
    Mysql is powerful enough in this case.
    (Storage, replication, reading, using PHP ... easy installation-LAMP-...)

  2. how do you suggest I go about updating the database?
    I was doing like http://???.???.??.???/update.php?ID=1&value=2&sensor=3
    You can secure it by restricting IPs ...

  3. should I have separate tables for each tank location?
    No, you can create Table like : ID,location,sensor,value

  4. what happens if a sensor loses wifi connection? Should I store it to an SD before it goes to a MySQL database
    Store it and send it to database will be a best option to never loose data, but need a little more code :
    When wifi connection back, send all data, erase buffer.

  5. can I also upload the date and time the reading was taken?
    Do it in Mysql/PHP can be a solution.
    But if data came from SDcard, you need to send it to server ...

Hope it can help.
Regards.
Benda.

3

benda95280:
2) how do you suggest I go about updating the database?
I was doing like http://???.???.??.???/update.php?ID=1&value=2&sensor=3
You can secure it by restricting IPs ...

Could you explain this approach to me please, I don't know very much about this technically.