Arduino and SQL

Projects General Guidance
1

Hi all,

I'm very new in Arduino programming.

I need to realize the follow workflow:

  1. A counter in Arduino, that rises from an external relay (it is easy)
  2. Every time when the counter rises, in Arduino have to come a picture from external device;
  3. Arduino renames the picture with the actual counter value from a point 1.
  4. Arduino send the renamed picture in a SQL server (storage server)

Points 3 and 4 are hard for me, but if someone can help me with the entire process - it will be very nice.

Than's in advance

BR

Denis

2

You are to (somehow) receive a picture, that is a JPG or other image format file, onto an Arduino.
You then have to rename that file and store it file onto an SQL server. Is that right ?

A few questions:

Where are image files stored, which you have to load onto the Arduino ? On a web or SQL server ?
What Arduino have you been asked to use ?
What is the maximum size (bytes) of image file you have to handle ?
Have you some sample commands for loading an image file onto your SQL server ?

3

6v6gt:
You are to (somehow) receive a picture, that is a JPG or other image format file, onto an Arduino.
You then have to rename that file and store it file onto an SQL server. Is that right ?

  • Yes it is correct

6v6gt:
A few questions:

Where are image files stored, which you have to load onto the Arduino ? On a web or SQL server ?

  • On a storage in the local network

6v6gt:
What Arduino have you been asked to use ?

  • It does not mater for now: Uno, Mega....

6v6gt:
What is the maximum size (bytes) of image file you have to handle ?

  • Around 1 MB

6v6gt:
Have you some sample commands for loading an image file onto your SQL server ?

  • Not for now

Thank you

4

I doubt if an Arduino is the ideal solution for this.

It may just be possible, although I've never done anything like this, using say the ESP8266 with an SD card. Use an FTP client on the ESP8266 to fetch the file to the SD card (assuming your storage on the local network is accessible via FTP), rename the file on the SDcard, and stream the file (somehow, maybe using a Web method) to your SQL server. There may also be better ways of doing this.

Edit:

It may be, however, that an Arduino Yun (or similar Unix Hybrid) could be a possible platform for this and may have more possibilities for accessing your local file storage using SMB or similar.

5

This sounds to me more like a job for a raspberry Pi... Does it need to be on Arduino?

Does the arduino need to show the image? Or only the counter?

6

Kevin77:
This sounds to me more like a job for a raspberry Pi... Does it need to be on Arduino?

I prefer to be Arduino.

Kevin77:
Does the arduino need to show the image? Or only the counter?

Only the counter