Skip to content

Communication between a SQL database and an embedded device.

Notifications You must be signed in to change notification settings

eiithel/mysql_raspberry_queries

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

51 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

mysql_raspberry_queries

This project aims to feed a data base hosted on a PC with sensor data coming from an embedded device such as a raspberry pi in order to provide some domotic services to several clients.

The card and the SQL server belong to the same local network.
For the moment, data recorded correspond to the ambient temperature in my room.
The values recorded are displayed in real time on a web page thanks to a php script which retrieve the informations in the database.

I will use the Qt framework on the client side in order to treat the information. When the temperature will be too high an email will be sent to my google mail account in order to notice me that something is wrong.

Of course for the moment I use a simple temperature sensor and that is not very useful but the modularity of the code will allow to add any type of sensor to the system.

The UML diagram pictured below is showing the relationship between each class of the system. (Raspberry side)

Raspberry UML

And here is the information collected from the SQL database via a PHP script:

About

Communication between a SQL database and an embedded device.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published