Shop OBEX P1 Docs P2 Docs Learn Events
Propeller recording data on server — Parallax Forums

Propeller recording data on server

ProcessingData...ProcessingData... Posts: 208
edited 2015-05-31 16:00 in Propeller 1
Using an ESP8266 module, I've gotten simple number graphing working on my server.

http://data.taylorcoffelt.com/view/test

I have the propeller logging the clock value once every few seconds, creating a sawtooth plot. The program has been running for days, with fairly good accuracy. Once in a while the ESP8266 module will hang on a connection, but for the most part it's working fine.

When you bring up the page, it will only graph the points from the moment you load the page onward. However, every data entry is stored in an SQL database.
I'm working on a plotter that will allow me to view specific parts of the stored data.

I may soon change it to record sensor values instead of the clock value.

Comments

  • Cluso99Cluso99 Posts: 18,069
    edited 2015-05-30 17:29
    I have had good success using Lua on my es8266.

    What software are you using on your website to operate the SQL database?
  • ProcessingData...ProcessingData... Posts: 208
    edited 2015-05-30 20:54
    I'm still using the stock firmware for my modules; Lua seems like a good option, but I wanted to see how reliable I could get the original firmware to be with the propeller, despite the known issues with it.

    I'm using PHP to capture and insert the data into the database. Honestly, I could have used Python or even node, but I find that PHP seems to be "quick & easy" for most web-based things I need to work on. I was thinking about hooking up a spinnerete to capture the data, and store it on the SD.
  • localrogerlocalroger Posts: 3,451
    edited 2015-05-31 16:00
    PData depending on where you got your module, even if you plan to stick with AT command external control you might find it worthwhile to upgrade to the latest version of the ExpressIF firmware. My 01 modules lost several flaky and annoying behaviors and glitches when I did that.
Sign In or Register to comment.