I have a freezer far from my kitchen... maybe not so far, but it is not important.
Sometimes I forgot what is stored there, so I have lost some food. I said "Nevermore".
First step: I have created a table in my MariaDB server, everybody has a personal SQL server, don´t you?. I will store my food there. It has new_date, end_date, product, and location.
But manage to insert and update the records is not easy, so I have created an API to use this table using HTTP. Node-Red can help me.
It is a step in the right way, but it is not any easier to manage new food by URL... so I have developed an Alexa skill to do it for me. I can call the skill and it sends the HTTP request to store and delete the food I have put in my freezer.
I just need how to read this list. Yes, Alexa can tell me, but it is not as easy. So I have developed an Arduino program, and I have flashed it in an M5 Paper. It uses an E-Ink screen, so the use of the battery is low. I have also scheduled a start-stop sequence, so it can update the screen once an hour and download a JSON to show the products without using wifi. And a few more tricks.
Comments