The first stockie tag(attached to serial port for debug) can now connect to the database and check the status of my coffee. This means that basic functionality in the tag software, gateway software and server side software is done, time to start building up on it. Here is the tag saying I am out of coffee(red led). It takes a lot of things to work together in order for this to happen, I had to develop software for the tag, the gateway(micro and router) and server while using C, bash, javascript, html, php and mysql and of course, everything has to work together.

And here is the tag saying I still have enough coffee(green led not that visible due to flash):

Some terminals for debugging: top is the tag data, middle is data going through the gateway microcontroller and at the bottom is the router