All of this research and prototyping is occurring at Quinta Vale Da Lama.
April 13, 2020
Great talk on Sqllite, arguing that it's appropriate for a database located on 'the edge'.
24 Apr 2020
Simple test code for Adafruit Feather + RAK
05 May 2020
General setup for the RAK 7243 + Pi firmware is here.
Information about the configuration file is here.
The firmware we're using is here.
Can use 'gateway-config' command line script on RAK to set the region:
This script modifies this file:
Basic test code for sending data to the RAK in OTAA mode is in gist form here.
Changing the region on the Arduino requires modifing a special header file.
See the Adafruit Arduino tutorial here.
See the below snippet from the Adafruit Feather M0 LoRa 900 Mhz product page:
See this example serial output:
See the forum post here:
This might be a useful reference for setting up 868 band.
Current impression is that RAK hardware does indeed distinguish between 868 and 915 Mhz bands ... ?
05 May 2020 13:27 Update: there is a 'project_config' file located in the 'src' folder on in the lmic library folder itself -- and it's set to the US band -- perhaps this is overriding the project files? Trying setting it to EU and the RAK to EU. One open question is how specific the RAK Pi Hat is re: freq bands ... can it handle 868?
So the current thinking for getting 868 band to work is:
Meanwhile, note that upload via bossac did work on the Pi.
Confirmed -- was able to get upload on RAK in US '915' version by setting to '868' following above steps. Key seems to have been the Arduino library project_config folder issue.
Note: we are using mcci-catena arduino-lmic 2.3.2 version of library with success. Later versions haven't always worked. Stick with that for now.
As per instructions here:
BME280 ---> Feather
Using the BME280 can be accomplished by using the Adafruit BME280 Arduino Library, which also requires using the Adafruit Sensor Library.
An Adafruit tutorial is here. Note that we need the 'arduino' branch of the bossac tool on github, which is version 1.7.X.
sudo bossac -p /dev/ttyACM0 -e -w -v -R firmware.bin
Sensor not working on Walt's RAK. Q: is it because of connection to Feather / problem with Feather, or is it because of some setting on the Gateway?
Diagnostic: some basic BME280 test code, non-LoRa -- just prints values out to serial port. Wrote the binary, and then sent it to Walt's feather remotely -- and got back an error:
09 May 2020
Walt was able to fix the BME280 node by re-soldering nad re-wiring:
We've been able to get a local sqlite database up and running now, stored on a USB flash drive on the RAK:
And we added a field to the database that provides a human-readable date.