Cibus Tabula, Alexa Voice Interface to M5Paper E-Ink

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 managing 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 direction, 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 to be able to read this list. Yes, Alexa can tell me, but it is not as easy. So I have developed an Arduino program and 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 by only briefly enabling wifi. And a few more tricks.

 

 

                                                                                         Demo

 

 

 

                                                                        Stuck with a magnet to the fridge