Hi,
Please allow me to assist you on this project as I have 5 years of experience working with IoT projects. I play and code for various types of microcontrollers including Arduino, Microchip PIC, TI ARM, Raspberry Pi, etc. I am also expert in wireless, serial, and USB communication, and I will be able to ensure that your data is perfectly transmitted even at a high packet rate.
For your projects, there are the two parts to get done:
1. Arduino code
- to interface with the sensor (i assume using RF)
- to communicate with Raspberry Pi (through serial)
2. Python script for Raspberry
- Store sensor's ID in sqlite database
- Send a request, which consists of a list of sensor IDs from the sqlite database, to an external web service, using your existing format (probably REST+JSON).
- Check the integrity of the response from the web service, and pass the commands to Arduino.
- Wait for confirmation from Arduino, then send ACK to web service.
Here is my proposal. My fee is negotiable. Hope to hear from you soon. Thanks.